APPS.GME_CLOSE_BATCH_PVT dependencies on MTL_TXN_REQUEST_HEADERS

Line 230: FROM mtl_txn_request_headers mtrh

226: AND txn_source_id = x_batch_header_rec.batch_id
227: AND txn_source_line_id = l_material_details_tab(i).material_detail_id
228: AND line_status = 7
229: AND NOT EXISTS (SELECT 1
230: FROM mtl_txn_request_headers mtrh
231: WHERE mtrh.header_id = l.header_id)
232: AND NOT EXISTS (SELECT 1
233: FROM mtl_material_transactions_temp mmtt
234: where l.line_id = mmtt.move_order_line_id);

Line 266: FROM MTL_TXN_REQUEST_Lines mtrl, mtl_txn_request_headers mtrh

262: UPDATE MTL_TXN_REQUEST_Lines
263: SET line_status = 5
264: WHERE line_id in
265: (SELECT mtrl.line_id
266: FROM MTL_TXN_REQUEST_Lines mtrl, mtl_txn_request_headers mtrh
267: WHERE mtrl.TRANSACTION_SOURCE_TYPE_ID = 5
268: AND mtrl.LINE_STATUS = 7
269: AND mtrl.LPN_ID IS NOT NULL
270: AND mtrh.header_id = mtrl.header_id