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 149: , mtl_txn_request_lines mtrl

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

Line 272: , mtl_txn_request_lines mtrl

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

Line 384: , mtl_txn_request_lines mtrl

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

Line 457: , mtl_txn_request_lines mtrl

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

Line 554: , mtl_txn_request_lines mtrl

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

Line 636: , mtl_txn_request_lines mtrl

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

Line 734: , mtl_txn_request_lines mtrl

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

Line 853: , mtl_txn_request_lines mtrl

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