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 2567: FROM wsh_delivery_details

2563: l_delivery_detail_id NUMBER;
2564:
2565: CURSOR c_get_lpns (v_delivery_detail_id number) IS
2566: SELECT lpn_id
2567: FROM wsh_delivery_details
2568: WHERE delivery_detail_id = v_delivery_detail_id;
2569:
2570: CURSOR c_get_valid_lpns (v_delivery_detail_id NUMBER) IS
2571: select lpn_id, delivery_detail_id FROM

Line 3137: v_first_code wsh_delivery_details.shipment_priority_code%TYPE;

3133:
3134: FUNCTION derive_shipment_priority(p_delivery_id IN NUMBER)
3135: RETURN VARCHAR2 IS
3136:
3137: v_first_code wsh_delivery_details.shipment_priority_code%TYPE;
3138: v_ship_code wsh_delivery_details.shipment_priority_code%TYPE;
3139:
3140: CURSOR get_ship_codes IS
3141: SELECT wdd.shipment_priority_code ship_priority_code

Line 3138: v_ship_code wsh_delivery_details.shipment_priority_code%TYPE;

3134: FUNCTION derive_shipment_priority(p_delivery_id IN NUMBER)
3135: RETURN VARCHAR2 IS
3136:
3137: v_first_code wsh_delivery_details.shipment_priority_code%TYPE;
3138: v_ship_code wsh_delivery_details.shipment_priority_code%TYPE;
3139:
3140: CURSOR get_ship_codes IS
3141: SELECT wdd.shipment_priority_code ship_priority_code
3142: FROM wsh_delivery_details wdd,

Line 3142: FROM wsh_delivery_details wdd,

3138: v_ship_code wsh_delivery_details.shipment_priority_code%TYPE;
3139:
3140: CURSOR get_ship_codes IS
3141: SELECT wdd.shipment_priority_code ship_priority_code
3142: FROM wsh_delivery_details wdd,
3143: wsh_delivery_assignments_v wda
3144: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
3145: AND nvl(wdd.LINE_DIRECTION , 'O') IN ('O', 'IO') -- J Inbound Logistics jckwok
3146: AND wda.delivery_id = p_delivery_id

Line 3153: FROM wsh_delivery_details wdd,

3149: AND rownum = 1;
3150:
3151: CURSOR get_ship_codes1(p_ship_code IN VARCHAR2) IS
3152: SELECT wdd.shipment_priority_code ship_priority_code
3153: FROM wsh_delivery_details wdd,
3154: wsh_delivery_assignments_v wda
3155: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
3156: AND nvl(wdd.LINE_DIRECTION , 'O') IN ('O', 'IO') -- J Inbound Logistics jckwok
3157: AND wda.delivery_id = p_delivery_id

Line 3166: FROM wsh_delivery_details wdd,

3162: AND rownum = 1;
3163:
3164: CURSOR get_ship_codes2 IS
3165: SELECT wdd.shipment_priority_code ship_priority_code
3166: FROM wsh_delivery_details wdd,
3167: wsh_delivery_assignments_v wda
3168: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
3169: AND nvl(wdd.LINE_DIRECTION , 'O') IN ('O', 'IO') -- J Inbound Logistics jckwok
3170: AND wda.delivery_id = p_delivery_id

Line 4009: wsh_delivery_details wdd

4005: 'get_operatingUnit_id';
4006: CURSOR c_orgs (v_delivery_id NUMBER) IS
4007: SELECT wdd.org_id org_id , count(*) cnt
4008: FROM wsh_delivery_assignments_v wda,
4009: wsh_delivery_details wdd
4010: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
4011: AND wda.delivery_id = v_delivery_id
4012: AND wdd.container_flag = 'N'
4013: GROUP BY org_id

Line 7689: wsh_delivery_details wdd

7685: cursor c_get_lpn_delivery_status( c_lpn_id NUMBER) is
7686: select distinct wnd.delivery_id, wnd.status_code
7687: from wsh_new_deliveries wnd,
7688: wsh_delivery_assignments_v wda,
7689: wsh_delivery_details wdd
7690: where wnd.delivery_id (+) = wda.delivery_id
7691: and wda.delivery_detail_id = wdd.delivery_detail_id
7692: --LPN Reuse project
7693: and wdd.released_status = 'X'