eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_ATP_PEG dependencies on MSC_FULL_PEGGING

Line 2000: -- from MSC_FULL_PEGGING in a loop.

1996: -- Bug 3344102 Procedure End
1997:
1998: -- Bug 3750638 Move all the pegging releated SQLs into this procedure.
1999: -- This procedure fetches pegging data for a Sales Order
2000: -- from MSC_FULL_PEGGING in a loop.
2001: PROCEDURE Get_Pegging_Data_Loop (p_plan_id IN NUMBER,
2002: c_items_rec IN ATP_End_Config_Dmd_Typ,
2003: x_return_status OUT NoCopy VARCHAR2 )
2004: IS

Line 2134: msc_full_pegging peg1 ,

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
2138: WHERE d1.plan_id = p_plan_id

Line 2135: msc_full_pegging peg2 ,

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
2138: WHERE d1.plan_id = p_plan_id
2139: AND d1.sr_instance_id = c_items_rec.sr_instance_id

Line 2259: msc_full_pegging peg,

2255: NVL(d.original_demand_id, d.demand_id) original_demand_id,
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

Line 2452: msc_full_pegging peg1 ,

2448: NULL fcst_organization_id, NULL forecast_qty,
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

Line 2600: msc_full_pegging peg1 ,

2596: NULL fcst_organization_id, NULL forecast_qty,
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

Line 2712: msc_full_pegging peg,

2708: -- End Bug 3717618
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