APPS.WSH_AUTO_MANIFEST dependencies on WSH_CUSTOMER_LOCATIONS_V

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

416: FROM HZ_CUST_ACCOUNTS HCA, HZ_PARTIES HP
417: WHERE HP.PARTY_ID = HCA.PARTY_ID
418: AND HP.PARTY_ID = pc_customer_id;
419:
420: /*Patchset I: Locations Project. Use ui_location_code from wsh_customer_locations_v */
421:
422: CURSOR get_location(pc_location_id NUMBER) IS
423: SELECT wclv.ui_location_code
424: FROM

Line 425: wsh_customer_locations_v wclv

421:
422: CURSOR get_location(pc_location_id NUMBER) IS
423: SELECT wclv.ui_location_code
424: FROM
425: wsh_customer_locations_v wclv
426: WHERE wclv.wsh_location_id = pc_location_id
427: AND wclv.customer_status = 'A'
428: AND wclv.cust_acct_site_status = 'A'
429: AND wclv.site_use_status = 'A'