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_TXN_REQUEST_LINES

Line 142: , mtl_txn_request_lines mtrl

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
145: AND w.status = 4
146: AND w.transaction_temp_id = m.transaction_temp_id

Line 264: , mtl_txn_request_lines mtrl

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
267: AND w.status = 4
268: AND w.transaction_temp_id = m.transaction_temp_id

Line 370: , mtl_txn_request_lines mtrl

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

Line 442: , mtl_txn_request_lines mtrl

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
445: AND w.status = 4
446: AND w.transaction_temp_id = m.transaction_temp_id

Line 538: , mtl_txn_request_lines mtrl

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
541: AND w.status = 4
542: AND w.transaction_temp_id = m.transaction_temp_id

Line 619: , mtl_txn_request_lines mtrl

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
622: AND w.status = 4
623: AND w.transaction_temp_id = m.transaction_temp_id

Line 716: , mtl_txn_request_lines mtrl

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
719: AND w.status = 4
720: AND w.transaction_temp_id = m.transaction_temp_id

Line 833: , mtl_txn_request_lines mtrl

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
836: AND w.status = 4
837: AND w.transaction_temp_id = m.transaction_temp_id