Category: PIPER-Rx Reports (Free) Name: FUA002-11 Active Self Service Connections ReportDefFileName: .\FUA002-11 Active Self 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 -- ** -- ** Any session that has had no activity for 60 min will -- ** be concidered closed -- ** ------------------------------------------------- -- ** Version 1.0 Apr-09 G.Piper Initial Creation -- ** Version 1.1 Aug-09 G.Piper Referenced GV$DATABASE -- ** Report name change from Self Service Connections -- ** to Active Self Service Connections -- **************************************************** SELECT report_headings.report_date, report_headings.sid_name, isess.user_id, fu.user_name, substr(fu.description, 1, 40) description, substr(fu.email_address, 1, 40) email_address, substr(ood.organization_name, 1, 30 ) organisation, substr(frt.responsibility_name, 1, 45 ) active_responsibility, substr(ffft.user_function_name, 1, 45) function_name, isess.counter page_requests, to_char(isess.first_connect, 'DD-MON-YY HH24:MI:SS') start_time, round((sysdate - isess.first_connect)*24*60 ,0) connection_time_min FROM apps.icx_sessions isess, apps.fnd_user fu, apps.fnd_responsibility_tl frt, apps.fnd_form_functions_tl ffft, apps.org_organization_definitions ood, (SELECT to_char(sysdate, 'DD-Mon-YY HH24:MI') report_date, vd.name sid_name FROM gv$database vd WHERE vd.inst_id = 1 ) report_headings WHERE isess.user_id = fu.user_id and isess.responsibility_id = frt.responsibility_id(+) and frt.language(+) = userenv('LANG') and isess.function_id = ffft.function_id(+) and ffft.language(+) = userenv('LANG') and isess.org_id = ood.organization_id(+) and isess.disabled_flag = 'N' and (sysdate - isess.last_connect) *24*60 <= 60 and ((isess.function_id is not null ) or (isess.function_id is null and isess.counter > 1 )) -- removes shadow processes ORDER by isess.first_connect ===End SQL=== ===Begin Report Definition===