133: SELECT min(pla.location_id) inv_loc_id
134: into l_location_id
135: from csp_rs_cust_relations rcr,
136: hz_cust_acct_sites cas,
137: hz_cust_site_uses csu,
138: po_location_associations pla,
139: csp_sec_inventories csi
140: where rcr.customer_id = cas.cust_account_id
141: and cas.cust_acct_site_id = csu.cust_acct_site_id