APPS.WSH_WV_UTILS dependencies on WSH_DELIVERY_ASSIGNMENTS_V

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