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


VIEW: XLA.XLA_EVENTS#

Object Details
Object Name: XLA_EVENTS#
Object Type: VIEW
Owner: XLA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
EVENT_ID NUMBER (15) Yes
APPLICATION_ID NUMBER (15) Yes
EVENT_TYPE_CODE VARCHAR2 (30) Yes
EVENT_DATE DATE
Yes
ENTITY_ID NUMBER (15) Yes
EVENT_STATUS_CODE VARCHAR2 (1) Yes
PROCESS_STATUS_CODE VARCHAR2 (1) Yes
REFERENCE_NUM_1 NUMBER

REFERENCE_NUM_2 NUMBER

REFERENCE_NUM_3 NUMBER

REFERENCE_NUM_4 NUMBER

REFERENCE_CHAR_1 VARCHAR2 (240)
REFERENCE_CHAR_2 VARCHAR2 (240)
REFERENCE_CHAR_3 VARCHAR2 (240)
REFERENCE_CHAR_4 VARCHAR2 (240)
REFERENCE_DATE_1 DATE

REFERENCE_DATE_2 DATE

REFERENCE_DATE_3 DATE

REFERENCE_DATE_4 DATE

EVENT_NUMBER NUMBER (38) Yes
ON_HOLD_FLAG VARCHAR2 (1) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
PROGRAM_UPDATE_DATE DATE

PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
REQUEST_ID NUMBER (15)
UPG_BATCH_ID NUMBER (15)
UPG_SOURCE_APPLICATION_ID NUMBER (15)
UPG_VALID_FLAG VARCHAR2 (1)
TRANSACTION_DATE DATE
Yes
BUDGETARY_CONTROL_FLAG VARCHAR2 (1)
MERGE_EVENT_SET_ID NUMBER (15)
Query Text

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


SELECT EVENT_ID
,      APPLICATION_ID
,      EVENT_TYPE_CODE
,      EVENT_DATE
,      ENTITY_ID
,      EVENT_STATUS_CODE
,      PROCESS_STATUS_CODE
,      REFERENCE_NUM_1
,      REFERENCE_NUM_2
,      REFERENCE_NUM_3
,      REFERENCE_NUM_4
,      REFERENCE_CHAR_1
,      REFERENCE_CHAR_2
,      REFERENCE_CHAR_3
,      REFERENCE_CHAR_4
,      REFERENCE_DATE_1
,      REFERENCE_DATE_2
,      REFERENCE_DATE_3
,      REFERENCE_DATE_4
,      EVENT_NUMBER
,      ON_HOLD_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      REQUEST_ID
,      UPG_BATCH_ID
,      UPG_SOURCE_APPLICATION_ID
,      UPG_VALID_FLAG
,      TRANSACTION_DATE
,      BUDGETARY_CONTROL_FLAG
,      MERGE_EVENT_SET_ID
FROM XLA.XLA_EVENTS#;

Dependencies

[top of page]

XLA.XLA_EVENTS# references the following:

SchemaXLA
TableXLA_EVENTS
XLA.XLA_EVENTS# is referenced by following:

SchemaAPPS
SynonymXLA_EVENTS