Payables and Cash Management - EBS (MOSC)

MOSC Banner

AP Trial Balance query in R12.2

edited Jul 25, 2016 8:19PM in Payables and Cash Management - EBS (MOSC) 2 commentsAnswered

Hi Team,

i need AP Trial Balance query in r12.2, where i build the query in 11i, which is working fine. but when we upgraded to r12.2. here the table ap_liability_balance is no longer used. please help me to build the query.


our 11i query:

select alb.invoice_id invoice_id,inv.invoice_num,inv.description inv_description,

alb.vendor_id vendor_id,pv.segment1 vendor#,pv.vendor_name,

alb.code_combination_id code_combination_id,

sum(ae_invoice_amount) invoice_amount,

sum (alb.accounted_cr) - sum (alb.accounted_dr) remaining_amount,

alb.set_of_books_id set_of_books_id,

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