APPS.MSC_UTIL dependencies on V$SESSION

Line 109: FROM v$session_event

105: Print_Msg('Top WAIT events');
106: Print_Msg('------------------------------------------------------------');
107: print_query('SELECT SID, EVENT,seconds_waited FROM
108: (SELECT SID, EVENT, TIME_WAITED/100 seconds_waited
109: FROM v$session_event
110: WHERE SID=' || G_CURRENT_SESSION_ID || '
111: ORDER BY sid, TIME_WAITED DESC )
112: WHERE ROWNUM < 10');
113: Print_Msg('************************************************************');

Line 251: v$session ses ,

247: oracle_Process_id Trace_id ,
248: req.enable_trace Trace_Flag,
249: dest.value||''/''||lower (dbnm.value) ||''_ora_''||oracle_process_id||''.trc'' Trace_File_Name
250: FROM fnd_concurrent_requests req,
251: v$session ses ,
252: v$process PROC ,
253: v$parameter dest ,
254: v$parameter dbnm ,
255: fnd_concurrent_programs_vl prog ,

Line 1681: from v$session

1677:
1678: begin
1679: select sid
1680: into G_CURRENT_SESSION_ID
1681: from v$session
1682: where audsid = SYS_CONTEXT('USERENV','SESSIONID');
1683: exception when others then
1684: G_CURRENT_SESSION_ID := 0;
1685: end ;