DBA Data[Home] [Help]

APPS.FUN_XML_REPORT_PKG dependencies on PO_VENDOR_SITES_ALL

Line 216: PO_VENDOR_SITES_ALL PVS

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
219: AND FNAP.INVOICE_ID = API.INVOICE_ID
220: AND ALC.LOOKUP_CODE = API.INVOICE_TYPE_LOOKUP_CODE

Line 258: PO_VENDOR_SITES_ALL PVS,

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
260: ,sum(ail2.amount) vat_amount
261: from ap_invoices_all ai2
262: ,ap_invoice_lines_all ail2

Line 571: PO_VENDOR_SITES_ALL PVS

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
574: AND FNAP.INVOICE_ID = API.INVOICE_ID
575: AND ALC.LOOKUP_CODE = API.INVOICE_TYPE_LOOKUP_CODE

Line 610: PO_VENDOR_SITES_ALL PVS,

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