APPS.WMS_TASK_DISPATCH_LOV dependencies on WMS_DISPATCHED_TASKS

Line 79: wms_dispatched_tasks wdt,

75: WHERE wlpn1.license_plate_number LIKE p_concat_segments
76: START WITH
77: wlpn1.lpn_id IN (SELECT DISTINCT wlpn2.outermost_lpn_id
78: FROM mtl_material_transactions_temp mmtt,
79: wms_dispatched_tasks wdt,
80: wms_license_plate_numbers wlpn2
81: WHERE l_wms_po_j_or_higher = 1
82: AND mmtt.organization_id = p_organization_id
83: AND mmtt.transaction_temp_id = wdt.transaction_temp_id

Line 145: FROM wms_dispatched_tasks w

141: , NULL, 'FALSE'
142: , 'TRUE'
143: ) is_bulk_pick
144: , 2 dummy_sort
145: FROM wms_dispatched_tasks w
146: , mtl_material_transactions_temp m
147: , mtl_system_items_kfv i
148: , wms_license_plate_numbers l
149: , mtl_txn_request_lines mtrl

Line 192: FROM wms_dispatched_tasks w

188: , m.transaction_temp_id taskid
189: , l.lpn_context
190: , 'FALSE' is_bulk_pick
191: , 3 dummy_sort
192: FROM wms_dispatched_tasks w
193: , mtl_material_transactions_temp m
194: , mtl_system_items_kfv i
195: , wms_license_plate_numbers l
196: WHERE w.person_id = p_user_id

Line 268: FROM wms_dispatched_tasks w

264: , NULL, 'FALSE'
265: , 'TRUE'
266: ) is_bulk_pick
267: , 2 dummy_sort
268: FROM wms_dispatched_tasks w
269: , mtl_material_transactions_temp m
270: , mtl_system_items_kfv i
271: , wms_license_plate_numbers l
272: , mtl_txn_request_lines mtrl

Line 319: wms_dispatched_tasks wdt,

315: WHERE wlpn1.license_plate_number LIKE p_concat_segments
316: START WITH
317: wlpn1.lpn_id IN (SELECT DISTINCT wlpn2.outermost_lpn_id
318: FROM mtl_material_transactions_temp mmtt,
319: wms_dispatched_tasks wdt,
320: wms_license_plate_numbers wlpn2
321: WHERE l_wms_po_j_or_higher = 1
322: AND (p_page_type IS NULL OR p_page_type <> 'MANUAL_UNLOAD')
323: AND mmtt.organization_id = p_organization_id

Line 380: FROM wms_dispatched_tasks w

376: , m.transaction_temp_id taskid
377: , l.lpn_context
378: , 'FALSE' is_bulk_pick
379: , 1 dummy_sort
380: FROM wms_dispatched_tasks w
381: , mtl_material_transactions_temp m
382: , mtl_system_items_kfv i
383: , wms_license_plate_numbers l
384: , mtl_txn_request_lines mtrl

Line 453: FROM wms_dispatched_tasks w

449: , NULL, 'FALSE'
450: , 'TRUE'
451: ) is_bulk_pick
452: , 2 dummy_sort
453: FROM wms_dispatched_tasks w
454: , mtl_material_transactions_temp m
455: , mtl_system_items_kfv i
456: , wms_license_plate_numbers l
457: , mtl_txn_request_lines mtrl

Line 550: FROM wms_dispatched_tasks w

546: , NULL, 'FALSE'
547: , 'TRUE'
548: ) is_bulk_pick
549: , 3 dummy_sort
550: FROM wms_dispatched_tasks w
551: , mtl_material_transactions_temp m
552: , mtl_system_items_kfv i
553: , wms_license_plate_numbers l
554: , mtl_txn_request_lines mtrl

Line 632: FROM wms_dispatched_tasks w

628: , NULL, 'FALSE'
629: , 'TRUE'
630: ) is_bulk_pick
631: , 4 dummy_sort
632: FROM wms_dispatched_tasks w
633: , mtl_material_transactions_temp m
634: , mtl_system_items_kfv i
635: , wms_license_plate_numbers l
636: , mtl_txn_request_lines mtrl

Line 730: FROM wms_dispatched_tasks w

726: , NULL, 'FALSE'
727: , 'TRUE'
728: ) is_bulk_pick
729: , 5 dummy_sort
730: FROM wms_dispatched_tasks w
731: , mtl_material_transactions_temp m
732: , mtl_system_items_kfv i
733: , wms_license_plate_numbers l
734: , mtl_txn_request_lines mtrl

Line 849: FROM wms_dispatched_tasks w

845: , NULL, 'FALSE'
846: , 'TRUE'
847: ) is_bulk_pick
848: , 2 dummy_sort
849: FROM wms_dispatched_tasks w
850: , mtl_material_transactions_temp m
851: , mtl_system_items_kfv i
852: , wms_license_plate_numbers l
853: , mtl_txn_request_lines mtrl

Line 898: FROM wms_dispatched_tasks w

894: , m.transaction_temp_id taskid
895: , l.lpn_context
896: , 'FALSE' is_bulk_pick
897: , 6 dummy_sort
898: FROM wms_dispatched_tasks w
899: , mtl_material_transactions_temp m
900: , mtl_system_items_kfv i
901: , wms_license_plate_numbers l
902: WHERE w.person_id = p_user_id