APPS.INV_MO_BACKORDER_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 176: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl

172: AND wdt.status IN (4,9));
173:
174: CURSOR c_mo_type IS
175: SELECT mtrh.move_order_type
176: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl
177: WHERE mtrl.line_id = l_mo_line_rec.line_id
178: AND mtrh.header_id = mtrl.header_id;
179:
180: -- INVCONV - Incorporate secondary transaction quantity below

Line 279: UPDATE mtl_txn_request_lines

275: -- INVCONV BEGIN
276: -- Fork the update statement below according to whether item tracks dual qty or not
277: IF l_mo_line_rec.secondary_uom IS NULL THEN
278: -- INVCONV Tracking in primary only
279: UPDATE mtl_txn_request_lines
280: SET line_status = 5
281: , quantity_detailed = NVL(quantity_delivered,0)
282: , quantity = NVL(quantity_delivered,0)
283: WHERE line_id = p_line_id;

Line 286: UPDATE mtl_txn_request_lines

282: , quantity = NVL(quantity_delivered,0)
283: WHERE line_id = p_line_id;
284: ELSE
285: -- INVCONV Tracking in primary and secondary
286: UPDATE mtl_txn_request_lines
287: SET line_status = 5
288: , quantity_detailed = NVL(quantity_delivered,0)
289: , secondary_quantity_detailed = NVL(secondary_quantity_delivered,0)
290: , quantity = NVL(quantity_delivered,0)