DBA Data[Home] [Help]

APPS.WSH_MAPPING_DATA dependencies on WSH_CUSTOMER_LOCATIONS_V

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

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

Line 483: wsh_customer_locations_v wclv

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