DBA Data[Home] [Help]

APPS.FUN_XML_REPORT_PKG dependencies on AP_LOOKUP_CODES

Line 214: AP_LOOKUP_CODES ALC,

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
218: AND FNAP.BATCH_ID = FNB.BATCH_ID

Line 255: AP_LOOKUP_CODES ALC,

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,
258: PO_VENDOR_SITES_ALL PVS,
259: (select ail2.invoice_id

Line 569: AP_LOOKUP_CODES ALC,

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
573: AND FNAP.BATCH_ID = FNB.BATCH_ID

Line 608: AP_LOOKUP_CODES ALC,

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,
612: (select ail2.invoice_id