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 1365: wsh_delivery_assignments wda

1361: -- MDC
1362: l_wda_type,
1363: l_line_direction
1364: FROM wsh_delivery_details wdd,
1365: wsh_delivery_assignments wda
1366: WHERE wdd.delivery_detail_id = p_entity_id
1367: AND wdd.delivery_detail_id = wda.delivery_detail_id
1368: AND NVL(wda.type, 'S') in ('S', 'C')
1369: FOR UPDATE NOWAIT;

Line 1665: FROM wsh_delivery_assignments wda,

1661: --lpn conv
1662: wdd.line_direction,
1663: -- MDC
1664: NVL(wda.type, 'S')
1665: FROM wsh_delivery_assignments wda,
1666: wsh_delivery_details wdd
1667: WHERE wdd.delivery_detail_id = p_delivery_detail_id
1668: AND NVL(wda.type, 'S') in ('S', 'C')
1669: AND wdd.delivery_detail_id = wda.delivery_detail_id;

Line 1673: FROM wsh_delivery_assignments_v wda

1669: AND wdd.delivery_detail_id = wda.delivery_detail_id;
1670:
1671: CURSOR C2(c_container_id IN NUMBER) IS
1672: SELECT wda.delivery_detail_id
1673: FROM wsh_delivery_assignments_v wda
1674: WHERE wda.parent_delivery_detail_id = c_container_id
1675: AND wda.delivery_detail_id <> p_delivery_detail_id;
1676:
1677: CURSOR C3(c_delivery_id IN NUMBER) IS

Line 1679: FROM wsh_delivery_assignments_v wda

1675: AND wda.delivery_detail_id <> p_delivery_detail_id;
1676:
1677: CURSOR C3(c_delivery_id IN NUMBER) IS
1678: SELECT wda.delivery_detail_id
1679: FROM wsh_delivery_assignments_v wda
1680: WHERE wda.delivery_id = c_delivery_id
1681: AND wda.delivery_detail_id <> p_delivery_detail_id;
1682:
1683: CURSOR C4(c_container_id IN NUMBER) IS

Line 2989: FROM wsh_delivery_assignments wda

2985: )
2986: IS
2987: SELECT delivery_detail_id,
2988: LEVEL
2989: FROM wsh_delivery_assignments wda
2990: WHERE LEVEL <= 2
2991: AND NVL(wda.type, 'S') in ('S', 'C')
2992: START WITH wda.delivery_detail_id = p_containerInstanceId
2993: AND NVL(wda.type, 'S') in ('S', 'C')

Line 3897: FROM WSH_DELIVERY_ASSIGNMENTS wda,

3893:
3894: -- OTM R12 : packing ECO
3895: CURSOR c_get_delivery_info(p_detail_id IN NUMBER) IS
3896: SELECT wda.delivery_id
3897: FROM WSH_DELIVERY_ASSIGNMENTS wda,
3898: WSH_NEW_DELIVERIES wnd
3899: WHERE wda.delivery_detail_id = p_detail_id
3900: AND wda.delivery_id = wnd.delivery_id
3901: AND wnd.tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,

Line 4136: FROM wsh_delivery_assignments_v wda,

4132: SELECT wda.delivery_detail_id,container_flag,
4133: inventory_item_id,
4134: NVL(received_quantity, -- J-IB-NPARIKH
4135: nvl(shipped_quantity, NVL(picked_quantity, requested_quantity))) pack_qty
4136: FROM wsh_delivery_assignments_v wda,
4137: wsh_delivery_details wdd
4138: WHERE wda.parent_delivery_detail_id = v_cont_instance_id AND
4139: wdd.delivery_detail_id = wda.delivery_detail_id;
4140:

Line 4968: wsh_delivery_assignments_v wda

4964: wdd.inventory_item_id,
4965: wdd.weight_uom_code wt_uom,
4966: wdd.volume_uom_code vol_uom
4967: FROM wsh_delivery_details wdd,
4968: wsh_delivery_assignments_v wda
4969: WHERE wdd.delivery_detail_id = wda.delivery_detail_id AND
4970: wda.delivery_id = p_delivery_id AND
4971: wda.delivery_id IS NOT NULL AND
4972: wdd.container_flag = 'N' AND

Line 4983: FROM wsh_delivery_assignments_v da,

4979: dd.volume vol,
4980: dd.inventory_item_id inventory_item_id,
4981: dd.weight_uom_code wt_uom,
4982: dd.volume_uom_code vol_uom
4983: FROM wsh_delivery_assignments_v da,
4984: wsh_delivery_details dd
4985: WHERE da.delivery_id = p_delivery_id AND
4986: da.delivery_id IS NOT NULL AND
4987: da.delivery_detail_id = dd.delivery_detail_id AND

Line 5027: from wsh_delivery_details dd, wsh_delivery_assignments da

5023: dd.volume vol,
5024: dd.inventory_item_id inventory_item_id,
5025: dd.weight_uom_code wt_uom,
5026: dd.volume_uom_code vol_uom
5027: from wsh_delivery_details dd, wsh_delivery_assignments da
5028: where dd.delivery_detail_id = da.delivery_detail_id
5029: and dd.container_flag = 'C'
5030: and NVL(da.type, 'S') = 'S'
5031: and da.delivery_id = p_delivery_id

Line 5046: FROM wsh_delivery_assignments da,

5042: dd.volume vol,
5043: dd.inventory_item_id inventory_item_id,
5044: dd.weight_uom_code wt_uom,
5045: dd.volume_uom_code vol_uom
5046: FROM wsh_delivery_assignments da,
5047: wsh_delivery_details dd
5048: WHERE da.parent_delivery_detail_id = p_consol_lpn AND
5049: da.delivery_detail_id = dd.delivery_detail_id AND
5050: da.type = 'C';

Line 6241: FROM WSH_DELIVERY_ASSIGNMENTS wda,

6237:
6238: CURSOR c_get_delivery_info_cont(p_detail_id IN NUMBER) IS
6239: SELECT wda.delivery_id,
6240: wnd.weight_uom_code
6241: FROM WSH_DELIVERY_ASSIGNMENTS wda,
6242: WSH_NEW_DELIVERIES wnd
6243: WHERE wda.delivery_detail_id = p_detail_id
6244: AND wda.delivery_id = wnd.delivery_id
6245: AND wda.delivery_id IS NOT NULL

Line 6476: FROM wsh_delivery_assignments_v wda,

6472: wdd.inventory_item_id,
6473: wdd.container_flag,
6474: nvl(wdd.line_direction, 'O') line_direction, -- LPN CONV. rv
6475: wdd.organization_id organization_id -- LPN CONV. rv
6476: FROM wsh_delivery_assignments_v wda,
6477: wsh_delivery_details wdd
6478: WHERE wda.delivery_id = p_delivery_id
6479: AND wda.parent_delivery_detail_id IS NULL
6480: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 6497: FROM wsh_delivery_assignments_v wda,

6493: wdd.inventory_item_id,
6494: wdd.container_flag,
6495: nvl(wdd.line_direction, 'O') line_direction, -- LPN CONV. rv
6496: wdd.organization_id organization_id -- LPN CONV. rv
6497: FROM wsh_delivery_assignments_v wda,
6498: wsh_delivery_details wdd
6499: WHERE wda.parent_delivery_detail_id IS NOT NULL
6500: AND wda.parent_delivery_detail_id = p_container_id
6501: AND wda.delivery_detail_id = wdd.delivery_detail_id