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 147: , mtl_system_items_kfv i

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

Line 194: , mtl_system_items_kfv i

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

Line 270: , mtl_system_items_kfv i

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
273: , wms_license_plate_numbers wlpn2
274: WHERE w.person_id = p_user_id

Line 382: , mtl_system_items_kfv i

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

Line 455: , mtl_system_items_kfv i

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

Line 552: , mtl_system_items_kfv i

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

Line 634: , mtl_system_items_kfv i

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

Line 732: , mtl_system_items_kfv i

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

Line 851: , mtl_system_items_kfv i

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
854: , wms_license_plate_numbers wlpn2
855: WHERE w.person_id = p_user_id

Line 900: , mtl_system_items_kfv i

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