APPS.WSM_JOBCOSTING_GRP dependencies on WIP_REQUIREMENT_OPERATIONS

Line 215: UPDATE wip_requirement_operations

211:
212: l_stmt_num := 7;
213:
214: -- Update quantity_issued for all operations prior to starting_operation_seq_num
215: UPDATE wip_requirement_operations
216: SET quantity_issued = required_quantity
217: WHERE wip_entity_id = l_rep_we_id
218: AND operation_seq_num < l_op_seq_num
219: AND wip_supply_type not in (2, 4, 5, 6);

Line 237: UPDATE wip_requirement_operations wro

233: IF p_txn_type IN (WSMPCNST.SPLIT, WSMPCNST.MERGE) THEN --This has been added to improve performance
234: -- as such the following stmts wont update anything for Upd Qty
235: l_stmt_num := 20;
236: -- Update the non-representative starting jobs
237: UPDATE wip_requirement_operations wro
238: SET wro.quantity_issued = round(NVL(wro.quantity_relieved, 0), 6)
239: WHERE wro.wip_entity_id in (select wip_entity_id
240: from wsm_sm_starting_jobs
241: where transaction_id = p_txn_id

Line 254: UPDATE wip_requirement_operations wro

250: and wo.count_point_type = 3);
251:
252: l_stmt_num := 30;
253: -- Update the non-matching resulting jobs i.e. new jobs
254: UPDATE wip_requirement_operations wro
255: SET wro.quantity_issued =
256: (SELECT round(decode(sign(nvl(wro1.quantity_issued, 0) - nvl(wro1.quantity_relieved, 0)), 1, 1, 0)
257: *(nvl(wro1.quantity_issued,0) - nvl(wro1.quantity_relieved, 0))
258: * WSRJ.start_quantity/l_avail_qty, 6)

Line 259: FROM wip_requirement_operations wro1,

255: SET wro.quantity_issued =
256: (SELECT round(decode(sign(nvl(wro1.quantity_issued, 0) - nvl(wro1.quantity_relieved, 0)), 1, 1, 0)
257: *(nvl(wro1.quantity_issued,0) - nvl(wro1.quantity_relieved, 0))
258: * WSRJ.start_quantity/l_avail_qty, 6)
259: FROM wip_requirement_operations wro1,
260: wsm_sm_resulting_jobs WSRJ
261: WHERE wro1.wip_entity_id = l_rep_we_id
262: AND wro1.inventory_item_id = wro.inventory_item_id
263: AND wro1.organization_id = wro.organization_id

Line 295: UPDATE wip_requirement_operations wro

291: WHEN NO_DATA_FOUND THEN
292: l_result_qty := 0;
293: END;
294:
295: UPDATE wip_requirement_operations wro
296: SET wro.quantity_issued =
297: round((decode(sign(nvl(wro.quantity_issued, 0) - nvl(wro.quantity_relieved, 0)), 1, 1, 0)
298: *(nvl(wro.quantity_issued,0) - nvl(wro.quantity_relieved, 0)) * l_result_qty/l_avail_qty
299: + nvl(wro.quantity_relieved, 0)), 6)