DBA Data[Home] [Help]

APPS.FUN_XML_REPORT_PKG dependencies on FUN_NET_AP_INVS_ALL

Line 211: FROM FUN_NET_AP_INVS_ALL FNAP,

207: PV.SEGMENT1 AS SUPPLIER_NUM,
208: PVS.VENDOR_SITE_CODE AS SITE,
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,

Line 251: FROM FUN_NET_AP_INVS_ALL FNAP,

247: FNAP.OPEN_AMT AS INV_RECKONING_OPEN_AMOUNT,
248: FNB.BATCH_CURRENCY AS RECKONING_CURRENCY,
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,

Line 566: FROM FUN_NET_AP_INVS_ALL FNAP,

562: PV.SEGMENT1 AS SUPPLIER_NUM,
563: PVS.VENDOR_SITE_CODE AS SITE,
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,

Line 605: FROM FUN_NET_AP_INVS_ALL FNAP,

601: FNAP.NETTED_AMT AS NETTED_AMT_BATCH_CURR,
602: FNB.BATCH_CURRENCY AS RECKONING_CURRENCY,
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,