APPS.WMS_MDC_PVT dependencies on WMS_DISPATCHED_TASKS_HISTORY

Line 212: FROM wms_op_plan_details wopd, wms_dispatched_tasks_history wdth

208: -- 12:Loaded to stage move Context
209: BEGIN
210: SELECT 2 -- 1=AD, 2=WD
211: INTO l_consolidation_method_id -- 1=AD, 2=WD
212: FROM wms_op_plan_details wopd, wms_dispatched_tasks_history wdth
213: WHERE wdth.transfer_lpn_id = p_lpn_id
214: AND wdth.operation_plan_id = wopd.operation_plan_id
215: AND wopd.consolidation_method_id = 2 --WD
216: AND wopd.operation_type = 2 -- Drop

Line 850: , wms_dispatched_tasks_history wdth

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
852: AND wdd.lpn_id = wlpn.lpn_id
853: AND wlpn.lpn_id <> p_lpn_id
854: AND wlpn.outermost_lpn_id <> p_lpn_id

Line 892: , wms_dispatched_tasks_history wdth

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
894: AND wdd.lpn_id = wlpn.lpn_id
895: AND wlpn.lpn_id <> p_lpn_id
896: AND wlpn.outermost_lpn_id <> p_lpn_id

Line 939: , wms_dispatched_tasks_history wdth

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
941: AND wdd.lpn_id = wlpn.lpn_id
942: AND wlpn.lpn_id <> p_lpn_id
943: AND wlpn.outermost_lpn_id <> p_lpn_id