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

VIEW: APPS.XLA_ENTITY_EVENTS_V

Object Details
Object Name: XLA_ENTITY_EVENTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXLA.XLA_ENTITY_EVENTS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
EVENT_ID NUMBER (15) Yes Event id
EVENT_NUMBER NUMBER (38) Yes Event number
SOURCE_APPLICATION_ID NUMBER (15) Yes Source application identifier
APPLICATION_ID NUMBER (15) Yes Internal id of the application
EVENT_TYPE_CODE VARCHAR2 (30) Yes Event type code
EVENT_DATE DATE
Yes Event date
TRANSACTION_DATE DATE
Yes
ENTITY_ID NUMBER (15) Yes Internal identified of the entity
EVENT_STATUS_CODE VARCHAR2 (1) Yes Event status code
PROCESS_STATUS_CODE VARCHAR2 (1) Yes Processing status code
TRANSACTION_NUMBER VARCHAR2 (240)
Transaction id
LEDGER_ID NUMBER (15) Yes Internal Identifier for the Ledger.
LEGAL_ENTITY_ID NUMBER (15)
Legal entity id
ENTITY_CODE VARCHAR2 (30) Yes Entity code
EVENT_CLASS_CODE VARCHAR2 (30) Yes Event class code
EVENT_CLASS_GROUP_CODE VARCHAR2 (30) Yes
SOURCE_ID_INT_1 NUMBER (38)
Flexible source id (Integer)
SOURCE_ID_CHAR_1 VARCHAR2 (30)
Flexible source id (Char)
SOURCE_ID_INT_2 NUMBER (38)
Flexible source id (Integer)
SOURCE_ID_CHAR_2 VARCHAR2 (30)
Flexible source id (Char)
SOURCE_ID_INT_3 NUMBER (38)
Flexible source id (Integer)
SOURCE_ID_CHAR_3 VARCHAR2 (30)
Flexible source id (Char)
SOURCE_ID_INT_4 NUMBER (38)
Flexible source id (Integer)
SOURCE_ID_CHAR_4 VARCHAR2 (30)
Flexible source id (Char)
SECURITY_ID_INT_1 NUMBER (38)
Flexible security id (Integer)
SECURITY_ID_INT_2 NUMBER (38)
Flexible security id (Integer)
SECURITY_ID_INT_3 NUMBER (38)
Flexible security id (Integer)
SECURITY_ID_CHAR_1 VARCHAR2 (30)
Flexible security id (Char)
SECURITY_ID_CHAR_2 VARCHAR2 (30)
Flexible security id (Char)
SECURITY_ID_CHAR_3 VARCHAR2 (30)
Flexible security id (Char)
VALUATION_METHOD VARCHAR2 (30)
Valuation Method
REFERENCE_NUM_4 NUMBER

Additional reference (number)
REFERENCE_CHAR_1 VARCHAR2 (240)
Additional reference (char)
REFERENCE_CHAR_2 VARCHAR2 (240)
Additional reference (char)
REFERENCE_CHAR_3 VARCHAR2 (240)
Additional reference (char)
REFERENCE_CHAR_4 VARCHAR2 (240)
Additional reference (char)
REFERENCE_DATE_1 DATE

Additional reference (date)
REFERENCE_DATE_2 DATE

Additional reference (date)
REFERENCE_DATE_3 DATE

Additional reference (date)
REFERENCE_DATE_4 DATE

Additional reference (date)
REFERENCE_NUM_1 NUMBER

Additional reference (number)
REFERENCE_NUM_2 NUMBER

Additional reference (number)
REFERENCE_NUM_3 NUMBER

Additional reference (number)
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
ON_HOLD_FLAG VARCHAR2 (1) Yes
BUDGETARY_CONTROL_FLAG VARCHAR2 (1)
Query Text

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


SELECT EVENT_ID
,      EVENT_NUMBER
,      SOURCE_APPLICATION_ID
,      APPLICATION_ID
,      EVENT_TYPE_CODE
,      EVENT_DATE
,      TRANSACTION_DATE
,      ENTITY_ID
,      EVENT_STATUS_CODE
,      PROCESS_STATUS_CODE
,      TRANSACTION_NUMBER
,      LEDGER_ID
,      LEGAL_ENTITY_ID
,      ENTITY_CODE
,      EVENT_CLASS_CODE
,      EVENT_CLASS_GROUP_CODE
,      SOURCE_ID_INT_1
,      SOURCE_ID_CHAR_1
,      SOURCE_ID_INT_2
,      SOURCE_ID_CHAR_2
,      SOURCE_ID_INT_3
,      SOURCE_ID_CHAR_3
,      SOURCE_ID_INT_4
,      SOURCE_ID_CHAR_4
,      SECURITY_ID_INT_1
,      SECURITY_ID_INT_2
,      SECURITY_ID_INT_3
,      SECURITY_ID_CHAR_1
,      SECURITY_ID_CHAR_2
,      SECURITY_ID_CHAR_3
,      VALUATION_METHOD
,      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
,      REFERENCE_NUM_1
,      REFERENCE_NUM_2
,      REFERENCE_NUM_3
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      REQUEST_ID
,      ON_HOLD_FLAG
,      BUDGETARY_CONTROL_FLAG
FROM APPS.XLA_ENTITY_EVENTS_V;

Dependencies

[top of page]

APPS.XLA_ENTITY_EVENTS_V references the following:

SchemaAPPS
SynonymXLA_EVENTS
SynonymXLA_EVENT_CLASS_ATTRS
SynonymXLA_EVENT_TYPES_B
SynonymXLA_TRANSACTION_ENTITIES
APPS.XLA_ENTITY_EVENTS_V is referenced by following:

SchemaAPPS
Package BodyARP_XLA_EXTRACT_MAIN_PKG - show dependent code
Package BodyCE_XLA_ACCT_EVENTS_PKG - show dependent code
Package BodyPA_XLA_SWEEP_TXN_PKG - show dependent code
Package BodyPSA_BC_XLA_PVT - show dependent code
Package BodyXLA_ACCOUNTING_PKG - show dependent code