APPS.FUN_XML_REPORT_PKG dependencies on AP_LOOKUP_CODES

Line 230: AP_LOOKUP_CODES ALC,

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,
232: PO_VENDOR_SITES_ALL PVS
233: WHERE FNAP.BATCH_ID = p_batch_id
234: AND FNAP.BATCH_ID = FNB.BATCH_ID

Line 275: AP_LOOKUP_CODES ALC,

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,
276: AP_PAYMENT_SCHEDULES_ALL APS,
277: PO_VENDORS PV,
278: PO_VENDOR_SITES_ALL PVS,
279: (select ail2.invoice_id

Line 617: AP_LOOKUP_CODES ALC,

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,
619: PO_VENDOR_SITES_ALL PVS,
620: PO_VENDOR_CONTACTS PVC
621: WHERE FNAP.BATCH_ID = p_batch_id

Line 682: AP_LOOKUP_CODES ALC,

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,
684: PO_VENDOR_SITES_ALL PVS,
685: AP_CHECKS_ALL AC,
686: (select ail2.invoice_id