DBA Data[Home] [Help]

APPS.FUN_XML_REPORT_PKG dependencies on PO_VENDORS

Line 215: PO_VENDORS PV,

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

Line 257: PO_VENDORS PV,

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

Line 570: PO_VENDORS PV,

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

Line 609: PO_VENDORS PV,

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