APPS.MSC_UTIL dependencies on V$SESSION

Line 105: FROM v$session_event

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

Line 236: v$session ses ,

232: oracle_Process_id Trace_id ,
233: req.enable_trace Trace_Flag,
234: dest.value||''/''||lower (dbnm.value) ||''_ora_''||oracle_process_id||''.trc'' Trace_File_Name
235: FROM fnd_concurrent_requests req,
236: v$session ses ,
237: v$process PROC ,
238: v$parameter dest ,
239: v$parameter dbnm ,
240: fnd_concurrent_programs_vl prog ,

Line 1325: from v$session

1321:
1322: begin
1323: select sid
1324: into G_CURRENT_SESSION_ID
1325: from v$session
1326: where audsid = SYS_CONTEXT('USERENV','SESSIONID');
1327: exception when others then
1328: G_CURRENT_SESSION_ID := 0;
1329: end ;