XLA_EVENT_TYPES

Details

Schema: FUSION
Object owner: XLA
Object type: VIEW

Columns

Name
row_id APPLICATION_ID ENTITY_CODE EVENT_CLASS_CODE EVENT_TYPE_CODE NAME DESCRIPTION TRANSACTION_REVERSAL_FLAG ACCOUNTING_FLAG TAX_FLAG ENABLED_FLAG CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Name

row_id

APPLICATION_ID

ENTITY_CODE

EVENT_CLASS_CODE

EVENT_TYPE_CODE

NAME

DESCRIPTION

TRANSACTION_REVERSAL_FLAG

ACCOUNTING_FLAG

TAX_FLAG

ENABLED_FLAG

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

Query

SQL_Statement
SELECT b.rowid row_id ,b.application_id ,b.entity_code ,b.event_class_code ,b.event_type_code ,t.name ,t.description,b.transaction_reversal_flag ,b.accounting_flag ,b.tax_flag ,b.enabled_flag ,b.creation_date ,b.created_by ,b.last_update_date ,b.last_updated_by ,b.last_update_login,b.object_version_number FROM xla_event_types_b b ,xla_event_types_tl t WHERE b.application_id = t.application_id AND b.event_type_code = t.event_type_code AND t.language = USERENV('LANG')

SQL_Statement

SELECT b.rowid row_id ,b.application_id ,b.entity_code ,b.event_class_code ,b.event_type_code ,t.name ,t.description,b.transaction_reversal_flag ,b.accounting_flag ,b.tax_flag ,b.enabled_flag ,b.creation_date ,b.created_by ,b.last_update_date ,b.last_updated_by ,b.last_update_login,b.object_version_number FROM xla_event_types_b b ,xla_event_types_tl t WHERE b.application_id = t.application_id AND b.event_type_code = t.event_type_code AND t.language = USERENV('LANG')