XLA_DESCRIPTIONS_VL

Details

• Schema: FUSION

• Object owner: XLA

• Object type: VIEW

Columns

Name
ROW_ID AMB_CONTEXT_CODE ENABLED_FLAG CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER APPLICATION_ID DESCRIPTION_TYPE_CODE DESCRIPTION_CODE TRANSACTION_COA_ID NAME DESCRIPTION DESCRIPTION_RULE_ID

Query

SQL_Statement

SELECT b.rowid row_id, b.amb_context_code, 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, b.application_id, b.description_type_code, b.description_code, b.transaction_coa_id, t.name, t.description, b.description_rule_id FROM xla_descriptions_tl t, xla_descriptions_b b WHERE b.application_id = t.application_id AND b.amb_context_code = t.amb_context_code AND b.description_type_code = t.description_type_code AND b.description_code = t.description_code AND t.language = USERENV('LANG')