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 2002: -- from MSC_FULL_PEGGING in a loop.

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

Line 2136: msc_full_pegging peg1 ,

2132: NULL fcst_organization_id, NULL forecast_qty,
2133: NULL consumed_qty, NULL overconsumption_qty
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

Line 2137: msc_full_pegging peg2 ,

2133: NULL consumed_qty, NULL overconsumption_qty
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

Line 2261: msc_full_pegging peg,

2257: NVL(d.original_demand_id, d.demand_id) original_demand_id,
2258: decode(d.origination_type, 1,
2259: to_char(d.disposition_id), d.order_number)
2260: FROM --msc_atp_detail_peg_temp madpt,
2261: msc_full_pegging peg,
2262: msc_demands d
2263: WHERE madpt.plan_id = p_plan_id
2264: AND madpt.sr_instance_id = c_items_rec.sr_instance_id
2265: AND madpt.reference_item_id = c_items_rec.inventory_item_id

Line 2454: msc_full_pegging peg1 ,

2450: NULL fcst_organization_id, NULL forecast_qty,
2451: NULL consumed_qty, NULL overconsumption_qty
2452: FROM
2453: msc_atp_detail_peg_temp adpt,
2454: msc_full_pegging peg1 ,
2455: msc_demands d1,
2456: msc_system_items msi
2457: WHERE adpt.plan_id = p_plan_id
2458: AND adpt.reference_item_id = c_items_rec.inventory_item_id

Line 2602: msc_full_pegging peg1 ,

2598: NULL fcst_organization_id, NULL forecast_qty,
2599: NULL consumed_qty, NULL overconsumption_qty
2600: FROM
2601: msc_atp_detail_peg_temp adpt,
2602: msc_full_pegging peg1 ,
2603: msc_demands d1,
2604: msc_system_items msi,
2605: msc_process_effectivity proc,
2606: msc_bom_components mbc

Line 2714: msc_full_pegging peg,

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