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.ALR_DBTRIGGER dependencies on DUAL

Line 291: from dual

287: begin
288:
289: select 'N'
290: into no_org_flag
291: from dual
292: where exists
293: (select 1
294: from alr_alerts a,
295: alr_alert_installations i

Line 820: -- 'into ORGID from dual;' ||

816:
817: -- JWSMITH Bug 6996306 - no longer user client_infor for org_id
818: -- Check if trigger is fired from enabled installations
819: --'select rtrim(substr(userenv(''CLIENT_INFO''),1,10)) '||
820: -- 'into ORGID from dual;' ||
821:
822: -- bug 6996306
823: 'select nvl(mo_global.get_current_org_id, 0) into MORGID from dual;' ||
824: 'if (MORGID = 0) then ' ||

Line 823: 'select nvl(mo_global.get_current_org_id, 0) into MORGID from dual;' ||

819: --'select rtrim(substr(userenv(''CLIENT_INFO''),1,10)) '||
820: -- 'into ORGID from dual;' ||
821:
822: -- bug 6996306
823: 'select nvl(mo_global.get_current_org_id, 0) into MORGID from dual;' ||
824: 'if (MORGID = 0) then ' ||
825: ' fnd_profile.get(''XLA_MO_SECURITY_PROFILE_LEVEL'',
826: l_security_profile_id);' ||
827: ' if (l_security_profile_id is NULL) then ' ||