Payables and Cash Management - EBS (MOSC)

MOSC Banner

SQL Query Extract Supplier Balances in R12.2.4

1) Please let me know how do i get supplier balances with details as below :vendor name, vendor number, address, email address and if possible current balance. Wht is the right condition for all the vendors we used in the last 3 years.

2: I got all but Supplier columns but current open balances i am figuring out. Is there any standard seeded function which I can use to get supplier open balances at any time ?

3) What is the right condition for all the vendors we use for the last 3 years.?

4) Is there any seeded report we can use it Supplier Balances ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center