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

Line 8161: FROM mtl_txn_request_headers mtrh

8157: , mmtt.wip_entity_type
8158: INTO l_mmtt_mo_type
8159: , l_mmtt_txn_type_id
8160: , l_mmtt_wip_entity_type
8161: FROM mtl_txn_request_headers mtrh
8162: , mtl_txn_request_lines mtrl
8163: , mtl_material_transactions_temp mmtt
8164: WHERE mtrh.header_id = mtrl.header_id
8165: AND mtrl.line_id = mmtt.move_order_line_id

Line 8175: FROM mtl_txn_request_headers mtrh

8171: SELECT mtrh.move_order_type
8172: , mmtt.wip_entity_type
8173: INTO l_mo_type_in_lpn
8174: , l_wip_entity_type_in_lpn
8175: FROM mtl_txn_request_headers mtrh
8176: , mtl_txn_request_lines mtrl
8177: , mtl_material_transactions_temp mmtt
8178: WHERE mtrh.header_id = mtrl.header_id
8179: AND mtrl.line_id = mmtt.move_order_line_id

Line 13825: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl

13821: , mtrl.quantity
13822: , mtrl.uom_code
13823: , nvl(mtrl.quantity_delivered,0)
13824: , mtrl.line_status --bug3139307
13825: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl
13826: WHERE mtrl.line_id = l_mo_line_id
13827: AND mtrh.header_id = mtrl.header_id;
13828:
13829: CURSOR c_get_other_mmtt IS

Line 14470: FROM mtl_txn_request_headers mtrh, -- mo header for the new task

14466: SELECT mtrh.move_order_type,
14467: mtrl.txn_source_id
14468: INTO l_mmtt_mo_type,
14469: l_txn_source_id --Bug#9659710
14470: FROM mtl_txn_request_headers mtrh, -- mo header for the new task
14471: mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt
14472: WHERE mtrh.header_id = mtrl.header_id
14473: AND mtrl.line_id = mmtt.move_order_line_id
14474: AND mmtt.transaction_temp_id = p_temp_id;

Line 14605: FROM mtl_txn_request_headers mtrh, -- mo header for the new task

14601:
14602:
14603: SELECT mtrh.move_order_type
14604: INTO l_mmtt_mo_type
14605: FROM mtl_txn_request_headers mtrh, -- mo header for the new task
14606: mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt
14607: WHERE mtrh.header_id = mtrl.header_id
14608: AND mtrl.line_id = mmtt.move_order_line_id
14609: AND mmtt.transaction_temp_id = p_temp_id;