APPS.FUN_XML_REPORT_PKG dependencies on FUN_NET_AP_INVS_ALL

Line 227: FROM FUN_NET_AP_INVS_ALL FNAP,

223: PV.SEGMENT1 AS SUPPLIER_NUM,
224: PVS.VENDOR_SITE_CODE AS SITE,
225: PV.NUM_1099 AS SUPPLIER_TAXPAYER_ID,
226: PV.VAT_REGISTRATION_NUM AS SUPPLIER_TAX_REGN_NUM
227: FROM FUN_NET_AP_INVS_ALL FNAP,
228: FUN_NET_BATCHES_ALL FNB,
229: AP_INVOICES_ALL API,
230: AP_LOOKUP_CODES ALC,
231: PO_VENDORS PV,

Line 271: FROM FUN_NET_AP_INVS_ALL FNAP,

267: LTRIM(TO_CHAR(FNAP.OPEN_AMT,''999999999999999999999.999999999999'')) AS INV_RECKONING_OPEN_AMOUNT,
268: FNB.BATCH_CURRENCY AS RECKONING_CURRENCY,
269: MIN(APS.DUE_DATE) AS DUE_DATE,
270: LTRIM(TO_CHAR(SUM(nvl(vat.vat_amount,0)),''999999999999999999999.999999999999'')) AS VAT_AMOUNT
271: FROM FUN_NET_AP_INVS_ALL FNAP,
272: FUN_NET_BATCHES_ALL FNB,
273: AP_INVOICES_ALL API,
274: ap_invoice_lines_all ail,
275: AP_LOOKUP_CODES ALC,

Line 614: FROM FUN_NET_AP_INVS_ALL FNAP,

610: PVS.CITY AS SUPPLIER_CITY,
611: PVS.STATE AS SUPPLIER_STATE,
612: PVS.ZIP AS SUPPLIER_ZIP,
613: PVC.FIRST_NAME||' '||PVC.LAST_NAME AS CONTACT_FIRST_LAST_NAME
614: FROM FUN_NET_AP_INVS_ALL FNAP,
615: FUN_NET_BATCHES_ALL FNB,
616: AP_INVOICES_ALL API,
617: AP_LOOKUP_CODES ALC,
618: PO_VENDORS PV,

Line 679: FROM FUN_NET_AP_INVS_ALL FNAP,

675: LTRIM(TO_CHAR(decode(FNAP.NETTED_AMT,0,null,FNAP.NETTED_AMT),''999999999999999999999.999999999999'')) AS NETTED_AMT_BATCH_CURR,
676: FNB.BATCH_CURRENCY AS RECKONING_CURRENCY,
677: AC.CHECK_NUMBER AS PAYMENT_NUMBER,
678: LTRIM(TO_CHAR(SUM(nvl(vat.vat_amount,0)),''999999999999999999999.999999999999'')) AS VAT_AMOUNT
679: FROM FUN_NET_AP_INVS_ALL FNAP,
680: FUN_NET_BATCHES_ALL FNB,
681: AP_INVOICES_ALL API,
682: AP_LOOKUP_CODES ALC,
683: PO_VENDORS PV,