APPS.MSC_ATP_PEG dependencies on MSC_ALLOC_DEMANDS

Line 4976: ' msc_alloc_demands');

4972: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
4973:
4974: IF PG_DEBUG in ('Y', 'C') THEN
4975: msc_sch_wb.atp_debug('Add_Offset_Demands: before insert into'||
4976: ' msc_alloc_demands');
4977: END IF;
4978:
4979: -- CTO_PF_PRJ2 relief_type already set above.
4980: -- Bug 3344102 First set offset type to 5 for alloc reliefs.

Line 4987: INSERT INTO MSC_ALLOC_DEMANDS(

4983:
4984: -- Try to apply the offsets using alloc specific relief_type.
4985:
4986: FORALL i in 1..x_demand_id.COUNT
4987: INSERT INTO MSC_ALLOC_DEMANDS(
4988: PLAN_ID,
4989: INVENTORY_ITEM_ID,
4990: ORGANIZATION_ID,
4991: SR_INSTANCE_ID,

Line 5127: INSERT INTO MSC_ALLOC_DEMANDS(

5123: ELSE
5124: -- Try to apply the offsets using alloc specific relief_type.
5125:
5126: FORALL i in 1..x_demand_id.COUNT
5127: INSERT INTO MSC_ALLOC_DEMANDS(
5128: PLAN_ID,
5129: INVENTORY_ITEM_ID,
5130: ORGANIZATION_ID,
5131: SR_INSTANCE_ID,

Line 6162: ' msc_alloc_demands');

6158: -- Relief_Type 7 can get created irrespective of allocation profiles.
6159:
6160: IF PG_DEBUG in ('Y', 'C') THEN
6161: msc_sch_wb.atp_debug('Remove_Offset_Demands: before delete from ' ||
6162: ' msc_alloc_demands');
6163: END IF;
6164:
6165: --Bug 3629191
6166: FORALL m IN 1..p_del_demand_ids.COUNT

Line 6167: DELETE msc_alloc_demands

6163: END IF;
6164:
6165: --Bug 3629191
6166: FORALL m IN 1..p_del_demand_ids.COUNT
6167: DELETE msc_alloc_demands
6168: WHERE
6169: -- Bug 3629191 :All where clause except plan_id and parent_demand_id are commmented
6170: /*sr_instance_id IN
6171: (SELECT sr_instance_id

Line 6618: FROM msc_atp_peg_temp mapt, msc_alloc_demands alocd,

6614: DECODE(MSC_ATP_PVT.G_ALLOCATION_METHOD, 2, 2,
6615: decode(alloc.inventory_item_id, null, 2 , 1)
6616: )
6617: ) offset_type
6618: FROM msc_atp_peg_temp mapt, msc_alloc_demands alocd,
6619: msc_system_items msi, msc_item_hierarchy_mv alloc
6620: WHERE mapt.reference_item_id = p_reference_item_id
6621: AND mapt.plan_id = p_plan_id
6622: AND mapt.sales_order_line_id = NVL(p_config_order_line_id, p_model_order_line_id)

Line 6670: FROM msc_atp_peg_temp mapt, msc_alloc_demands alocd,

6666: mapt.pegging_id, mapt.prev_pegging_id, mapt.end_pegging_id, mapt.end_demand_id,
6667: mapt.created_by, mapt.creation_date, mapt.last_updated_by, mapt.last_update_date,
6668: mapt.inventory_item_id, mapt.transaction_date,
6669: alocd.customer_id, alocd.ship_to_site_id, 2
6670: FROM msc_atp_peg_temp mapt, msc_alloc_demands alocd,
6671: msc_system_items msi
6672: WHERE mapt.reference_item_id = p_reference_item_id
6673: AND mapt.plan_id = p_plan_id
6674: AND mapt.sales_order_line_id = NVL(p_config_order_line_id, p_model_order_line_id)