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_WV_UTILS dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 1352: wsh_delivery_assignments wda

1348: -- MDC
1349: l_wda_type,
1350: l_line_direction
1351: FROM wsh_delivery_details wdd,
1352: wsh_delivery_assignments wda
1353: WHERE wdd.delivery_detail_id = p_entity_id
1354: AND wdd.delivery_detail_id = wda.delivery_detail_id
1355: AND NVL(wda.type, 'S') in ('S', 'C')
1356: FOR UPDATE NOWAIT;

Line 1652: FROM wsh_delivery_assignments wda,

1648: --lpn conv
1649: wdd.line_direction,
1650: -- MDC
1651: NVL(wda.type, 'S')
1652: FROM wsh_delivery_assignments wda,
1653: wsh_delivery_details wdd
1654: WHERE wdd.delivery_detail_id = p_delivery_detail_id
1655: AND NVL(wda.type, 'S') in ('S', 'C')
1656: AND wdd.delivery_detail_id = wda.delivery_detail_id;

Line 1660: FROM wsh_delivery_assignments_v wda

1656: AND wdd.delivery_detail_id = wda.delivery_detail_id;
1657:
1658: CURSOR C2(c_container_id IN NUMBER) IS
1659: SELECT wda.delivery_detail_id
1660: FROM wsh_delivery_assignments_v wda
1661: WHERE wda.parent_delivery_detail_id = c_container_id
1662: AND wda.delivery_detail_id <> p_delivery_detail_id;
1663:
1664: CURSOR C3(c_delivery_id IN NUMBER) IS

Line 1666: FROM wsh_delivery_assignments_v wda

1662: AND wda.delivery_detail_id <> p_delivery_detail_id;
1663:
1664: CURSOR C3(c_delivery_id IN NUMBER) IS
1665: SELECT wda.delivery_detail_id
1666: FROM wsh_delivery_assignments_v wda
1667: WHERE wda.delivery_id = c_delivery_id
1668: AND wda.delivery_detail_id <> p_delivery_detail_id;
1669:
1670: CURSOR C4(c_container_id IN NUMBER) IS

Line 2976: FROM wsh_delivery_assignments wda

2972: )
2973: IS
2974: SELECT delivery_detail_id,
2975: LEVEL
2976: FROM wsh_delivery_assignments wda
2977: WHERE LEVEL <= 2
2978: AND NVL(wda.type, 'S') in ('S', 'C')
2979: START WITH wda.delivery_detail_id = p_containerInstanceId
2980: AND NVL(wda.type, 'S') in ('S', 'C')

Line 3884: FROM WSH_DELIVERY_ASSIGNMENTS wda,

3880:
3881: -- OTM R12 : packing ECO
3882: CURSOR c_get_delivery_info(p_detail_id IN NUMBER) IS
3883: SELECT wda.delivery_id
3884: FROM WSH_DELIVERY_ASSIGNMENTS wda,
3885: WSH_NEW_DELIVERIES wnd
3886: WHERE wda.delivery_detail_id = p_detail_id
3887: AND wda.delivery_id = wnd.delivery_id
3888: AND wnd.tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,

Line 4123: FROM wsh_delivery_assignments_v wda,

4119: SELECT wda.delivery_detail_id,container_flag,
4120: inventory_item_id,
4121: NVL(received_quantity, -- J-IB-NPARIKH
4122: nvl(shipped_quantity, NVL(picked_quantity, requested_quantity))) pack_qty
4123: FROM wsh_delivery_assignments_v wda,
4124: wsh_delivery_details wdd
4125: WHERE wda.parent_delivery_detail_id = v_cont_instance_id AND
4126: wdd.delivery_detail_id = wda.delivery_detail_id;
4127:

Line 4955: wsh_delivery_assignments_v wda

4951: wdd.inventory_item_id,
4952: wdd.weight_uom_code wt_uom,
4953: wdd.volume_uom_code vol_uom
4954: FROM wsh_delivery_details wdd,
4955: wsh_delivery_assignments_v wda
4956: WHERE wdd.delivery_detail_id = wda.delivery_detail_id AND
4957: wda.delivery_id = p_delivery_id AND
4958: wda.delivery_id IS NOT NULL AND
4959: wdd.container_flag = 'N' AND

Line 4970: FROM wsh_delivery_assignments_v da,

4966: dd.volume vol,
4967: dd.inventory_item_id inventory_item_id,
4968: dd.weight_uom_code wt_uom,
4969: dd.volume_uom_code vol_uom
4970: FROM wsh_delivery_assignments_v da,
4971: wsh_delivery_details dd
4972: WHERE da.delivery_id = p_delivery_id AND
4973: da.delivery_id IS NOT NULL AND
4974: da.delivery_detail_id = dd.delivery_detail_id AND

Line 5014: from wsh_delivery_details dd, wsh_delivery_assignments da

5010: dd.volume vol,
5011: dd.inventory_item_id inventory_item_id,
5012: dd.weight_uom_code wt_uom,
5013: dd.volume_uom_code vol_uom
5014: from wsh_delivery_details dd, wsh_delivery_assignments da
5015: where dd.delivery_detail_id = da.delivery_detail_id
5016: and dd.container_flag = 'C'
5017: and NVL(da.type, 'S') = 'S'
5018: and da.delivery_id = p_delivery_id

Line 5033: FROM wsh_delivery_assignments da,

5029: dd.volume vol,
5030: dd.inventory_item_id inventory_item_id,
5031: dd.weight_uom_code wt_uom,
5032: dd.volume_uom_code vol_uom
5033: FROM wsh_delivery_assignments da,
5034: wsh_delivery_details dd
5035: WHERE da.parent_delivery_detail_id = p_consol_lpn AND
5036: da.delivery_detail_id = dd.delivery_detail_id AND
5037: da.type = 'C';

Line 6209: FROM WSH_DELIVERY_ASSIGNMENTS wda,

6205:
6206: CURSOR c_get_delivery_info_cont(p_detail_id IN NUMBER) IS
6207: SELECT wda.delivery_id,
6208: wnd.weight_uom_code
6209: FROM WSH_DELIVERY_ASSIGNMENTS wda,
6210: WSH_NEW_DELIVERIES wnd
6211: WHERE wda.delivery_detail_id = p_detail_id
6212: AND wda.delivery_id = wnd.delivery_id
6213: AND wda.delivery_id IS NOT NULL

Line 6444: FROM wsh_delivery_assignments_v wda,

6440: wdd.inventory_item_id,
6441: wdd.container_flag,
6442: nvl(wdd.line_direction, 'O') line_direction, -- LPN CONV. rv
6443: wdd.organization_id organization_id -- LPN CONV. rv
6444: FROM wsh_delivery_assignments_v wda,
6445: wsh_delivery_details wdd
6446: WHERE wda.delivery_id = p_delivery_id
6447: AND wda.parent_delivery_detail_id IS NULL
6448: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 6465: FROM wsh_delivery_assignments_v wda,

6461: wdd.inventory_item_id,
6462: wdd.container_flag,
6463: nvl(wdd.line_direction, 'O') line_direction, -- LPN CONV. rv
6464: wdd.organization_id organization_id -- LPN CONV. rv
6465: FROM wsh_delivery_assignments_v wda,
6466: wsh_delivery_details wdd
6467: WHERE wda.parent_delivery_detail_id IS NOT NULL
6468: AND wda.parent_delivery_detail_id = p_container_id
6469: AND wda.delivery_detail_id = wdd.delivery_detail_id