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.MSD_APPLY_TEMPLATE_DEMAND_PLAN dependencies on MSD_DP_SUPPLY_PLANS

Line 2190: from msd_dp_supply_plans

2186: cursor c2(p_demand_plan_name in varchar2) is
2187:
2188: select distinct supply_plan_id, supply_plan_name -- Bug 4729854
2189:
2190: from msd_dp_supply_plans
2191:
2192: where demand_plan_name = p_demand_plan_name;
2193:
2194:

Line 2200: from msd_dp_supply_plans

2196: cursor c3(p_demand_plan_name in varchar2) is
2197:
2198: select count(*)
2199:
2200: from msd_dp_supply_plans
2201:
2202: where demand_plan_name = p_demand_plan_name;
2203:
2204:

Line 2241: select max(supply_plan_id) into l_liab_plan_id from msd_dp_supply_plans where demand_plan_name = l_demand_plan_name;

2237:
2238: close c1;
2239:
2240: if p_plan_type='EOL' then
2241: select max(supply_plan_id) into l_liab_plan_id from msd_dp_supply_plans where demand_plan_name = l_demand_plan_name;
2242: update msd_demand_plans set liab_plan_id=l_liab_plan_id where demand_plan_id=p_new_dp_id;
2243: end if;
2244:
2245: -- for each suuply plan selected in Template window

Line 2296: delete from msd_dp_supply_plans

2292:
2293:
2294: -- delete data as not required after this
2295:
2296: delete from msd_dp_supply_plans
2297:
2298: where demand_plan_name = l_demand_plan_name;
2299:
2300: