AP invoice tax query in oracle apps

AP invoice tax query in oracle apps

Hi Friends, We are going to discuss the AP Invoice Tax Query in Oracle Apps. This Query will help to extract the Taxes applied to AP invoices in Oracle apps. In Oracle apps , All tax related informations do stores in different Taxes tables. To extract the AP Invoice tax information's we need to use these taxes tables in oracle apps. AP invoice tax details do stores in ZX tables. All tax related information's do store in these ZX tables. We need to use all these tax tables to develop the AP invoice tax query in oracle apps. We can use this query will help to fetch these AP invoice tax details in Oracle Apps. Please find below the detail about AP invoice tax query in oracle apps and the important tables uses to store the AP Invoice tax details in oracle apps.

AP invoice tax query in oracle apps

Important Tables Used by AP invoice tax query in oracle apps

1.ZX_LINES_DET_FACTORS

2.ZX_LINES

Detail Level AP invoice tax query in oracle apps

Here below is the sql Query to extract the AP Invoice tax query in oracle apps. This is the complete AP invoice tax query in oracle apps.

select  a1.invoice_num,     

a1.invoice_currency_code,

DECODE(a1.PAYMENT_STATUS_FLAG,'N','UN-PAID','P','Partial Paid','Y','PAID') PAYMENT_STATUS_FLAG ,

 a1.invoice_date,

sum(nvl(a1.UNROUNDED_TAX_AMT,0))  from apps.ZX_LINES a1, ap_invoices_all a2,

ZX_LINES_DET_FACTORS a3

where a1.trx_id=a2.invoice_id

and a1.trx_id = a3.trx_id

and a2.invoice_number=:P_invoice_number 

AP invoice tax query in oracle apps

AP invoice tax query in oracle apps