APPS.MSC_ATP_PEG dependencies on MSC_SUPPLIES_S

Line 2136: msc_supplies SUP,

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

Line 2713: msc_supplies SUP

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

Line 5312: SELECT msc_supplies_s.nextval,

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,

Line 5364: msc_supplies s

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,

Line 5394: FROM msc_supplies S

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