AP Trial Balance query in R12.2
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,