DBA Data[Home] [Help]

APPS.FUN_XML_REPORT_PKG dependencies on PO_VENDORS

Line 231: PO_VENDORS PV,

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
235: AND FNAP.INVOICE_ID = API.INVOICE_ID

Line 277: PO_VENDORS PV,

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
280: ,sum(ail2.amount) vat_amount
281: from ap_invoices_all ai2

Line 618: PO_VENDORS PV,

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

Line 683: PO_VENDORS PV,

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
687: ,sum(ail2.amount) vat_amount