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

TABLE: ICX.ICX_SESSIONS

Object Details
Object Name: ICX_SESSIONS
Object Type: TABLE
Owner: ICX
FND Design Data: TableICX.ICX_SESSIONS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ICX_SESSIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSESSION_ID
ICX_SESSIONS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnXSID
ICX_SESSIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUSER_ID
Columns
Name Datatype Length Mandatory Comments
SESSION_ID NUMBER
Yes Identifier for each session created by a user login
WINDOW_ID NUMBER

USER_ID NUMBER
Yes Identifier of the user logged in for this session
MODE_CODE VARCHAR2 (30)
Type code for the session; WEBAPPS for full access and SLAVE for function calling.
HOME_URL VARCHAR2 (240)
Home URL address. If it is not null, it overrides HOME_URL in ICX_PARAMETERS when exit icon clicked
RESPONSIBILITY_APPLICATION_ID NUMBER

RESPONSIBILITY_ID NUMBER

Identifier of current Responsibility
SECURITY_GROUP_ID NUMBER

ORG_ID NUMBER (15)
Identifier of current Organization
MENU_ID NUMBER

Identifier of current Menu
FUNCTION_ID NUMBER

Identifier of current Function
FUNCTION_TYPE VARCHAR2 (30)
NLS_LANGUAGE VARCHAR2 (30)
Language preference
LANGUAGE_CODE VARCHAR2 (30)
DATE_FORMAT_MASK VARCHAR2 (100)
Date format preference
COUNTER NUMBER

How many hits a User has made
FIRST_CONNECT DATE

Date and time of login
LAST_CONNECT DATE

Date and time of last hit
NLS_DATE_LANGUAGE VARCHAR2 (30)
Date Language preference
NLS_NUMERIC_CHARACTERS VARCHAR2 (30)
Numeric Characters preference
NLS_SORT VARCHAR2 (30)
Collating sequence for order by clauses
NLS_TERRITORY VARCHAR2 (30)
LIMIT_TIME NUMBER

Time limit for this session
LIMIT_CONNECTS NUMBER

Number of hits allowed in this session
DISABLED_FLAG VARCHAR2 (1)
Indicates whether this is a valid session
PSEUDO_FLAG VARCHAR2 (1)
Indicates whether this session was created due to an access external to Oracle Applications, for example email.
PAGE_ID NUMBER

CREATED_BY NUMBER
Yes Identifier for each session created by a user login
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
LOGIN_ID NUMBER

FND_LOGINS_S derived. Used for auditing with LAST_UPDATE_LOGIN columns
NODE_ID NUMBER

MAC_KEY RAW (20)
ENC_KEY RAW (32)
XSID VARCHAR2 (32)
TIME_OUT NUMBER

GUEST VARCHAR2 (30)
DISTRIBUTED VARCHAR2 (30)
PROXY_USER_ID NUMBER

Query Text

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


SELECT SESSION_ID
,      WINDOW_ID
,      USER_ID
,      MODE_CODE
,      HOME_URL
,      RESPONSIBILITY_APPLICATION_ID
,      RESPONSIBILITY_ID
,      SECURITY_GROUP_ID
,      ORG_ID
,      MENU_ID
,      FUNCTION_ID
,      FUNCTION_TYPE
,      NLS_LANGUAGE
,      LANGUAGE_CODE
,      DATE_FORMAT_MASK
,      COUNTER
,      FIRST_CONNECT
,      LAST_CONNECT
,      NLS_DATE_LANGUAGE
,      NLS_NUMERIC_CHARACTERS
,      NLS_SORT
,      NLS_TERRITORY
,      LIMIT_TIME
,      LIMIT_CONNECTS
,      DISABLED_FLAG
,      PSEUDO_FLAG
,      PAGE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LOGIN_ID
,      NODE_ID
,      MAC_KEY
,      ENC_KEY
,      XSID
,      TIME_OUT
,      GUEST
,      DISTRIBUTED
,      PROXY_USER_ID
FROM ICX.ICX_SESSIONS;

Dependencies

[top of page]

ICX.ICX_SESSIONS does not reference any database object

ICX.ICX_SESSIONS is referenced by following:

SchemaAPPS
SynonymICX_SESSIONS