APPS.WSH_MAPPING_DATA dependencies on WSH_SHIP_FROM_ORG_LOCATIONS_V

Line 437: wsh_ship_from_org_locations_v */

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

Line 459: wsh_ship_from_org_locations_v WSFL,

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