XLA_FORMULAS_VL

Details

• Schema: FUSION

• Object owner: XLA

• Object type: VIEW

Columns

Name
FORMULA_ID APPLICATION_ID FORMULA_CODE FORMULA_ORIGIN_CODE ENTITY_CODE EVENT_CLASS_CODE NAME DESCRIPTION ENABLED_FLAG DATATYPE_CODE FORMULA_LEVEL_CODE VLIDATION_STATUS_CODE HIDE_RULES_CODE CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT b.FORMULA_ID formula_id, b.APPLICATION_ID application_id, b.FORMULA_CODE formula_code, b.FORMULA_ORIGIN_CODE formula_origin_code, b.ENTITY_CODE entity_code, b.EVENT_CLASS_CODE event_class_code, t.NAME name, t.DESCRIPTION description, b.ENABLED_FLAG enabled_flag, b.DATATYPE_CODE datatype_code, b.FORMULA_LEVEL_CODE formula_level_code, b.VALIDATION_STATUS_CODE vlidation_status_code, b.HIDE_RULES_CODE hide_rules_code, b.CREATION_DATE creation_date, b.CREATED_BY created_by, b.LAST_UPDATE_DATE last_update_date, b.LAST_UPDATED_BY last_updated_by, b.LAST_UPDATE_LOGIN last_update_login, b.OBJECT_VERSION_NUMBER object_version_number FROM XLA_FORMULAS_TL t, XLA_FORMULAS_B b WHERE b.FORMULA_ID = t.FORMULA_ID AND t.LANGUAGE = USERENV('LANG')