APPS.GME_CANCEL_BATCH_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 199: DELETE FROM mtl_txn_request_lines l

195: END IF;
196: END IF;
197:
198: -- Bug 10100973 - Let's remove Open orphan Move order line records if they exist.
199: DELETE FROM mtl_txn_request_lines l
200: WHERE organization_id = x_batch_header_rec.organization_id
201: AND transaction_source_type_id = gme_common_pvt.g_txn_source_type
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

Line 237: UPDATE MTL_TXN_REQUEST_Lines

233: END IF;
234: END IF;
235:
236: -- BUG 11067065 - Let's close any remaining open putaway MO line.
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

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