APPS.WSH_MAPPING_DATA dependencies on WSH_SHIP_FROM_ORG_LOCATIONS_V

Line 438: wsh_ship_from_org_locations_v */

434: FROM wsh_new_deliveries
435: WHERE delivery_id = p_delivery_id;
436:
437: /* Patchset I: Locations Project. Select address components from
438: wsh_ship_from_org_locations_v */
439: CURSOR ship_from_info_cur(p_org_id NUMBER, p_loc_id NUMBER) IS
440: SELECT
441: WSFL.ORGANIZATION_NAME PARTY_NAME,
442: HL.LOCATION_CODE PARTNER_LOCATION,

Line 460: wsh_ship_from_org_locations_v WSFL,

456: HL.TELEPHONE_NUMBER_2 FAX_NUMBER,
457: HL.TELEPHONE_NUMBER_1 TELEPHONE,
458: NULL URL
459: FROM
460: wsh_ship_from_org_locations_v WSFL,
461: HR_LOCATIONS_ALL HL
462: WHERE
463: WSFL.wsh_location_id = p_loc_id
464: AND WSFL.source_location_id = HL.location_id;

Line 2412: FROM wsh_ship_from_org_locations_v wsfl,

2408: NULL county,
2409: wsfl.postal_code postal_code,
2410: wsfl.province region,
2411: wsfl.state state
2412: FROM wsh_ship_from_org_locations_v wsfl,
2413: hr_locations_all hl
2414: WHERE wsfl.wsh_location_id = c_loc_id
2415: AND wsfl.source_location_id = hl.location_id;
2416:

Line 2921: from wsh_ship_from_org_locations_v

2917: county,
2918: postal_code,
2919: province,
2920: state
2921: from wsh_ship_from_org_locations_v
2922: where wsh_location_id = c_loc_id
2923: and organization_id = c_organization_id;
2924:
2925: CURSOR c_cust_name(c_customer_id IN NUMBER)