XLA_FORMULA_FUNCTIONS_VL

Details

• Schema: FUSION

• Object owner: XLA

• Object type: VIEW

Columns

Name

FUNCTION_ID FUNCTION_CODE FUNCTION_DATATYPE_CODE RETURN_DATATYPE_CODE ENABLED_FLAG PARAM_COUNT PARAM1_DATATYPE_CODE PARAM2_DATATYPE_CODE PARAM3_DATATYPE_CODE PARAM4_DATATYPE_CODE PARAM5_DATATYPE_CODE PARAM6_DATATYPE_CODE PARAM7_DATATYPE_CODE PARAM8_DATATYPE_CODE PARAM9_DATATYPE_CODE PARAM10_DATATYPE_CODE CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY LANGUAGE SOURCE_LANG NAME DESCRIPTION PARAM1_NAME PARAM2_NAME PARAM3_NAME PARAM4_NAME PARAM5_NAME PARAM6_NAME PARAM7_NAME PARAM8_NAME PARAM9_NAME PARAM10_NAME OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT b.FUNCTION_ID, b.FUNCTION_CODE, b.FUNCTION_DATATYPE_CODE, b.RETURN_DATATYPE_CODE, b.ENABLED_FLAG, b.PARAM_COUNT, b.PARAM1_DATATYPE_CODE, b.PARAM2_DATATYPE_CODE, b.PARAM3_DATATYPE_CODE, b.PARAM4_DATATYPE_CODE, b.PARAM5_DATATYPE_CODE, b.PARAM6_DATATYPE_CODE, b.PARAM7_DATATYPE_CODE, b.PARAM8_DATATYPE_CODE, b.PARAM9_DATATYPE_CODE, b.PARAM10_DATATYPE_CODE, b.CREATION_DATE, b.CREATED_BY, b.LAST_UPDATE_DATE, b.LAST_UPDATE_LOGIN, b.LAST_UPDATED_BY, t.LANGUAGE, t.SOURCE_LANG, t.NAME, t.DESCRIPTION, t.PARAM1_NAME, t.PARAM2_NAME, t.PARAM3_NAME, t.PARAM4_NAME, t.PARAM5_NAME, t.PARAM6_NAME, t.PARAM7_NAME, t.PARAM8_NAME, t.PARAM9_NAME, t.PARAM10_NAME, b.OBJECT_VERSION_NUMBER FROM XLA_FORMULA_FUNCTIONS_TL t, XLA_FORMULA_FUNCTIONS_B b WHERE b.FUNCTION_ID = t.FUNCTION_ID AND t.LANGUAGE = USERENV('LANG')