APPS.GME_CLOSE_BATCH_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 223: DELETE FROM mtl_txn_request_lines l

219: RAISE material_details_fetch_err;
220: END IF;
221:
222: FOR i IN 1 .. l_material_details_tab.COUNT LOOP
223: DELETE FROM mtl_txn_request_lines l
224: WHERE organization_id = x_batch_header_rec.organization_id
225: AND transaction_source_type_id = gme_common_pvt.g_txn_source_type
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

Line 262: UPDATE MTL_TXN_REQUEST_Lines

258: END IF;
259: END IF;
260:
261: -- BUG 11067065 - Let's close any remaining open putaway MO line.
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

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