Category: PIPER-Rx Reports (Free) Name: FUA001-11 Active Full Service Connections ReportDefFileName: .\FUA001-11 Active Full Service Connections.fr3 ===Begin Comments=== Copyright (C) 2009 G Piper This program is free software: you can redistribute it and/or modify it under the terms of the GNU Affero General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more details. a copy of the GNU Affero General Public Licenses provided is part of the down load Terms and Conditions available on our site www.piper-rx.com or you can refere to www.gnu.org/licenses/gpl.html ===End Comments=== ===Begin SQL=== -- **************************************************** -- ** PIPER-RX - Free Reports -- ** -- ** Copyright (C) 2009 G.Piper -- ** -- ** Active Full Service Connections -- ** -- ** ------------------------------------------------- -- ** Version 1.0 Apr-09 G.Piper Initial Creation -- ** Version 1.1 Aug-09 G.Piper Referenced GV$DATABASE -- ** Report name change from Full Service Connections -- ** to Active Full Service Connections -- **************************************************** SELECT to_char(fl.start_time, 'DD-Mon-YY HH24:MI:SS') report_date, report_headings.sid_name sid_name, fu.user_name, substr(fu.description, 1, 40) description, substr(fu.email_address, 1, 40) email_address, substr(responsibilities.responsibility_name, 1, 60 ) active_responsibility, substr(forms.user_form_name, 1, 60) active_form, to_char(fl.start_time, 'DD-Mon-YY HH24:MI') start_time, round(((sysdate - fl.start_time) *24 * 60 ),0) connect_time_min FROM applsys.fnd_logins fl, applsys.fnd_user fu, ( SELECT flr.login_id, frt.responsibility_name FROM apps.fnd_login_responsibilities flr, apps.fnd_responsibility_tl frt WHERE flr.responsibility_id = frt.responsibility_id(+) and flr.resp_appl_id = frt.application_id(+) and frt.language(+) = userenv('LANG') ) responsibilities, ( SELECT flrf.login_id, fft.user_form_name FROM apps.fnd_login_resp_forms flrf, apps.fnd_form_tl fft WHERE flrf.form_id = fft.form_id(+) and flrf.form_appl_id = fft.application_id(+) and fft.language(+) = userenv('LANG')) forms, ( SELECT vd.name sid_name FROM gv$database vd WHERE vd.inst_id = 1) report_headings, ( SELECT max(startup_time) restart_time FROM gv$instance GROUP by instance_name) last_db_restart WHERE fl.user_id = fu.user_id and fl.login_id = responsibilities.login_id and fl.login_id = forms.login_id(+) and fl.end_time is null and fl.start_time > last_db_restart.restart_time -- limit dead sessions (basic) and nvl(fl.terminal_id, 'X') != 'Concurrent' ORDER by fl.start_time ===End SQL=== ===Begin Report Definition===