APPS.INV_UTILITIES dependencies on MTL_TXN_REQUEST_LINES

Line 91: mtl_txn_request_lines instead of the View mtl_txn_request_lines_v*/

87: /* Restructured the Following Cursor SQL as part of
88: Performance Fix: 2853526.
89: Removed NVLs around from and to Subinventory Codes and
90: used base tables mtl_txn_request_headers and
91: mtl_txn_request_lines instead of the View mtl_txn_request_lines_v*/
92: /* FP-J PAR Replenishment Counts: Introduced 3 more columns to be fetched
93: viz., header_id, project_id and task_id. Also, the cursor is now ordered by
94: mtrl.header_id so that update of GROUPING_RULE_ID of mtrh (for header_id) is
95: done efficiently knowing the fact that the cursor may fetch multiple lines

Line 107: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh

103: , mtrl.to_account_id
104: , mtrl.header_id
105: , mtrl.project_id
106: , mtrl.task_id
107: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh
108: WHERE mtrl.line_status IN(3, 7)
109: AND mtrl.header_id = mtrh.header_id
110: AND mtrl.organization_id = p_org_id
111: AND(

Line 243: UPDATE mtl_txn_request_lines

239: , p_plan_tasks => p_plan_tasks
240: );
241:
242: --INVCONV Added secondary qty
243: UPDATE mtl_txn_request_lines
244: SET quantity_detailed = (nvl(quantity_delivered,0) + v_detailed_qty) -- against bug : 4155230
245: ,secondary_quantity_detailed = DECODE(v_secondary_detailed_qty,0,NULL,v_secondary_detailed_qty)
246: WHERE line_id = v_line_id
247: AND organization_id = p_org_id;

Line 284: -- from to_account_id of mtl_txn_request_lines_v

280: END IF;
281:
282: -- kkoothan Bug Fix:2352405
283: -- Update the distribution_account_id of MMTT
284: -- from to_account_id of mtl_txn_request_lines_v
285: -- since this was not done previously.After this fix,
286: -- MOs allocated using MO Pick Slip Report too,
287: -- along with manually allocated MO will populate
288: -- the distribution_account_id of MMTT.