XLA_POST_ACCTG_EVENTS_V

Details

• Schema: FUSION

• Object owner: XLA

• Object type: VIEW

Columns

Name

ENTITY_ID APPLICATION_ID LEDGER_ID LEGAL_ENTITY_ID ENTITY_CODE TRANSACTION_NUMBER SOURCE_ID_INT_1 SOURCE_ID_INT_2 SOURCE_ID_INT_3 SOURCE_ID_INT_4 SOURCE_ID_CHAR_1 SOURCE_ID_CHAR_2 SOURCE_ID_CHAR_3 SOURCE_ID_CHAR_4 EVENT_ID EVENT_CLASS_CODE EVENT_TYPE_CODE EVENT_NUMBER EVENT_DATE EVENT_STATUS_CODE PROCESS_STATUS_CODE EVENT_CREATED_BY 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

Query

SQL_Statement

SELECT gt.entity_id ,gt.application_id ,gt.ledger_id ,gt.legal_entity_id ,gt.entity_code , gt.transaction_number ,gt.source_id_int_1 ,gt.source_id_int_2 ,gt.source_id_int_3 , gt.source_id_int_4 ,gt.source_id_char_1 ,gt.source_id_char_2 ,gt.source_id_char_3 , gt.source_id_char_4 ,gt.event_id ,gt.event_class_code ,gt.event_type_code ,gt.event_number , gt.event_date ,evt.event_status_code , evt.process_status_code , gt.event_created_by, gt.reference_num_1 ,gt.reference_num_2 ,gt.reference_num_3 ,gt.reference_num_4 , gt.reference_char_1 ,gt.reference_char_2 ,gt.reference_char_3 ,gt.reference_char_4 , gt.reference_date_1 ,gt.reference_date_2 ,gt.reference_date_3 ,gt.reference_date_4 FROM xla_events_gt gt, xla_events evt WHERE gt.application_id = evt.application_id AND gt.event_id = evt.event_id AND evt.process_status_code IN ('D','P')