DBA Data[Home] [Help]

APPS.FUN_XML_REPORT_PKG dependencies on PO_VENDOR_CONTACTS

Line 620: PO_VENDOR_CONTACTS PVC

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

Line 632: FROM PO_VENDOR_CONTACTS

628: AND PVS.VENDOR_SITE_ID = PVC.VENDOR_SITE_ID (+)
629: AND NVL(TRUNC(PVC.INACTIVE_DATE (+) ), SYSDATE + 1) > SYSDATE
630: AND NVL(PVC.VENDOR_CONTACT_ID , -9999) = (
631: SELECT VENDOR_CONTACT_ID
632: FROM PO_VENDOR_CONTACTS
633: WHERE VENDOR_SITE_ID = PVC.VENDOR_SITE_ID
634: AND NVL(TRUNC(INACTIVE_DATE), SYSDATE + 1)
635: > SYSDATE
636: AND ROWNUM = 1