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_DP_SCENARIO_PKG dependencies on MSD_DEMAND_PLANS

Line 49: from MSD_DEMAND_PLANS

45:
46: -- translate values to IDs
47: select DEMAND_PLAN_ID
48: into l_demand_plan_id
49: from MSD_DEMAND_PLANS
50: where DEMAND_PLAN_NAME = P_DEMAND_PLAN_NAME;
51:
52:
53: -- Translate owner to file_last_updated_by

Line 277: demand_plan_id = (select demand_plan_id from msd_demand_plans where demand_plan_name = p_demand_plan_name)

273: LAST_UPDATED_BY = f_luby,
274: LAST_UPDATE_LOGIN = 0,
275: SOURCE_LANG = userenv('LANG')
276: where
277: demand_plan_id = (select demand_plan_id from msd_demand_plans where demand_plan_name = p_demand_plan_name)
278: and scenario_id = (select scenario_id from msd_dp_scenarios where scenario_name = p_scenario_name
279: and demand_plan_id = (select demand_plan_id from msd_demand_plans where demand_plan_name = p_demand_plan_name))
280: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
281: END;

Line 279: and demand_plan_id = (select demand_plan_id from msd_demand_plans where demand_plan_name = p_demand_plan_name))

275: SOURCE_LANG = userenv('LANG')
276: where
277: demand_plan_id = (select demand_plan_id from msd_demand_plans where demand_plan_name = p_demand_plan_name)
278: and scenario_id = (select scenario_id from msd_dp_scenarios where scenario_name = p_scenario_name
279: and demand_plan_id = (select demand_plan_id from msd_demand_plans where demand_plan_name = p_demand_plan_name))
280: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
281: END;
282:
283: Procedure ADD_LANGUAGE