APPS.FND_ADG_UTILITY dependencies on V$MYSTAT

Line 473: where a.sid = ( select distinct b.sid from v$mystat b);

469: l_rec fnd_adg_control%rowtype;
470:
471: cursor c1 is select a.service_name
472: from v$session a
473: where a.sid = ( select distinct b.sid from v$mystat b);
474:
475: begin
476:
477: G_SESS_SIMULATED_STDBY_ENABLED := false;

Line 535: where a.sid = ( select distinct c.sid from v$mystat c)

531: as
532: PRAGMA AUTONOMOUS_TRANSACTION;
533: cursor c1 is select b.pid,b.spid,a.audsid,a.process
534: from v$session a,v$process b
535: where a.sid = ( select distinct c.sid from v$mystat c)
536: and a.paddr = b.addr;
537:
538: begin
539:

Line 1207: where a.sid = ( select distinct b.sid from v$mystat b);

1203:
1204: select a.sid,a.serial#
1205: into l_sid,l_serial
1206: from v$session a
1207: where a.sid = ( select distinct b.sid from v$mystat b);
1208:
1209: /* Make sure not a loopback session */
1210:
1211: execute immediate

Line 1215: ' ( select distinct b.sid from v$mystat@'||p_link_name||' b)'

1211: execute immediate
1212: 'select a.sid,a.serial#,a.service_name ' ||
1213: ' from v$session@'||p_link_name|| ' a' ||
1214: ' where a.sid = ' ||
1215: ' ( select distinct b.sid from v$mystat@'||p_link_name||' b)'
1216: into l_rpc_sid,l_rpc_serial,l_rpc_service_name;
1217:
1218: /*
1219: sys.dbms_output.put_line

Line 1402: ' where a.sid = ( select distinct c.sid from v$mystat c) ' ||

1398:
1399: execute immediate
1400: 'select b.tracefile ' ||
1401: ' from v$session a,v$process b ' ||
1402: ' where a.sid = ( select distinct c.sid from v$mystat c) ' ||
1403: ' and a.paddr = b.addr'
1404: into l_tracefile;
1405:
1406: exception