DBA Data[Home] [Help]

APPS.FUN_XML_REPORT_PKG dependencies on PO_VENDOR_SITES_ALL

Line 232: PO_VENDOR_SITES_ALL PVS

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
236: AND ALC.LOOKUP_CODE = API.INVOICE_TYPE_LOOKUP_CODE

Line 278: PO_VENDOR_SITES_ALL PVS,

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
282: ,ap_invoice_lines_all ail2

Line 619: PO_VENDOR_SITES_ALL PVS,

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

Line 684: PO_VENDOR_SITES_ALL PVS,

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
688: from ap_invoices_all ai2