DBA Data[Home] [Help]

APPS.PO_PDOI_HEADER_PROCESS_PVT dependencies on PO_VENDOR_CONTACTS

Line 2330: FROM po_vendor_contacts

2326: INSERT INTO po_session_gt(key, num1, num2)
2327: SELECT p_key,
2328: p_index_tbl(i),
2329: vendor_contact_id
2330: FROM po_vendor_contacts
2331: WHERE x_vendor_contact_id_tbl(i) IS NULL
2332: AND p_vendor_contact_tbl(i) IS NOT NULL
2333: AND p_vendor_site_id_tbl(i) IS NOT NULL
2334: AND last_name||' '||first_name = p_vendor_contact_tbl(i)

Line 2978: FROM po_vendor_contacts

2974: SELECT p_key,
2975: p_index_tbl(i),
2976: max(vendor_contact_id),
2977: vendor_site_id
2978: FROM po_vendor_contacts
2979: WHERE p_vendor_site_id_tbl(i) IS NOT NULL
2980: AND x_vendor_contact_id_tbl(i) IS NULL
2981: AND vendor_site_id = p_vendor_site_id_tbl(i)
2982: AND TRUNC(sysdate) < NVL(inactive_date, TRUNC(sysdate + 1))