APPS.WSH_WV_UTILS dependencies on WSH_DELIVERY_ASSIGNMENTS_V

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 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 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