APPS.PO_VAL_HEADERS2 dependencies on PO_SUPPLIERS_VAL_V

Line 700: -- validate vendor_id using po_suppliers_val_v

696:
697: -------------------------------------------------------------------------
698: -- validate vendorId is Not Null
699: -- validate vendorSiteId is Not Null
700: -- validate vendor_id using po_suppliers_val_v
701: -- validate vendor_site_id using po_supplier_sites_val_v
702: -- validate vendor_contact_id using po_vendor_contacts
703: -- validate vendor site CCR if approval status is APPROVED.
704: -------------------------------------------------------------------------

Line 780: FROM po_suppliers_val_v psv

776: PO_VAL_CONSTANTS.c_vendor_valid)
777: FROM DUAL
778: WHERE p_vendor_id_tbl(i) IS NULL
779: OR NOT EXISTS(SELECT 1
780: FROM po_suppliers_val_v psv
781: WHERE p_vendor_id_tbl(i) = psv.vendor_id);
782:
783: IF (SQL%ROWCOUNT > 0) THEN
784: x_result_type := po_validations.c_result_type_failure;