APPS.WSH_MAPPING_DATA dependencies on WSH_CUSTOMER_LOCATIONS_V

Line 466: /* Patchset I: Locations Project. Selecting from wsh_customer_locations_v */

462: WHERE
463: WSFL.wsh_location_id = p_loc_id
464: AND WSFL.source_location_id = HL.location_id;
465:
466: /* Patchset I: Locations Project. Selecting from wsh_customer_locations_v */
467: CURSOR ship_to_info_cur(p_loc_id NUMBER, p_opUnit_id NUMBER DEFAULT NULL) IS
468: SELECT
469: DISTINCT wclv.CUSTOMER_NAME PARTY_NAME,
470: wclv.LOCATION PARTNER_LOCATION,

Line 484: wsh_customer_locations_v wclv

480: WCLV.POSTAL_CODE POSTAL_CODE,
481: WCLV.PROVINCE REGION,
482: WCLV.STATE STATE
483: FROM
484: wsh_customer_locations_v wclv
485: WHERE
486: wclv.wsh_location_id = p_loc_id
487: and wclv.org_id = nvl(p_opUnit_id, wclv.org_id)
488: AND wclv.customer_status = 'A'

Line 2256: FROM wsh_customer_locations_v wclv

2252: wclv.county county,
2253: wclv.postal_code postal_code,
2254: wclv.province region,
2255: wclv.state state
2256: FROM wsh_customer_locations_v wclv
2257: WHERE wclv.site_use_id = c_site_id
2258: AND wclv.org_id = c_opunit_id
2259: AND wclv.customer_status = 'A'
2260: AND wclv.cust_acct_site_status = 'A'

Line 2432: FROM wsh_customer_locations_v wclv

2428: wclv.county county,
2429: wclv.postal_code postal_code,
2430: wclv.province region,
2431: wclv.state state
2432: FROM wsh_customer_locations_v wclv
2433: WHERE wclv.wsh_location_id = c_loc_id
2434: AND wclv.org_id = nvl(c_opUnit_id, wclv.org_id)
2435: AND wclv.customer_status = 'A'
2436: AND wclv.cust_acct_site_status = 'A'

Line 2471: FROM wsh_customer_locations_v wclv

2467: wclv.county county,
2468: wclv.postal_code postal_code,
2469: wclv.province region,
2470: wclv.state state
2471: FROM wsh_customer_locations_v wclv
2472: WHERE wclv.site_use_id = c_site_id
2473: AND wclv.org_id = c_opunit_id
2474: AND wclv.customer_status = 'A'
2475: AND wclv.cust_acct_site_status = 'A'

Line 2948: from wsh_customer_locations_v

2944: county,
2945: postal_code,
2946: province,
2947: state
2948: from wsh_customer_locations_v
2949: where site_use_id = c_site_use_id;
2950:
2951: l_organization_id number;
2952: l_ship_from_location_id number;