set linesize 400
column user_name format a30
column user_form_name format a30
column responsibilty_name format a30
select c.sid,c.serial#, a.user_name,a.TIME,a.user_form_name,a.responsibility_name,b.pid
from
apps.FND_SIGNON_AUDIT_VIEW a,
v$process b,
v$session c
where
a.pid=b.pid
and
b.addr=c.paddr
and
A.USERNAME='&NAME';
column user_name format a30
column user_form_name format a30
column responsibilty_name format a30
select c.sid,c.serial#, a.user_name,a.TIME,a.user_form_name,a.responsibility_name,b.pid
from
apps.FND_SIGNON_AUDIT_VIEW a,
v$process b,
v$session c
where
a.pid=b.pid
and
b.addr=c.paddr
and
A.USERNAME='&NAME';
No comments:
Post a Comment