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_VALIDATE dependencies on DUAL

Line 105: select DECODE(p_detail,'1','2','2','1') into lv_report_type from DUAL;

101: lv_report_type varchar2(1);
102:
103: begin
104:
105: select DECODE(p_detail,'1','2','2','1') into lv_report_type from DUAL;
106: run_validation_all (lv_errbuf,
107: lv_ret_code,
108: 'MSD',
109: p_function,

Line 280: FROM dual;

276: FND_GLOBAL.APPLICATION_NAME
277: INTO v_user_name,
278: v_resp_name,
279: v_application_name
280: FROM dual;
281:
282: /* If the input to Instances is ALL INSTANCES (-1) THEN LOOP thru all the instances
283: If the input to Instances is 0 It indicates that the existing DP Reports are making a call
284: exit after first loop. This is being done to retain existing functionality of DP

Line 365: select decode(nvl(s.where_clause,'N'),'N','N','Y') into lv_where_clause from dual;

361: get_td_tag(s.column10) || ',' ||
362: get_td_tag(s.column11);
363: end if;
364:
365: select decode(nvl(s.where_clause,'N'),'N','N','Y') into lv_where_clause from dual;
366: If lv_where_clause = 'Y' then
367: v_sql_stmt := v_sql_stmt || ' FROM ' || replace(s.from_clause,'@M2A_DBLINK',v_m2a_dblink) ||
368: ' WHERE '|| replace(replace(replace(replace(replace(s.where_clause,'@M2A_DBLINK',v_m2a_dblink),'@INSTANCE_ID',v_instance_id),'@PLAN_ID',v_plan_id),'@INSTANCE_CODE',v_instance_code),'@A2M_DBLINK',v_a2m_dblink);
369: else