[Home] [Help]
2134: FROM
2135: msc_demands d1,
2136: msc_full_pegging peg1 ,
2137: msc_full_pegging peg2 ,
2138: msc_supplies SUP,
2139: msc_system_items msi
2140: WHERE d1.plan_id = p_plan_id
2141: AND d1.sr_instance_id = c_items_rec.sr_instance_id
2142: AND d1.inventory_item_id = c_items_rec.inventory_item_id
2711: )),
2712: 1) exclude_flag
2713: FROM --msc_atp_detail_peg_temp madpt,
2714: msc_full_pegging peg,
2715: msc_supplies SUP
2716: WHERE madpt.plan_id = p_plan_id
2717: AND madpt.sr_instance_id = c_items_rec.sr_instance_id
2718: AND madpt.reference_item_id = c_items_rec.inventory_item_id
2719: AND madpt.sales_order_line_id = c_items_rec.sales_order_line_id
5293: msc_sch_wb.atp_debug('***** Begin Add_Offset_Supplies *****');
5294: END IF;
5295: IF PG_DEBUG in ('Y', 'C') THEN
5296: msc_sch_wb.atp_debug('Add_Offset_Supplies: ' ||
5297: 'Offsetting msc_supplies for identifier = '
5298: || p_identifier ||' : plan id = '||p_plan_id);
5299: msc_sch_wb.atp_debug('Add_Offset_Supplies: ' || 'Config Line Id = ' || p_config_line_id );
5300: END IF;
5301:
5319: IF PG_DEBUG in ('Y', 'C') THEN
5320: msc_sch_wb.atp_debug('Add_Offset_Supplies: Offset Type Set to '|| l_offset_type);
5321: END IF;
5322:
5323: -- Insert relief quantities as a Offsets in msc_supplies
5324:
5325: -- CTO_PF_PRJ_2 Changes
5326: SELECT msc_supplies_s.nextval,
5327: map.sr_instance_id,
5322:
5323: -- Insert relief quantities as a Offsets in msc_supplies
5324:
5325: -- CTO_PF_PRJ_2 Changes
5326: SELECT msc_supplies_s.nextval,
5327: map.sr_instance_id,
5328: map.organization_id,
5329: map.inventory_item_id,
5330: map.relief_quantity relief_quantity,
5374: l_ship_date,
5375: l_dock_date
5376: FROM
5377: msc_atp_pegging map,
5378: msc_supplies s
5379: WHERE map.plan_id = p_plan_id
5380: --AND map.sr_instance_id = p_instance_id -- removed to support multiple instances in plan.
5381: AND DECODE(map.demand_source_type,100,map.demand_source_type,-1)
5382: =decode(p_demand_source_type,
5404: AND sales_order_line_id in (p_identifier, p_config_line_id)
5405: AND relief_type in (1, DECODE(offset_type, 1, 6, 2))
5406: AND supply_id in
5407: (SELECT transaction_id
5408: FROM msc_supplies S
5409: WHERE S.plan_id = mapeg1.plan_id
5410: AND S.sr_instance_id = mapeg1.sr_instance_id
5411: AND S.transaction_id = mapeg1.supply_id
5412: AND S.inventory_item_id = mapeg1.inventory_item_id
5443:
5444: l_del_rows := x_supply_id.COUNT;
5445:
5446: FORALL i in 1..l_del_rows
5447: INSERT into MSC_SUPPLIES (
5448: plan_id,
5449: transaction_id,
5450: organization_id,
5451: sr_instance_id,
6301: -- End CTO_PF_PRJ_2 Changes
6302:
6303: --Bug 3629191
6304: FORALL m IN 1..p_del_supply_ids.COUNT
6305: DELETE msc_supplies
6306: WHERE
6307: -- Bug 3629191 :All where clause except and transaction_id are commmented
6308: /* sr_instance_id = p_instance_id
6309: (SELECT sr_instance_id