VIEW: APPS.XLA_ENTITY_EVENTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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