[Home] [Help]
2002: -- Checkin 115.114 is original fix. In 115.115, added a check to make sure we don't do
2003: --- this for phantom component rows, i.e. where op_seq_num is less than zero.
2004:
2005: forall l_job_counter in indices of p_new_rj_we_id_tbl
2006: INSERT INTO WIP_REQUIREMENT_OPERATIONS
2007: ( inventory_item_id,
2008: organization_id,
2009: wip_entity_id,
2010: operation_seq_num,
2156: wro.segment19,
2157: wro.segment20,
2158: wro.department_id
2159:
2160: from wip_requirement_operations wro
2161: , wip_operations wo
2162: WHERE wro.wip_entity_id = p_rep_we_id
2163: AND wro.operation_seq_num <= p_curr_op_seq_num
2164: AND wro.operation_seq_num >= 0-p_curr_op_seq_num --To take care of phantoms bug #2681370
2388: for l_job_counter in p_wip_entity_id_tbl.first..p_wip_entity_id_tbl.last loop
2389: --LBM enh: Changed the expression for required quantity
2390: --Bug 5254440: Value passed for the parameter p_op_seq_num.
2391: for l_job_wo_rec in c_job_wo(p_wip_entity_id_tbl(l_job_counter),p_txn_job_op_seq_tbl(l_job_counter)) loop
2392: UPDATE wip_requirement_operations wro
2393: SET required_quantity = ROUND( (wro.quantity_per_assembly/nvl(wro.component_yield_factor,1)
2394: * decode(l_job_wo_rec.total_quantity
2395: , 0,0
2396: , decode(wro.basis_type,
2601:
2602: -- Added abs() on quantity_issued for bug 6053122(fp for 5843039)
2603:
2604:
2605: UPDATE wip_requirement_operations wro
2606: -- ST : Commenting out the below for bug fix : 4619823 --
2607: --SET wro.quantity_issued = decode(p_txn_job_intraop,1,round(NVL(wro.quantity_relieved, 0), 6)
2608: -- ,3,wro.quantity_issued
2609: -- )
2630: --Start deletions to fix bug #2901741--
2631: --Deleted the following, since this fix is incorrect--
2632: --Start adding condition to fix bug #2664909--
2633: -- AND wro.inventory_item_id IN (select inventory_item_id
2634: -- from wip_requirement_operations
2635: -- where wip_entity_id = l_rep_we_id
2636: -- and operation_seq_num = wro.operation_seq_num)
2637: --End adding condition to fix bug #2664909--
2638: --Deleted the following, since if A(ops 10,20) and B(ops 10,20,30,40) are merged into A,
2651: forall l_job_counter in indices of p_new_rj_we_id_tbl
2652:
2653: -- Added abs() on quantity_issued for bug 6053122(fp for 5843039)
2654:
2655: UPDATE wip_requirement_operations wro
2656: -- ST : Commenting for bug fix 4619823
2657: -- SET wro.quantity_issued = decode(p_txn_job_intraop,1,(SELECT round(decode(sign(nvl(wro1.quantity_issued, 0) - nvl(wro1.quantity_relieved, 0)), 1, 1, 0)
2658: -- *(nvl(wro1.quantity_issued,0) - nvl(wro1.quantity_relieved, 0))
2659: -- * p_new_rj_start_qty(l_job_counter)/p_rep_avail_qty, 6)
2656: -- ST : Commenting for bug fix 4619823
2657: -- SET wro.quantity_issued = decode(p_txn_job_intraop,1,(SELECT round(decode(sign(nvl(wro1.quantity_issued, 0) - nvl(wro1.quantity_relieved, 0)), 1, 1, 0)
2658: -- *(nvl(wro1.quantity_issued,0) - nvl(wro1.quantity_relieved, 0))
2659: -- * p_new_rj_start_qty(l_job_counter)/p_rep_avail_qty, 6)
2660: -- FROM wip_requirement_operations wro1
2661: -- WHERE wro1.wip_entity_id = p_rep_we_id
2662: -- AND wro1.inventory_item_id = wro.inventory_item_id
2663: -- AND wro1.organization_id = wro.organization_id
2664: -- AND wro1.operation_seq_num = wro.operation_seq_num
2668: -- ST : Added the below for bug fix 4619823 --
2669: SET wro.quantity_issued = (SELECT round(decode(sign(nvl(abs(wro1.quantity_issued), 0) - nvl(abs(wro1.quantity_relieved), 0)), 1, 1, 0)
2670: *(nvl(wro1.quantity_issued,0) - nvl(wro1.quantity_relieved, 0))
2671: * p_new_rj_start_qty(l_job_counter)/p_rep_avail_qty, 6)
2672: FROM wip_requirement_operations wro1
2673: WHERE wro1.wip_entity_id = p_rep_we_id
2674: AND wro1.inventory_item_id = wro.inventory_item_id
2675: AND wro1.organization_id = wro.organization_id
2676: AND wro1.operation_seq_num = wro.operation_seq_num
2699: IF p_txn_job_intraop = 1 THEN
2700:
2701: -- Added abs() on quantity_issued for bug 6053122(fp for 5843039)
2702:
2703: UPDATE wip_requirement_operations wro
2704: -- ST : Commenting for bug fix 4619823
2705: -- SET wro.quantity_issued = decode(p_txn_job_intraop,1,round( (decode(sign(nvl(wro.quantity_issued, 0) - nvl(wro.quantity_relieved, 0)),
2706: -- 1, 1
2707: -- , 0)
3174:
3175: l_stmt_num := 55;
3176:
3177: -- Start Additions to fix bug #2682612--
3178: UPDATE WIP_REQUIREMENT_OPERATIONS
3179: SET required_quantity = 0
3180: WHERE WIP_ENTITY_ID = p_wip_entity_id
3181: AND ORGANIZATION_ID = p_org_id
3182: AND (OPERATION_SEQ_NUM >= l_job_op_seq_num