eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_TASK_DISPATCH_LOV dependencies on MTL_SYSTEM_ITEMS_KFV

Line 140: , mtl_system_items_kfv i

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
143: WHERE w.person_id = p_user_id
144: AND w.organization_id = p_organization_id

Line 187: , mtl_system_items_kfv i

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
190: AND w.organization_id = p_organization_id
191: AND w.status = 4

Line 262: , mtl_system_items_kfv i

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
265: WHERE w.person_id = p_user_id
266: AND w.organization_id = p_organization_id

Line 368: , mtl_system_items_kfv i

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
371: WHERE l_wms_po_j_or_higher <> 1
372: AND w.person_id = p_user_id

Line 440: , mtl_system_items_kfv i

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
443: WHERE w.person_id = p_user_id
444: AND w.organization_id = p_organization_id

Line 536: , mtl_system_items_kfv i

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
539: WHERE w.person_id = p_user_id
540: AND w.organization_id = p_organization_id

Line 617: , mtl_system_items_kfv i

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
620: WHERE w.person_id = p_user_id
621: AND w.organization_id = p_organization_id

Line 714: , mtl_system_items_kfv i

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
717: WHERE w.person_id = p_user_id
718: AND w.organization_id = p_organization_id

Line 831: , mtl_system_items_kfv i

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
834: WHERE w.person_id = p_user_id
835: AND w.organization_id = p_organization_id

Line 876: , mtl_system_items_kfv i

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
879: AND w.organization_id = p_organization_id
880: AND w.status = 4