DBA Data[Home] [Help]

APPS.PO_VAL_HEADERS2 dependencies on PO_SUPPLIER_SITES_VAL_V

Line 694: -- validate vendor_site_id using po_supplier_sites_val_v

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

Line 809: FROM po_supplier_sites_val_v pssv

805: FROM DUAL
806: WHERE p_vendor_id_tbl(i) IS NOT NULL
807: AND ( p_vendor_site_id_tbl(i) IS NULL
808: OR NOT EXISTS(SELECT 1
809: FROM po_supplier_sites_val_v pssv
810: WHERE p_vendor_id_tbl(i) = pssv.vendor_id
811: AND p_vendor_site_id_tbl(i) = pssv.vendor_site_id));
812:
813: IF (SQL%ROWCOUNT > 0) THEN