APPS.PO_VAL_HEADERS2 dependencies on PO_SUPPLIERS_VAL_V

Line 693: -- validate vendor_id using po_suppliers_val_v

689:
690: -------------------------------------------------------------------------
691: -- validate vendorId is Not Null
692: -- validate vendorSiteId is Not Null
693: -- validate vendor_id using po_suppliers_val_v
694: -- validate vendor_site_id using po_supplier_sites_val_v
695: -- validate vendor_contact_id using po_vendor_contacts
696: -- validate vendor site CCR if approval status is APPROVED.
697: -------------------------------------------------------------------------

Line 771: FROM po_suppliers_val_v psv

767: PO_VAL_CONSTANTS.c_vendor_valid)
768: FROM DUAL
769: WHERE p_vendor_id_tbl(i) IS NULL
770: OR NOT EXISTS(SELECT 1
771: FROM po_suppliers_val_v psv
772: WHERE p_vendor_id_tbl(i) = psv.vendor_id);
773:
774: IF (SQL%ROWCOUNT > 0) THEN
775: x_result_type := po_validations.c_result_type_failure;