[Home] [Help]
118: WSMT.transaction_date, WSMT.transaction_id,
119: decode(WSMT.transaction_type_id, WSMPCNST.BONUS, WSRJ.starting_operation_seq_num, WSSJ.operation_seq_num),
120: OAP.acct_period_id, 'N',
121: decode(l_wms_org, 'Y', l_def_cost_grp_id, NULL)
122: FROM wsm_sm_starting_jobs WSSJ,
123: wsm_split_merge_transactions WSMT,
124: wsm_sm_resulting_jobs WSRJ,
125: mtl_system_items MSI,
126: org_acct_periods OAP,
225: available_quantity
226: INTO l_rep_we_id,
227: l_op_seq_num,
228: l_avail_qty
229: FROM WSM_SM_STARTING_JOBS
230: WHERE transaction_id = p_txn_id
231: AND representative_flag = 'Y';
232:
233: IF p_txn_type IN (WSMPCNST.SPLIT, WSMPCNST.MERGE) THEN --This has been added to improve performance
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
242: and wip_entity_id <> l_rep_we_id)
243: AND nvl(wro.quantity_issued, 0) >= nvl(wro.quantity_relieved, 0)
244: -- If there is a PUSH comp and the whole qty is scrapped, qty_rel > qty_iss
283: INTO l_result_qty
284: FROM wsm_sm_resulting_jobs WSRJ
285: WHERE WSRJ.transaction_id = p_txn_id
286: AND WSRJ.wip_entity_id in (select wip_entity_id
287: from wsm_sm_starting_jobs
288: where transaction_id = p_txn_id
289: and wip_entity_id = l_rep_we_id);
290: EXCEPTION
291: WHEN NO_DATA_FOUND THEN
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)
300: WHERE wro.wip_entity_id in (select wip_entity_id
301: from wsm_sm_starting_jobs
302: where transaction_id = p_txn_id
303: and wip_entity_id = l_rep_we_id)
304: AND wro.quantity_issued > NVL(wro.quantity_relieved, 0) -- Added to fix bug #2797647
305: AND not exists (select 'obsolete operation'