View: XLA_ENTITY_EVENTS_V

Product:	XLA - Subledger Accounting
Description:
Implementation/DBA Data:	APPS.XLA_ENTITY_EVENTS_V

View Text

SELECT EVT.EVENT_ID
, EVT.EVENT_NUMBER
, SOURCE_APPLICATION_ID
, EVT.APPLICATION_ID
, EVT.EVENT_TYPE_CODE
, EVT.EVENT_DATE
, EVT.TRANSACTION_DATE
, EVT.ENTITY_ID
, EVT.EVENT_STATUS_CODE
, EVT.PROCESS_STATUS_CODE
, ENT.TRANSACTION_NUMBER
, ENT.LEDGER_ID
, ENT.LEGAL_ENTITY_ID
, ENT.ENTITY_CODE
, XET.EVENT_CLASS_CODE
, ECA.EVENT_CLASS_GROUP_CODE
, ENT.SOURCE_ID_INT_1
, ENT.SOURCE_ID_CHAR_1
, ENT.SOURCE_ID_INT_2
, ENT.SOURCE_ID_CHAR_2
, ENT.SOURCE_ID_INT_3
, ENT.SOURCE_ID_CHAR_3
, ENT.SOURCE_ID_INT_4
, ENT.SOURCE_ID_CHAR_4
, ENT.SECURITY_ID_INT_1
, ENT.SECURITY_ID_INT_2
, ENT.SECURITY_ID_INT_3
, ENT.SECURITY_ID_CHAR_1
, ENT.SECURITY_ID_CHAR_2
, ENT.SECURITY_ID_CHAR_3
, ENT.VALUATION_METHOD
, EVT.REFERENCE_NUM_4
, EVT.REFERENCE_CHAR_1
, EVT.REFERENCE_CHAR_2
, EVT.REFERENCE_CHAR_3
, EVT.REFERENCE_CHAR_4
, EVT.REFERENCE_DATE_1
, EVT.REFERENCE_DATE_2
, EVT.REFERENCE_DATE_3
, EVT.REFERENCE_DATE_4
, EVT.REFERENCE_NUM_1
, EVT.REFERENCE_NUM_2
, EVT.REFERENCE_NUM_3
, EVT.CREATION_DATE
, EVT.CREATED_BY
, EVT.LAST_UPDATE_DATE
, EVT.LAST_UPDATED_BY
, EVT.LAST_UPDATE_LOGIN
, EVT.PROGRAM_UPDATE_DATE
, EVT.PROGRAM_APPLICATION_ID
, EVT.PROGRAM_ID
, EVT.REQUEST_ID
, EVT.ON_HOLD_FLAG
, EVT.BUDGETARY_CONTROL_FLAG
FROM XLA_EVENTS EVT
, XLA_TRANSACTION_ENTITIES ENT
, XLA_EVENT_TYPES_B XET
, XLA_EVENT_CLASS_ATTRS ECA
WHERE EVT.APPLICATION_ID = ENT.APPLICATION_ID
AND EVT.ENTITY_ID = ENT.ENTITY_ID
AND EVT.APPLICATION_ID = XET.APPLICATION_ID
AND EVT.EVENT_TYPE_CODE = XET.EVENT_TYPE_CODE
AND ECA.APPLICATION_ID = XET.APPLICATION_ID
AND ECA.ENTITY_CODE = XET.ENTITY_CODE
AND ECA.EVENT_CLASS_CODE = XET.EVENT_CLASS_CODE

Columns