DBA Data[Home] [Help]

APPS.WMS_MDC_PVT dependencies on WMS_DISPATCHED_TASKS_HISTORY

Line 249: FROM wms_op_plan_details wopd, wms_dispatched_tasks_history wdth

245: -- 12:Loaded to stage move Context
246: BEGIN
247: SELECT 2 -- 1=AD, 2=WD
248: INTO l_consolidation_method_id -- 1=AD, 2=WD
249: FROM wms_op_plan_details wopd, wms_dispatched_tasks_history wdth
250: WHERE wdth.transfer_lpn_id = p_lpn_id
251: AND wdth.operation_plan_id = wopd.operation_plan_id
252: AND wopd.consolidation_method_id = 2 --WD
253: AND wopd.operation_type = 2 -- Drop

Line 887: , wms_dispatched_tasks_history wdth

883: FROM wsh_delivery_assignments wda
884: , wsh_delivery_details_ob_grp_v wdd
885: , mtl_item_locations mil
886: , wms_license_plate_numbers wlpn
887: , wms_dispatched_tasks_history wdth
888: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
889: AND wdd.lpn_id = wlpn.lpn_id
890: AND wlpn.lpn_id <> p_lpn_id
891: AND wlpn.outermost_lpn_id <> p_lpn_id

Line 929: , wms_dispatched_tasks_history wdth

925: FROM wsh_delivery_assignments wda
926: , wsh_delivery_details_ob_grp_v wdd
927: , mtl_item_locations mil
928: , wms_license_plate_numbers wlpn
929: , wms_dispatched_tasks_history wdth
930: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
931: AND wdd.lpn_id = wlpn.lpn_id
932: AND wlpn.lpn_id <> p_lpn_id
933: AND wlpn.outermost_lpn_id <> p_lpn_id

Line 976: , wms_dispatched_tasks_history wdth

972: FROM wsh_delivery_assignments wda
973: , wsh_delivery_details_ob_grp_v wdd
974: , mtl_item_locations mil
975: , wms_license_plate_numbers wlpn
976: , wms_dispatched_tasks_history wdth
977: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
978: AND wdd.lpn_id = wlpn.lpn_id
979: AND wlpn.lpn_id <> p_lpn_id
980: AND wlpn.outermost_lpn_id <> p_lpn_id