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_GET_NAME dependencies on MSD_DP_ASCP_SCENARIOS_V

Line 2197: FROM msd_dp_ascp_scenarios_v

2193: WHERE designator_id = p_desig_id;
2194:
2195: CURSOR c_scenario_name IS
2196: SELECT scenario_name
2197: FROM msd_dp_ascp_scenarios_v
2198: WHERE scenario_id = p_desig_id
2199: -- AND organization_id = p_organization_id
2200: -- AND sr_instance_id = p_instance_id; for bug 6040537
2201: and decode(sr_instance_id,

Line 2218: L_CACHE VARCHAR2(120); --- msd_dp_ascp_scenarios_v.scenario_name is varchar2(120)

2214:
2215: l_count number;
2216:
2217: l_key varchar2(50);
2218: L_CACHE VARCHAR2(120); --- msd_dp_ascp_scenarios_v.scenario_name is varchar2(120)
2219:
2220: BEGIN
2221:
2222: if p_desig_id is null then

Line 2301: FROM msd_dp_ascp_scenarios_v

2297: AND designator_type = 6);
2298:
2299: CURSOR c_scenario_name IS
2300: SELECT scenario_name
2301: FROM msd_dp_ascp_scenarios_v
2302: WHERE scenario_id = p_desig_id
2303: -- AND organization_id = p_organization_id
2304: -- AND sr_instance_id = p_instance_id; -- for bug 6040537
2305: and decode(sr_instance_id,