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.GME_CANCEL_BATCH_PVT dependencies on MTL_TXN_REQUEST_HEADERS

Line 206: FROM mtl_txn_request_headers mtrh

202: AND txn_source_id = l_material_details_tab(i).batch_id
203: AND txn_source_line_id = l_material_details_tab(i).material_detail_id
204: AND line_status = 7
205: AND NOT EXISTS (SELECT 1
206: FROM mtl_txn_request_headers mtrh
207: WHERE mtrh.header_id = l.header_id)
208: AND NOT EXISTS (SELECT 1
209: FROM mtl_material_transactions_temp mmtt
210: where l.line_id = mmtt.move_order_line_id);

Line 241: FROM MTL_TXN_REQUEST_Lines mtrl, mtl_txn_request_headers mtrh

237: UPDATE MTL_TXN_REQUEST_Lines
238: SET line_status = 5
239: WHERE line_id in
240: (SELECT mtrl.line_id
241: FROM MTL_TXN_REQUEST_Lines mtrl, mtl_txn_request_headers mtrh
242: WHERE mtrl.TRANSACTION_SOURCE_TYPE_ID = 5
243: AND mtrl.LINE_STATUS = 7
244: AND mtrl.LPN_ID IS NOT NULL
245: AND mtrh.header_id = mtrl.header_id