[Home] [Help]
2131: peg2.end_pegging_id, peg2.pegging_id, peg2.prev_pegging_id,
2132: NULL fcst_organization_id, NULL forecast_qty,
2133: NULL consumed_qty, NULL overconsumption_qty
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
2258: decode(d.origination_type, 1,
2259: to_char(d.disposition_id), d.order_number)
2260: FROM --msc_atp_detail_peg_temp madpt,
2261: msc_full_pegging peg,
2262: msc_demands d
2263: WHERE madpt.plan_id = p_plan_id
2264: AND madpt.sr_instance_id = c_items_rec.sr_instance_id
2265: AND madpt.reference_item_id = c_items_rec.inventory_item_id
2266: AND madpt.sales_order_line_id = c_items_rec.sales_order_line_id
2451: NULL consumed_qty, NULL overconsumption_qty
2452: FROM
2453: msc_atp_detail_peg_temp adpt,
2454: msc_full_pegging peg1 ,
2455: msc_demands d1,
2456: msc_system_items msi
2457: WHERE adpt.plan_id = p_plan_id
2458: AND adpt.reference_item_id = c_items_rec.inventory_item_id
2459: AND adpt.sales_order_line_id = c_items_rec.sales_order_line_id
2599: NULL consumed_qty, NULL overconsumption_qty
2600: FROM
2601: msc_atp_detail_peg_temp adpt,
2602: msc_full_pegging peg1 ,
2603: msc_demands d1,
2604: msc_system_items msi,
2605: msc_process_effectivity proc,
2606: msc_bom_components mbc
2607: WHERE adpt.plan_id = p_plan_id
2855: msi.sr_instance_id, msi.base_item_id, d.sales_order_line_id,
2856: decode(d.demand_source_type, 100, -- cmro fix
2857: d.demand_source_type, -1) demand_source_type, -- cmro fix
2858: d.demand_class, d.demand_id -- Bug 3319810 Add the sales_order demand class
2859: FROM msc_system_items msi, msc_demands d
2860: WHERE msi.plan_id = p_plan_id
2861: AND msi.bom_item_type = 4
2862: AND msi.base_item_id is NOT NULL
2863: AND msi.replenish_to_order_flag = 'Y'
3026: msc_util.msc_log('MSC_ATP_PLAN_PARTITION_MISSING : Partition ' || l_partition_name || ' NOT FOUND');
3027: -- Find out presence of config items.
3028: SELECT 1
3029: INTO l_count
3030: FROM msc_system_items msi, msc_demands d
3031: WHERE msi.plan_id = p_plan_id
3032: AND msi.bom_item_type = 4
3033: AND msi.base_item_id is NOT NULL
3034: AND msi.replenish_to_order_flag = 'Y'
4764: END IF;
4765:
4766: IF PG_DEBUG in ('Y', 'C') THEN
4767: msc_sch_wb.atp_debug('Add_Offset_Demands: ' ||
4768: 'Offsetting msc_demands for identifier = '
4769: || p_identifier ||' : plan id = '||p_plan_id);
4770: msc_sch_wb.atp_debug('Add_Offset_Demands: ' || 'Config Line Id = ' || p_config_line_id );
4771: END IF;
4772:
4797: msc_sch_wb.atp_debug('Add_Offset_Demands: Sup. Offset Type Set to '|| l_sup_offset_type);
4798: END IF;
4799:
4800: -- CTO_PF_PRJ_2 Impacts
4801: SELECT msc_demands_s.nextval ,
4802: map.relief_quantity ,
4803: NVL(map.original_date, map.transaction_date) transaction_date ,
4804: -- End CTO_PF_PRJ_2 Impacts
4805: map.reference_item_id,
4851: l_original_demand_date
4852: -- End CTO_PF_PRJ Impacts
4853: FROM
4854: msc_atp_pegging map,
4855: msc_demands d
4856: WHERE map.plan_id = p_plan_id
4857: --AND map.sr_instance_id = p_instance_id -- removed to support multiple instances in plan.
4858: AND map.sales_order_line_id in (p_identifier, p_config_line_id)
4859: -- CTO_PF_PRJ_2 Impacts
4897:
4898: l_del_rows := x_demand_id.COUNT;
4899:
4900: FORALL i in 1..l_del_rows
4901: INSERT INTO msc_demands (
4902: DEMAND_ID,
4903: USING_REQUIREMENT_QUANTITY,
4904: USING_ASSEMBLY_DEMAND_DATE,
4905: DEMAND_TYPE,
6120: -- End CTO_PF_PRJ_2
6121:
6122: --Bug 3629191
6123: FORALL m IN 1..p_del_demand_ids.COUNT
6124: DELETE msc_demands
6125: WHERE
6126: -- Bug 3629191 :All where clause except plan_id and demand_id are commmented
6127: /* sr_instance_id = p_instance_id
6128: (SELECT sr_instance_id