ZCA_ROLLUPS_VL

Details

• Schema: FUSION

• Object owner: ZCA

• Object type: VIEW

Columns

Name

ROLLUP_ID NAME DESCRIPTION ROLLUP_TYPE_CODE SOURCE_OBJ_CODE SOURCE_STORAGE_OBJ_CODE SOURCE_OBJ_ROLLUP_TABLE SOURCE_OBJ_ATTR SOURCE_OBJ_ATTR_TYPE SOURCE_OBJ_FILTER RELATED_OBJ_CODE RELATIONSHIP_NAME_LIC RELATED_OBJ_ATTR RELATED_OBJ_FILTER FUNCTION_CODE REFRESH_THRESHOLD HIERARCHY_FLAG HIERARCHY_ATTR STATUS_FLAG FREQUENCY FREQUENCY_UNIT_CODE COMPILED_SOURCE_AMT_CONV COMPILED_FULL_SQL COMPILED_INCREMENTAL_SQL COMPILED_OBJ_LIST_SQL PUBLISHED_FLAG PUBLISHED_DATE PUBLISHED_BY LAST_SUCCESSFUL_RUN LAST_PROCESSED_DATE LAST_PROCESSED_STATUS_CODE ERROR_MESSAGE OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN NRT_FLAG BOFO_LINKSET_REFRESH_SQL EXPLAINABILITY_METADATA

Query

SQL_Statement

SELECT B.ROLLUP_ID, T.NAME, T.DESCRIPTION, B.ROLLUP_TYPE_CODE, B.SOURCE_OBJ_CODE, B.SOURCE_STORAGE_OBJ_CODE, B.SOURCE_OBJ_ROLLUP_TABLE, B.SOURCE_OBJ_ATTR, B.SOURCE_OBJ_ATTR_TYPE, B.SOURCE_OBJ_FILTER, B.RELATED_OBJ_CODE, B.RELATIONSHIP_NAME_LIC, B.RELATED_OBJ_ATTR, B.RELATED_OBJ_FILTER, B.FUNCTION_CODE, B.REFRESH_THRESHOLD, B.HIERARCHY_FLAG, B.HIERARCHY_ATTR, B.STATUS_FLAG, B.FREQUENCY, B.FREQUENCY_UNIT_CODE, B.COMPILED_SOURCE_AMT_CONV, B.COMPILED_FULL_SQL, B.COMPILED_INCREMENTAL_SQL, B.COMPILED_OBJ_LIST_SQL, B.PUBLISHED_FLAG, B.PUBLISHED_DATE, B.PUBLISHED_BY, B.LAST_SUCCESSFUL_RUN, B.LAST_PROCESSED_DATE, B.LAST_PROCESSED_STATUS_CODE, B.ERROR_MESSAGE, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.NRT_FLAG, B.BOFO_LINKSET_REFRESH_SQL, B.EXPLAINABILITY_METADATA FROM ZCA_ROLLUPS_B B, ZCA_ROLLUPS_TL T WHERE B.ROLLUP_ID = T.ROLLUP_ID AND T.LANGUAGE = USERENV('LANG')