APPS.WMS_TASK_DISPATCH_LOV dependencies on WMS_DISPATCHED_TASKS

Line 72: wms_dispatched_tasks wdt,

68: WHERE wlpn1.license_plate_number LIKE p_concat_segments
69: START WITH
70: wlpn1.lpn_id IN (SELECT DISTINCT wlpn2.outermost_lpn_id
71: FROM mtl_material_transactions_temp mmtt,
72: wms_dispatched_tasks wdt,
73: wms_license_plate_numbers wlpn2
74: WHERE l_wms_po_j_or_higher = 1
75: AND mmtt.organization_id = p_organization_id
76: AND mmtt.transaction_temp_id = wdt.transaction_temp_id

Line 138: FROM wms_dispatched_tasks w

134: , NULL, 'FALSE'
135: , 'TRUE'
136: ) is_bulk_pick
137: , 2 dummy_sort
138: FROM wms_dispatched_tasks w
139: , mtl_material_transactions_temp m
140: , mtl_system_items_kfv i
141: , wms_license_plate_numbers l
142: , mtl_txn_request_lines mtrl

Line 185: FROM wms_dispatched_tasks w

181: , m.transaction_temp_id taskid
182: , l.lpn_context
183: , 'FALSE' is_bulk_pick
184: , 3 dummy_sort
185: FROM wms_dispatched_tasks w
186: , mtl_material_transactions_temp m
187: , mtl_system_items_kfv i
188: , wms_license_plate_numbers l
189: WHERE w.person_id = p_user_id

Line 260: FROM wms_dispatched_tasks w

256: , NULL, 'FALSE'
257: , 'TRUE'
258: ) is_bulk_pick
259: , 2 dummy_sort
260: FROM wms_dispatched_tasks w
261: , mtl_material_transactions_temp m
262: , mtl_system_items_kfv i
263: , wms_license_plate_numbers l
264: , mtl_txn_request_lines mtrl

Line 305: wms_dispatched_tasks wdt,

301: WHERE wlpn1.license_plate_number LIKE p_concat_segments
302: START WITH
303: wlpn1.lpn_id IN (SELECT DISTINCT wlpn2.outermost_lpn_id
304: FROM mtl_material_transactions_temp mmtt,
305: wms_dispatched_tasks wdt,
306: wms_license_plate_numbers wlpn2
307: WHERE l_wms_po_j_or_higher = 1
308: AND (p_page_type IS NULL OR p_page_type <> 'MANUAL_UNLOAD')
309: AND mmtt.organization_id = p_organization_id

Line 366: FROM wms_dispatched_tasks w

362: , m.transaction_temp_id taskid
363: , l.lpn_context
364: , 'FALSE' is_bulk_pick
365: , 1 dummy_sort
366: FROM wms_dispatched_tasks w
367: , mtl_material_transactions_temp m
368: , mtl_system_items_kfv i
369: , wms_license_plate_numbers l
370: , mtl_txn_request_lines mtrl

Line 438: FROM wms_dispatched_tasks w

434: , NULL, 'FALSE'
435: , 'TRUE'
436: ) is_bulk_pick
437: , 2 dummy_sort
438: FROM wms_dispatched_tasks w
439: , mtl_material_transactions_temp m
440: , mtl_system_items_kfv i
441: , wms_license_plate_numbers l
442: , mtl_txn_request_lines mtrl

Line 534: FROM wms_dispatched_tasks w

530: , NULL, 'FALSE'
531: , 'TRUE'
532: ) is_bulk_pick
533: , 3 dummy_sort
534: FROM wms_dispatched_tasks w
535: , mtl_material_transactions_temp m
536: , mtl_system_items_kfv i
537: , wms_license_plate_numbers l
538: , mtl_txn_request_lines mtrl

Line 615: FROM wms_dispatched_tasks w

611: , NULL, 'FALSE'
612: , 'TRUE'
613: ) is_bulk_pick
614: , 4 dummy_sort
615: FROM wms_dispatched_tasks w
616: , mtl_material_transactions_temp m
617: , mtl_system_items_kfv i
618: , wms_license_plate_numbers l
619: , mtl_txn_request_lines mtrl

Line 712: FROM wms_dispatched_tasks w

708: , NULL, 'FALSE'
709: , 'TRUE'
710: ) is_bulk_pick
711: , 5 dummy_sort
712: FROM wms_dispatched_tasks w
713: , mtl_material_transactions_temp m
714: , mtl_system_items_kfv i
715: , wms_license_plate_numbers l
716: , mtl_txn_request_lines mtrl

Line 829: FROM wms_dispatched_tasks w

825: , NULL, 'FALSE'
826: , 'TRUE'
827: ) is_bulk_pick
828: , 2 dummy_sort
829: FROM wms_dispatched_tasks w
830: , mtl_material_transactions_temp m
831: , mtl_system_items_kfv i
832: , wms_license_plate_numbers l
833: , mtl_txn_request_lines mtrl

Line 874: FROM wms_dispatched_tasks w

870: , m.transaction_temp_id taskid
871: , l.lpn_context
872: , 'FALSE' is_bulk_pick
873: , 6 dummy_sort
874: FROM wms_dispatched_tasks w
875: , mtl_material_transactions_temp m
876: , mtl_system_items_kfv i
877: , wms_license_plate_numbers l
878: WHERE w.person_id = p_user_id