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

VIEW: ICX.ICX_AUDIT#

Object Details
Object Name: ICX_AUDIT#
Object Type: VIEW
Owner: ICX
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
AUDIT_ID NUMBER
Yes
SESSION_ID NUMBER
Yes
WEB_USER_ID NUMBER
Yes
SERVER_NAME VARCHAR2 (80)
SERVER_PORT VARCHAR2 (80)
SCRIPT_NAME VARCHAR2 (80)
PATH_INFO VARCHAR2 (80)
PARAMETER_NAME_1 VARCHAR2 (80)
PARAMETER_1 VARCHAR2 (80)
PARAMETER_NAME_2 VARCHAR2 (80)
PARAMETER_2 VARCHAR2 (80)
PARAMETER_NAME_3 VARCHAR2 (80)
PARAMETER_3 VARCHAR2 (80)
PARAMETER_NAME_4 VARCHAR2 (80)
PARAMETER_4 VARCHAR2 (80)
PARAMETER_NAME_5 VARCHAR2 (80)
PARAMETER_5 VARCHAR2 (80)
PARAMETER_NAME_6 VARCHAR2 (80)
PARAMETER_6 VARCHAR2 (80)
PARAMETER_NAME_7 VARCHAR2 (80)
PARAMETER_7 VARCHAR2 (80)
PARAMETER_NAME_8 VARCHAR2 (80)
PARAMETER_8 VARCHAR2 (80)
PARAMETER_NAME_9 VARCHAR2 (80)
PARAMETER_9 VARCHAR2 (80)
CONNECT_DATE DATE
Yes
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

Query Text

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


SELECT AUDIT_ID
,      SESSION_ID
,      WEB_USER_ID
,      SERVER_NAME
,      SERVER_PORT
,      SCRIPT_NAME
,      PATH_INFO
,      PARAMETER_NAME_1
,      PARAMETER_1
,      PARAMETER_NAME_2
,      PARAMETER_2
,      PARAMETER_NAME_3
,      PARAMETER_3
,      PARAMETER_NAME_4
,      PARAMETER_4
,      PARAMETER_NAME_5
,      PARAMETER_5
,      PARAMETER_NAME_6
,      PARAMETER_6
,      PARAMETER_NAME_7
,      PARAMETER_7
,      PARAMETER_NAME_8
,      PARAMETER_8
,      PARAMETER_NAME_9
,      PARAMETER_9
,      CONNECT_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM ICX.ICX_AUDIT#;

Dependencies

[top of page]

ICX.ICX_AUDIT# references the following:

SchemaICX
TableICX_AUDIT
ICX.ICX_AUDIT# is referenced by following:

SchemaAPPS
SynonymICX_AUDIT