DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_SUPPLIER_CONTACTS_VAL_V

Line 7975: FROM po_supplier_contacts_val_v pscv,

7971: substr(l_textline,1,240),
7972: 'PO_CONTACT_WITHOUT_VALID_USER'
7973: FROM dual
7974: WHERE NOT EXISTS (SELECT 'Y'
7975: FROM po_supplier_contacts_val_v pscv,
7976: po_headers_gt poh,
7977: fnd_user fu
7978: WHERE pscv.vendor_contact_id = poh.vendor_contact_id
7979: AND pscv.vendor_site_id = poh.vendor_site_id -- bug 9865162, included the check for vendor_site_id