APPS.WMS_MDC_PVT dependencies on WSH_DELIVERY_DETAILS_OB_GRP_V

Line 23: wsh_delivery_details_ob_grp_v wdd,

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
27: AND wnd.delivery_type = 'CONSOLIDATION'

Line 101: wsh_delivery_details_ob_grp_v wdd,

97: IF l_lpn_context = 8 THEN -- Packing Context: LPN1 has been loaded
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)

Line 124: wsh_delivery_details_ob_grp_v wdd

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
128: AND ROWNUM =1;

Line 847: , wsh_delivery_details_ob_grp_v wdd

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
851: WHERE wdd.delivery_detail_id = wda.delivery_detail_id

Line 889: , wsh_delivery_details_ob_grp_v wdd

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
893: WHERE wdd.delivery_detail_id = wda.delivery_detail_id

Line 936: , wsh_delivery_details_ob_grp_v wdd

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
940: WHERE wdd.delivery_detail_id = wda.delivery_detail_id