APPS.FND_ADG_UTILITY dependencies on V$SESSION

Line 472: from v$session a

468: as
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:

Line 534: from v$session a,v$process b

530: p_trace_error number)
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

Line 1206: from v$session a

1202: /* Get my sid/serial */
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:

Line 1213: ' from v$session@'||p_link_name|| ' a' ||

1209: /* Make sure not a loopback session */
1210:
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:

Line 1280: ' from v$session@'||p_link_name|| ' a' ||

1276: begin
1277:
1278: execute immediate
1279: 'select a.client_info ' ||
1280: ' from v$session@'||p_link_name|| ' a' ||
1281: ' where a.sid = ' || l_sid ||
1282: ' and a.serial# = ' || l_serial
1283: into l_rpc_client_info;
1284:

Line 1401: ' from v$session a,v$process b ' ||

1397: begin
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:

Line 2943: from gv$session b

2939: delete from fnd_adg_commit_wait a
2940: where a.session_id < userenv('SESSIONID')
2941: and not exists
2942: ( select 1
2943: from gv$session b
2944: where b.audsid = a.session_id
2945: );
2946:
2947: commit;