APPS.FUN_XML_REPORT_PKG dependencies on AP_INVOICES_ALL

Line 213: AP_INVOICES_ALL API,

209: PV.NUM_1099 AS SUPPLIER_TAXPAYER_ID,
210: PV.VAT_REGISTRATION_NUM AS SUPPLIER_TAX_REGN_NUM
211: FROM FUN_NET_AP_INVS_ALL FNAP,
212: FUN_NET_BATCHES_ALL FNB,
213: AP_INVOICES_ALL API,
214: AP_LOOKUP_CODES ALC,
215: PO_VENDORS PV,
216: PO_VENDOR_SITES_ALL PVS
217: WHERE FNAP.BATCH_ID = p_batch_id

Line 253: AP_INVOICES_ALL API,

249: MIN(APS.DUE_DATE) AS DUE_DATE,
250: SUM(nvl(vat.vat_amount,0)) AS VAT_AMOUNT
251: FROM FUN_NET_AP_INVS_ALL FNAP,
252: FUN_NET_BATCHES_ALL FNB,
253: AP_INVOICES_ALL API,
254: ap_invoice_lines_all ail,
255: AP_LOOKUP_CODES ALC,
256: AP_PAYMENT_SCHEDULES_ALL APS,
257: PO_VENDORS PV,

Line 261: from ap_invoices_all ai2

257: PO_VENDORS PV,
258: PO_VENDOR_SITES_ALL PVS,
259: (select ail2.invoice_id
260: ,sum(ail2.amount) vat_amount
261: from ap_invoices_all ai2
262: ,ap_invoice_lines_all ail2
263: ,ap_tax_codes_all atc
264: where ai2.vendor_id = :SUPPLIER_ID
265: and ai2.vendor_site_id = :SITE_ID

Line 568: AP_INVOICES_ALL API,

564: PV.NUM_1099 AS SUPPLIER_TAXPAYER_ID,
565: PV.VAT_REGISTRATION_NUM AS SUPPLIER_TAX_REGN_NUM
566: FROM FUN_NET_AP_INVS_ALL FNAP,
567: FUN_NET_BATCHES_ALL FNB,
568: AP_INVOICES_ALL API,
569: AP_LOOKUP_CODES ALC,
570: PO_VENDORS PV,
571: PO_VENDOR_SITES_ALL PVS
572: WHERE FNAP.BATCH_ID = p_batch_id

Line 607: AP_INVOICES_ALL API,

603: AC.CHECK_NUMBER AS PAYMENT_NUMBER,
604: SUM(nvl(vat.vat_amount,0)) AS VAT_AMOUNT
605: FROM FUN_NET_AP_INVS_ALL FNAP,
606: FUN_NET_BATCHES_ALL FNB,
607: AP_INVOICES_ALL API,
608: AP_LOOKUP_CODES ALC,
609: PO_VENDORS PV,
610: PO_VENDOR_SITES_ALL PVS,
611: AP_CHECKS_ALL AC,

Line 614: from ap_invoices_all ai2

610: PO_VENDOR_SITES_ALL PVS,
611: AP_CHECKS_ALL AC,
612: (select ail2.invoice_id
613: ,sum(ail2.amount) vat_amount
614: from ap_invoices_all ai2
615: ,ap_invoice_lines_all ail2
616: ,ap_tax_codes_all atc
617: where ai2.vendor_id = :SUPPLIER_ID
618: and ai2.vendor_site_id = :SITE_ID