eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_UTIL_CORE dependencies on WSH_DELIVERY_DETAILS

Line 2531: FROM wsh_delivery_details

2527: l_delivery_detail_id NUMBER;
2528:
2529: CURSOR c_get_lpns (v_delivery_detail_id number) IS
2530: SELECT lpn_id
2531: FROM wsh_delivery_details
2532: WHERE delivery_detail_id = v_delivery_detail_id;
2533:
2534: CURSOR c_get_valid_lpns (v_delivery_detail_id NUMBER) IS
2535: select lpn_id, delivery_detail_id FROM

Line 3101: v_first_code wsh_delivery_details.shipment_priority_code%TYPE;

3097:
3098: FUNCTION derive_shipment_priority(p_delivery_id IN NUMBER)
3099: RETURN VARCHAR2 IS
3100:
3101: v_first_code wsh_delivery_details.shipment_priority_code%TYPE;
3102: v_ship_code wsh_delivery_details.shipment_priority_code%TYPE;
3103:
3104: CURSOR get_ship_codes IS
3105: SELECT wdd.shipment_priority_code ship_priority_code

Line 3102: v_ship_code wsh_delivery_details.shipment_priority_code%TYPE;

3098: FUNCTION derive_shipment_priority(p_delivery_id IN NUMBER)
3099: RETURN VARCHAR2 IS
3100:
3101: v_first_code wsh_delivery_details.shipment_priority_code%TYPE;
3102: v_ship_code wsh_delivery_details.shipment_priority_code%TYPE;
3103:
3104: CURSOR get_ship_codes IS
3105: SELECT wdd.shipment_priority_code ship_priority_code
3106: FROM wsh_delivery_details wdd,

Line 3106: FROM wsh_delivery_details wdd,

3102: v_ship_code wsh_delivery_details.shipment_priority_code%TYPE;
3103:
3104: CURSOR get_ship_codes IS
3105: SELECT wdd.shipment_priority_code ship_priority_code
3106: FROM wsh_delivery_details wdd,
3107: wsh_delivery_assignments_v wda
3108: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
3109: AND nvl(wdd.LINE_DIRECTION , 'O') IN ('O', 'IO') -- J Inbound Logistics jckwok
3110: AND wda.delivery_id = p_delivery_id

Line 3117: FROM wsh_delivery_details wdd,

3113: AND rownum = 1;
3114:
3115: CURSOR get_ship_codes1(p_ship_code IN VARCHAR2) IS
3116: SELECT wdd.shipment_priority_code ship_priority_code
3117: FROM wsh_delivery_details wdd,
3118: wsh_delivery_assignments_v wda
3119: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
3120: AND nvl(wdd.LINE_DIRECTION , 'O') IN ('O', 'IO') -- J Inbound Logistics jckwok
3121: AND wda.delivery_id = p_delivery_id

Line 3130: FROM wsh_delivery_details wdd,

3126: AND rownum = 1;
3127:
3128: CURSOR get_ship_codes2 IS
3129: SELECT wdd.shipment_priority_code ship_priority_code
3130: FROM wsh_delivery_details wdd,
3131: wsh_delivery_assignments_v wda
3132: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
3133: AND nvl(wdd.LINE_DIRECTION , 'O') IN ('O', 'IO') -- J Inbound Logistics jckwok
3134: AND wda.delivery_id = p_delivery_id

Line 3973: wsh_delivery_details wdd

3969: 'get_operatingUnit_id';
3970: CURSOR c_orgs (v_delivery_id NUMBER) IS
3971: SELECT wdd.org_id org_id , count(*) cnt
3972: FROM wsh_delivery_assignments_v wda,
3973: wsh_delivery_details wdd
3974: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
3975: AND wda.delivery_id = v_delivery_id
3976: AND wdd.container_flag = 'N'
3977: GROUP BY org_id

Line 7653: wsh_delivery_details wdd

7649: cursor c_get_lpn_delivery_status( c_lpn_id NUMBER) is
7650: select distinct wnd.delivery_id, wnd.status_code
7651: from wsh_new_deliveries wnd,
7652: wsh_delivery_assignments_v wda,
7653: wsh_delivery_details wdd
7654: where wnd.delivery_id (+) = wda.delivery_id
7655: and wda.delivery_detail_id = wdd.delivery_detail_id
7656: --LPN Reuse project
7657: and wdd.released_status = 'X'