DBA Data[Home] [Help] [Dependency Information]

VIEW: APPLSYS.AD_SESSIONS#

Object Details
Object Name: AD_SESSIONS#
Object Type: VIEW
Owner: APPLSYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
SESSION_ID NUMBER
Yes
UTILITY_NAME VARCHAR2 (8) Yes
APPL_TOP_ID NUMBER
Yes
INVOKDIR VARCHAR2 (256) Yes
STATUS VARCHAR2 (30) Yes
PRIORITY NUMBER
Yes
OS_PROCESS_ID NUMBER
Yes
OS_USER_NAME VARCHAR2 (30) Yes
START_DATE DATE
Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
APPL_TOP_PATH VARCHAR2 (256) Yes
CONTEXT_INFO VARCHAR2 (256)
WAIT_LOOP_TIME NUMBER

CONTROL_CODE VARCHAR2 (1)
ANY_CHANGE_WHILE_INACTIVE_FLAG VARCHAR2 (1)
JS_TOTAL_JOBS NUMBER

JS_COMPLETED_JOBS NUMBER

JS_REMAINING_JOBS NUMBER

JS_CURR_PHASE VARCHAR2 (30)
JS_JOBS_REM_IN_CURR_PHASE NUMBER

JS_JOBS_ASS_IN_CURR_PHASE NUMBER

JS_JOBS_READY_IN_CURR_PHASE NUMBER

JS_JOBS_WAITING_IN_CURR_PHASE NUMBER

RUN_ON_NODE VARCHAR2 (30) Yes
LOCKS_OVERRIDDEN_BY NUMBER

TOPDIR VARCHAR2 (256) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SESSION_ID
,      UTILITY_NAME
,      APPL_TOP_ID
,      INVOKDIR
,      STATUS
,      PRIORITY
,      OS_PROCESS_ID
,      OS_USER_NAME
,      START_DATE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      APPL_TOP_PATH
,      CONTEXT_INFO
,      WAIT_LOOP_TIME
,      CONTROL_CODE
,      ANY_CHANGE_WHILE_INACTIVE_FLAG
,      JS_TOTAL_JOBS
,      JS_COMPLETED_JOBS
,      JS_REMAINING_JOBS
,      JS_CURR_PHASE
,      JS_JOBS_REM_IN_CURR_PHASE
,      JS_JOBS_ASS_IN_CURR_PHASE
,      JS_JOBS_READY_IN_CURR_PHASE
,      JS_JOBS_WAITING_IN_CURR_PHASE
,      RUN_ON_NODE
,      LOCKS_OVERRIDDEN_BY
,      TOPDIR
FROM APPLSYS.AD_SESSIONS#;

Dependencies

[top of page]

APPLSYS.AD_SESSIONS# references the following:

SchemaAPPLSYS
TableAD_SESSIONS
APPLSYS.AD_SESSIONS# is referenced by following:

SchemaAPPS
SynonymAD_SESSIONS