ACA_REPORT_PARAMETER_VL

Details

• Schema: FUSION

• Object owner: ACA

• Object type: VIEW

Columns

Name
PARAMETER_ID OBJECT_VERSION_NUMBER REPORT_PATH_ID PARAMETER_SCOPE PARAMETER_CODE PARAMETER_OPERATOR FOLDER_NAME MAPPED_COLUMN_NAME DESCRIPTION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN PARAM_TYPE PARAM1 PARAM2 PARAM3 PARAM4 PARAM5

Query

SQL_Statement

SELECT B.PARAMETER_ID PARAMETER_ID, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.REPORT_PATH_ID REPORT_PATH_ID, B.PARAMETER_SCOPE PARAMETER_SCOPE, B.PARAMETER_CODE PARAMETER_CODE, B.PARAMETER_OPERATOR PARAMETER_OPERATOR, TL.FOLDER_NAME FOLDER_NAME, TL.MAPPED_COLUMN_NAME MAPPED_COLUMN_NAME, TL.DESCRIPTION DESCRIPTION, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.PARAM_TYPE PARAM_TYPE, B.PARAM1 PARAM1, B.PARAM2 PARAM2, B.PARAM3 PARAM3, B.PARAM4 PARAM4, B.PARAM5 PARAM5 FROM ACA_REPORT_PARAMETER_B B, ACA_REPORT_PARAMETER_TL TL WHERE B.PARAMETER_ID = TL.PARAMETER_ID AND TL.LANGUAGE = USERENV('LANG')