DBA Data[Home] [Help]

APPS.PO_PDOI_HEADER_PROCESS_PVT dependencies on PO_VENDOR_CONTACTS

Line 2839: FROM po_vendor_contacts

2835: INSERT INTO po_session_gt(key, num1, num2)
2836: SELECT p_key,
2837: p_index_tbl(i),
2838: vendor_contact_id
2839: FROM po_vendor_contacts
2840: WHERE x_vendor_contact_id_tbl(i) IS NULL
2841: AND p_vendor_contact_tbl(i) IS NOT NULL
2842: AND p_vendor_site_id_tbl(i) IS NOT NULL
2843: AND last_name||' '||first_name = p_vendor_contact_tbl(i)

Line 3490: FROM po_vendor_contacts

3486: SELECT p_key,
3487: p_index_tbl(i),
3488: max(vendor_contact_id),
3489: vendor_site_id
3490: FROM po_vendor_contacts
3491: WHERE p_vendor_site_id_tbl(i) IS NOT NULL
3492: AND x_vendor_contact_id_tbl(i) IS NULL
3493: AND vendor_site_id = p_vendor_site_id_tbl(i)
3494: AND TRUNC(sysdate) < NVL(inactive_date, TRUNC(sysdate + 1))