APPS.MSC_ATP_PEG dependencies on MSC_SUPPLIES_S

Line 2138: msc_supplies SUP,

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

Line 2715: msc_supplies SUP

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

Line 5326: SELECT msc_supplies_s.nextval,

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,

Line 5378: msc_supplies s

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,

Line 5408: FROM msc_supplies S

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