[Home] [Help]
1158:
1159: -- Get site_use_id for the inventory location id
1160: CURSOR cust_site_cur IS
1161: SELECT pol.customer_id, pol.site_use_id, cust_acct.cust_account_id
1162: FROM PO_LOCATION_ASSOCIATIONS_ALL pol,
1163: HZ_CUST_ACCT_SITES_ALL cust_acct,
1164: HZ_CUST_SITE_USES_ALL site_use
1165: WHERE pol.location_id = l_header_rec.ship_to_location_id
1166: AND site_use.site_use_id = pol.site_use_id