Query to get cancelled invoices in oracle apps

Query to get cancelled invoices in oracle apps

In this post , we will discuss about Query to get cancelled invoices in oracle apps . This query helps to extract the complete AP invoices information which are cancelled in system. This also helps to identify the User Information's who cancelled these AP Invoices. Here below is the complete Query to get cancelled invoices in oracle apps.

 

 

Sample Query to get cancelled invoices in oracle apps

select pv.vendor_name,
assa.vendor_site_code,
aia.INVOICE_NUM,
aia.INVOICE_CURRENCY_CODE,
INVOICE_DATE,
INVOICE_TYPE_LOOKUP_CODE,
aia.DESCRIPTION,
aia.INVOICE_AMOUNT,
fu.user_name "Cancelled By"
 from ap_invoices_all aia,
 po_vendors pv,
 ap_supplier_sites_all assa,
 fnd_user fu
where cancelled_date is not null
and cancelled_by is not null
and aia.VENDOR_ID=pv.VENDOR_ID
and aia.org_id=:P_ORG_ID
and pv.vendor_id=assa.vendor_id
and aia.vendor_site_id=assa.vendor_site_id
and aia.cancelled_by=fu.user_id