APPS.WSH_AUTO_MANIFEST dependencies on WSH_CUSTOMER_LOCATIONS_V

Line 317: /*Patchset I: Locations Project. Use ui_location_code from wsh_customer_locations_v */

313: FROM HZ_CUST_ACCOUNTS HCA, HZ_PARTIES HP
314: WHERE HP.PARTY_ID = HCA.PARTY_ID
315: AND HP.PARTY_ID = pc_customer_id;
316:
317: /*Patchset I: Locations Project. Use ui_location_code from wsh_customer_locations_v */
318:
319: CURSOR get_location(pc_location_id NUMBER) IS
320: SELECT wclv.ui_location_code
321: FROM

Line 322: wsh_customer_locations_v wclv

318:
319: CURSOR get_location(pc_location_id NUMBER) IS
320: SELECT wclv.ui_location_code
321: FROM
322: wsh_customer_locations_v wclv
323: WHERE wclv.wsh_location_id = pc_location_id
324: AND wclv.customer_status = 'A'
325: AND wclv.cust_acct_site_status = 'A'
326: AND wclv.site_use_status = 'A'