[Home] [Help]
2129: peg2.end_pegging_id, peg2.pegging_id, peg2.prev_pegging_id,
2130: NULL fcst_organization_id, NULL forecast_qty,
2131: NULL consumed_qty, NULL overconsumption_qty
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
2256: decode(d.origination_type, 1,
2257: to_char(d.disposition_id), d.order_number)
2258: FROM --msc_atp_detail_peg_temp madpt,
2259: msc_full_pegging peg,
2260: msc_demands d
2261: WHERE madpt.plan_id = p_plan_id
2262: AND madpt.sr_instance_id = c_items_rec.sr_instance_id
2263: AND madpt.reference_item_id = c_items_rec.inventory_item_id
2264: AND madpt.sales_order_line_id = c_items_rec.sales_order_line_id
2449: NULL consumed_qty, NULL overconsumption_qty
2450: FROM
2451: msc_atp_detail_peg_temp adpt,
2452: msc_full_pegging peg1 ,
2453: msc_demands d1,
2454: msc_system_items msi
2455: WHERE adpt.plan_id = p_plan_id
2456: AND adpt.reference_item_id = c_items_rec.inventory_item_id
2457: AND adpt.sales_order_line_id = c_items_rec.sales_order_line_id
2597: NULL consumed_qty, NULL overconsumption_qty
2598: FROM
2599: msc_atp_detail_peg_temp adpt,
2600: msc_full_pegging peg1 ,
2601: msc_demands d1,
2602: msc_system_items msi,
2603: msc_process_effectivity proc,
2604: msc_bom_components mbc
2605: WHERE adpt.plan_id = p_plan_id
2853: msi.sr_instance_id, msi.base_item_id, d.sales_order_line_id,
2854: decode(d.demand_source_type, 100, -- cmro fix
2855: d.demand_source_type, -1) demand_source_type, -- cmro fix
2856: d.demand_class, d.demand_id -- Bug 3319810 Add the sales_order demand class
2857: FROM msc_system_items msi, msc_demands d
2858: WHERE msi.plan_id = p_plan_id
2859: AND msi.bom_item_type = 4
2860: AND msi.base_item_id is NOT NULL
2861: AND msi.replenish_to_order_flag = 'Y'
3024: msc_util.msc_log('MSC_ATP_PLAN_PARTITION_MISSING : Partition ' || l_partition_name || ' NOT FOUND');
3025: -- Find out presence of config items.
3026: SELECT 1
3027: INTO l_count
3028: FROM msc_system_items msi, msc_demands d
3029: WHERE msi.plan_id = p_plan_id
3030: AND msi.bom_item_type = 4
3031: AND msi.base_item_id is NOT NULL
3032: AND msi.replenish_to_order_flag = 'Y'
4750: END IF;
4751:
4752: IF PG_DEBUG in ('Y', 'C') THEN
4753: msc_sch_wb.atp_debug('Add_Offset_Demands: ' ||
4754: 'Offsetting msc_demands for identifier = '
4755: || p_identifier ||' : plan id = '||p_plan_id);
4756: msc_sch_wb.atp_debug('Add_Offset_Demands: ' || 'Config Line Id = ' || p_config_line_id );
4757: END IF;
4758:
4783: msc_sch_wb.atp_debug('Add_Offset_Demands: Sup. Offset Type Set to '|| l_sup_offset_type);
4784: END IF;
4785:
4786: -- CTO_PF_PRJ_2 Impacts
4787: SELECT msc_demands_s.nextval ,
4788: map.relief_quantity ,
4789: NVL(map.original_date, map.transaction_date) transaction_date ,
4790: -- End CTO_PF_PRJ_2 Impacts
4791: map.reference_item_id,
4837: l_original_demand_date
4838: -- End CTO_PF_PRJ Impacts
4839: FROM
4840: msc_atp_pegging map,
4841: msc_demands d
4842: WHERE map.plan_id = p_plan_id
4843: --AND map.sr_instance_id = p_instance_id -- removed to support multiple instances in plan.
4844: AND map.sales_order_line_id in (p_identifier, p_config_line_id)
4845: -- CTO_PF_PRJ_2 Impacts
4883:
4884: l_del_rows := x_demand_id.COUNT;
4885:
4886: FORALL i in 1..l_del_rows
4887: INSERT INTO msc_demands (
4888: DEMAND_ID,
4889: USING_REQUIREMENT_QUANTITY,
4890: USING_ASSEMBLY_DEMAND_DATE,
4891: DEMAND_TYPE,
6106: -- End CTO_PF_PRJ_2
6107:
6108: --Bug 3629191
6109: FORALL m IN 1..p_del_demand_ids.COUNT
6110: DELETE msc_demands
6111: WHERE
6112: -- Bug 3629191 :All where clause except plan_id and demand_id are commmented
6113: /* sr_instance_id = p_instance_id
6114: (SELECT sr_instance_id