APPS.POS_REQUEST_UTILS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 41

	SELECT po_vendor_id, vendor_party_id
	  FROM pos_supplier_registrations
	 WHERE supplier_reg_id = p_supplier_reg_id;

Line: 84

	SELECT pv.vendor_id, pvsa.party_site_id, pvsa.vendor_site_id
	  FROM po_vendors pv, po_vendor_sites_all pvsa
	 WHERE pv.vendor_id = pvsa.vendor_id
	   AND pv.party_id = p_supplier_party_id
	   AND pvsa.org_id = p_org_id;

Line: 91

	SELECT fu.person_party_id
	  FROM fnd_user fu, pos_supplier_users_v psuv
	 WHERE fu.user_id = psuv.user_id
	   AND psuv.vendor_id = x_vendor_id
	  ORDER BY fu.creation_date;

Line: 133

	SELECT contact_party_id
	  FROM pos_contact_requests pcr
	 WHERE contact_request_id = p_contact_req_id;