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_PICK_DROP_PVT dependencies on MTL_TXN_REQUEST_HEADERS

Line 126: , mtl_txn_request_headers mtrh

122: ) IS
123: SELECT mtrh.move_order_type
124: , mtrl.line_status
125: FROM mtl_txn_request_lines mtrl
126: , mtl_txn_request_headers mtrh
127: WHERE mtrl.line_id = p_mo_line_id
128: AND mtrl.header_id = mtrh.header_id;
129:
130: l_mo_line_id NUMBER;

Line 887: , mtl_txn_request_headers mtrh

883: )
884: )
885: FROM mtl_material_transactions_temp mmtt
886: , mtl_txn_request_lines mtrl
887: , mtl_txn_request_headers mtrh
888: WHERE mmtt.organization_id = p_org_id
889: --Modified for Bug 6717052
890: AND (mmtt.transfer_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id IN (SELECT wlpn.lpn_id FROM wms_license_plate_numbers wlpn
891: WHERE wlpn.outermost_lpn_id = p_lpn_id))

Line 3597: , mtl_txn_request_headers mtrh

3593: FROM mtl_material_transactions_temp mmtt
3594: , mtl_secondary_inventories msi
3595: , mtl_item_locations mil
3596: , mtl_txn_request_lines mtrl
3597: , mtl_txn_request_headers mtrh
3598: , wms_dispatched_tasks wdt -- Added for bug 12853197
3599: WHERE mmtt.organization_id = p_org_id
3600: AND mmtt.transfer_lpn_id = p_lpn_id
3601: AND mmtt.transaction_action_id = 2

Line 3645: , mtl_txn_request_headers mtrh

3641: FROM mtl_material_transactions_temp mmtt
3642: , mtl_secondary_inventories msi
3643: , mtl_item_locations mil
3644: , mtl_txn_request_lines mtrl
3645: , mtl_txn_request_headers mtrh
3646: WHERE mmtt.organization_id = p_org_id
3647: AND mmtt.transfer_lpn_id = p_lpn_id
3648: AND mmtt.transaction_action_id = 2
3649: AND ( (mmtt.parent_line_id IS NOT NULL