[Home] [Help]
2132: FROM
2133: msc_demands d1,
2134: msc_full_pegging peg1 ,
2135: msc_full_pegging peg2 ,
2136: msc_supplies SUP,
2137: msc_system_items msi
2138: WHERE d1.plan_id = p_plan_id
2139: AND d1.sr_instance_id = c_items_rec.sr_instance_id
2140: AND d1.inventory_item_id = c_items_rec.inventory_item_id
2709: )),
2710: 1) exclude_flag
2711: FROM --msc_atp_detail_peg_temp madpt,
2712: msc_full_pegging peg,
2713: msc_supplies SUP
2714: WHERE madpt.plan_id = p_plan_id
2715: AND madpt.sr_instance_id = c_items_rec.sr_instance_id
2716: AND madpt.reference_item_id = c_items_rec.inventory_item_id
2717: AND madpt.sales_order_line_id = c_items_rec.sales_order_line_id
5279: msc_sch_wb.atp_debug('***** Begin Add_Offset_Supplies *****');
5280: END IF;
5281: IF PG_DEBUG in ('Y', 'C') THEN
5282: msc_sch_wb.atp_debug('Add_Offset_Supplies: ' ||
5283: 'Offsetting msc_supplies for identifier = '
5284: || p_identifier ||' : plan id = '||p_plan_id);
5285: msc_sch_wb.atp_debug('Add_Offset_Supplies: ' || 'Config Line Id = ' || p_config_line_id );
5286: END IF;
5287:
5305: IF PG_DEBUG in ('Y', 'C') THEN
5306: msc_sch_wb.atp_debug('Add_Offset_Supplies: Offset Type Set to '|| l_offset_type);
5307: END IF;
5308:
5309: -- Insert relief quantities as a Offsets in msc_supplies
5310:
5311: -- CTO_PF_PRJ_2 Changes
5312: SELECT msc_supplies_s.nextval,
5313: map.sr_instance_id,
5308:
5309: -- Insert relief quantities as a Offsets in msc_supplies
5310:
5311: -- CTO_PF_PRJ_2 Changes
5312: SELECT msc_supplies_s.nextval,
5313: map.sr_instance_id,
5314: map.organization_id,
5315: map.inventory_item_id,
5316: map.relief_quantity relief_quantity,
5360: l_ship_date,
5361: l_dock_date
5362: FROM
5363: msc_atp_pegging map,
5364: msc_supplies s
5365: WHERE map.plan_id = p_plan_id
5366: --AND map.sr_instance_id = p_instance_id -- removed to support multiple instances in plan.
5367: AND DECODE(map.demand_source_type,100,map.demand_source_type,-1)
5368: =decode(p_demand_source_type,
5390: AND sales_order_line_id in (p_identifier, p_config_line_id)
5391: AND relief_type in (1, l_offset_type)
5392: AND supply_id in
5393: (SELECT transaction_id
5394: FROM msc_supplies S
5395: WHERE S.plan_id = mapeg1.plan_id
5396: AND S.sr_instance_id = mapeg1.sr_instance_id
5397: AND S.transaction_id = mapeg1.supply_id
5398: AND S.inventory_item_id = mapeg1.inventory_item_id
5429:
5430: l_del_rows := x_supply_id.COUNT;
5431:
5432: FORALL i in 1..l_del_rows
5433: INSERT into MSC_SUPPLIES (
5434: plan_id,
5435: transaction_id,
5436: organization_id,
5437: sr_instance_id,
6287: -- End CTO_PF_PRJ_2 Changes
6288:
6289: --Bug 3629191
6290: FORALL m IN 1..p_del_supply_ids.COUNT
6291: DELETE msc_supplies
6292: WHERE
6293: -- Bug 3629191 :All where clause except and transaction_id are commmented
6294: /* sr_instance_id = p_instance_id
6295: (SELECT sr_instance_id