Identify the front-end apps session details for a back-end process.
set linesize 400
column user_name format a30
column user_form_name format a30
column responsibilty_name format a30
select user_name,TIME,user_form_name,responsibility_name from apps.FND_SIGNON_AUDIT_VIEW where pid in
(select pid from v$process where spid=&SPID;
set linesize 400
column user_name format a30
column user_form_name format a30
column responsibilty_name format a30
select user_name,TIME,user_form_name,responsibility_name from apps.FND_SIGNON_AUDIT_VIEW where pid in
(select pid from v$process where spid=&SPID;
No comments:
Post a Comment