APPS.PO_VAL_HEADERS2 dependencies on PO_SUPPLIER_SITES_VAL_V

Line 701: -- validate vendor_site_id using po_supplier_sites_val_v

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: -------------------------------------------------------------------------
705: PROCEDURE vendor_info(

Line 819: FROM po_supplier_sites_val_v pssv

815: WHERE p_vendor_id_tbl(i) IS NOT NULL
816: AND ( p_vendor_site_id_tbl(i) IS NULL AND p_type_lookup_code_tbl(i) <> 'QUOTATION' ) /* 8913559 */
817: OR ( p_vendor_site_id_tbl(i) IS NOT NULL
818: AND NOT EXISTS(SELECT 1
819: FROM po_supplier_sites_val_v pssv
820: WHERE p_vendor_id_tbl(i) = pssv.vendor_id
821: AND p_vendor_site_id_tbl(i) = pssv.vendor_site_id));
822:
823: IF (SQL%ROWCOUNT > 0) THEN