MSC_MEASURE_CATALOGS_VL

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
CATALOG_ID IS_DEFAULT BY_END_ITEM BY_DEMAND_ORDER_TYPE BY_CUSTOMER BY_DEMAND_WEEK BY_DEMAND_PERIOD TIME_GRANULARITY USE_FOR_ARCHIVAL MAX_ARCHIVE_VERSIONS ROLLING_DATA_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER NAME DESCRIPTION IS_SP_DEF_CATALOG IS_SOP_DEF_CATALOG IS_ISD_DEF_CATALOG IS_DM_DEF_CATALOG IS_RP_DEF_CATALOG

Query

SQL_Statement

SELECT b.CATALOG_ID, b.IS_DEFAULT, b.BY_END_ITEM, b.BY_DEMAND_ORDER_TYPE, b.BY_CUSTOMER, b.BY_DEMAND_WEEK, b.BY_DEMAND_PERIOD, b.TIME_GRANULARITY, b.USE_FOR_ARCHIVAL, b.MAX_ARCHIVE_VERSIONS, b.ROLLING_DATA_FLAG, b.CREATED_BY, b.CREATION_DATE, b.LAST_UPDATED_BY, b.LAST_UPDATE_DATE, b.LAST_UPDATE_LOGIN, b.OBJECT_VERSION_NUMBER, t.NAME, t.DESCRIPTION, b.IS_SP_DEF_CATALOG, b.IS_SOP_DEF_CATALOG, b.IS_ISD_DEF_CATALOG, b.IS_DM_DEF_CATALOG, b.IS_RP_DEF_CATALOG FROM MSC_MEASURE_CATALOGS_B b, MSC_MEASURE_CATALOGS_TL t WHERE b.CATALOG_ID = t.CATALOG_ID AND t.LANGUAGE = USERENV('LANG')