APPS.WMS_MDC_PVT dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 22: FROM wsh_delivery_assignments wda,

18: END IF;
19:
20: SELECT wda.delivery_id
21: INTO l_delivery_id
22: FROM wsh_delivery_assignments wda,
23: wsh_delivery_details_ob_grp_v wdd,
24: wsh_new_deliveries_ob_grp_v wnd
25: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
26: AND wnd.delivery_id = wda.delivery_id

Line 102: wsh_delivery_assignments_v wda

98: SELECT wda.delivery_id
99: INTO l_delivery_id
100: FROM mtl_material_transactions_temp mmtt,
101: wsh_delivery_details_ob_grp_v wdd,
102: wsh_delivery_assignments_v wda
103: WHERE mmtt.transfer_lpn_id = p_lpn_id
104: AND mmtt.transaction_action_id = 28
105: AND mmtt.transaction_source_type_id IN (2, 8)
106: AND mmtt.move_order_line_id = wdd.move_order_line_id

Line 123: FROM wsh_delivery_assignments_v wda,

119: ELSIF l_lpn_context IN (12, 11) THEN -- LPN1 has been staged
120: -- 12:Loaded to stage move Context
121: SELECT wda.delivery_id
122: INTO l_delivery_id
123: FROM wsh_delivery_assignments_v wda,
124: wsh_delivery_details_ob_grp_v wdd
125: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
126: AND wdd.lpn_id = p_lpn_id
127: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650

Line 137: wsh_delivery_assignments_v wda

133: BEGIN
134: SELECT wda.delivery_id
135: INTO l_delivery_id
136: FROM mtl_txn_request_lines mtrl,
137: wsh_delivery_assignments_v wda
138: WHERE mtrl.lpn_id IN (SELECT wlpn.lpn_id
139: FROM wms_license_plate_numbers wlpn
140: START WITH wlpn.lpn_id = p_lpn_id
141: CONNECT BY PRIOR wlpn.lpn_id = wlpn.parent_lpn_id)

Line 846: FROM wsh_delivery_assignments wda

842: SELECT outermost_lpn_id, subinventory_code, locator_id
843: INTO x_to_lpn_id, x_to_subinventory_code, x_to_locator_id
844: FROM
845: (SELECT wlpn.outermost_lpn_id, wlpn.subinventory_code, wlpn.locator_id
846: FROM wsh_delivery_assignments wda
847: , wsh_delivery_details_ob_grp_v wdd
848: , mtl_item_locations mil
849: , wms_license_plate_numbers wlpn
850: , wms_dispatched_tasks_history wdth

Line 888: FROM wsh_delivery_assignments wda

884: SELECT outermost_lpn_id, subinventory_code, locator_id
885: INTO x_to_lpn_id, x_to_subinventory_code, x_to_locator_id
886: FROM
887: (SELECT wlpn.outermost_lpn_id, wlpn.subinventory_code, wlpn.locator_id
888: FROM wsh_delivery_assignments wda
889: , wsh_delivery_details_ob_grp_v wdd
890: , mtl_item_locations mil
891: , wms_license_plate_numbers wlpn
892: , wms_dispatched_tasks_history wdth

Line 935: FROM wsh_delivery_assignments wda

931: SELECT outermost_lpn_id, subinventory_code, locator_id
932: INTO x_to_lpn_id, x_to_subinventory_code, x_to_locator_id
933: FROM
934: (SELECT wlpn.outermost_lpn_id, wlpn.subinventory_code, wlpn.locator_id
935: FROM wsh_delivery_assignments wda
936: , wsh_delivery_details_ob_grp_v wdd
937: , mtl_item_locations mil
938: , wms_license_plate_numbers wlpn
939: , wms_dispatched_tasks_history wdth