MSC_LEVELS_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
LEVEL_ID LEVEL_POS_NUM TYPE_NAME LEVEL_NAME LEVEL_CATEGORY CALENDAR_LEVEL DIMENSION_ID DIMENSION_CODE DIMENSION_NAME DATA_SOURCE_VIEW ODS_COLUMN_NAME PLANNING_COLUMN_NAME MEMBER_IDENTIFIER USER_KEYCOL1_VALUE USER_KEYCOL2_VALUE USER_KEYCOL3_VALUE BUCKET_TYPE CUSTOM CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT LEVEL_ID AS LEVEL_ID , LEVEL_POS_NUM AS LEVEL_POS_NUM , TYPE_NAME AS TYPE_NAME , LEVEL_NAME AS LEVEL_NAME , LEVEL_CATEGORY AS LEVEL_CATEGORY , CALENDAR_LEVEL AS CALENDAR_LEVEL , DIMENSION_ID AS DIMENSION_ID , DIMENSION_CODE AS DIMENSION_CODE , DIMENSION_NAME AS DIMENSION_NAME , DATA_SOURCE_VIEW AS DATA_SOURCE_VIEW , ODS_COLUMN_NAME AS ODS_COLUMN_NAME , PLANNING_COLUMN_NAME AS PLANNING_COLUMN_NAME, MEMBER_IDENTIFIER AS MEMBER_IDENTIFIER , USER_KEYCOL1_VALUE AS USER_KEYCOL1_VALUE , USER_KEYCOL2_VALUE AS USER_KEYCOL2_VALUE , USER_KEYCOL3_VALUE AS USER_KEYCOL3_VALUE , BUCKET_TYPE AS BUCKET_TYPE , CUSTOM AS CUSTOM , CREATED_BY AS CREATED_BY , CREATION_DATE AS CREATION_DATE , LAST_UPDATED_BY AS LAST_UPDATED_BY , LAST_UPDATE_DATE AS LAST_UPDATE_DATE , LAST_UPDATE_LOGIN AS LAST_UPDATE_LOGIN , OBJECT_VERSION_NUMBER AS OBJECT_VERSION_NUMBER FROM ( SELECT ML.LEVEL_ID LEVEL_ID , ML.LEVEL_POS_NUM LEVEL_POS_NUM , FLV.MEANING TYPE_NAME , NVL(MLT.USER_SPECIFIED_NAME, MLT.NAME) LEVEL_NAME , DECODE(ML.CUSTOM,1,'Custom Level',2,'Seeded Level', 3,'Dynamic Level',4,'Fictive Level', ML.CUSTOM) LEVEL_CATEGORY , DECODE(ML.BUCKET_TYPE,1,'Day',2,'Manufacturing Week', 3,'Manufacturing Period',4,'Gregorian Month', 5,'Gregorian Quarter',6,'Gregorian Year', 7,'Fiscal Month',8,'Fiscal Quarter', 9,'Fiscal Year', 10,'Hybrid Time Level',ML.BUCKET_TYPE) CALENDAR_LEVEL, DIM.DIMENSION_ID DIMENSION_ID , DIM.DIMENSION_CODE DIMENSION_CODE , NVL(DIM.USER_SPECIFIED_NAME,DIM.NAME) DIMENSION_NAME , ML.DATA_SOURCE_VIEW DATA_SOURCE_VIEW , ML.ODS_COLUMN_NAME ODS_COLUMN_NAME , DIM.DIMENSION_CODE||'_'||ML.LEVEL_ID||'_ID' PLANNING_COLUMN_NAME, ML.MEMBER_IDENTIFIER MEMBER_IDENTIFIER , ML.USER_KEYCOL1_VALUE USER_KEYCOL1_VALUE , ML.USER_KEYCOL2_VALUE USER_KEYCOL2_VALUE , ML.USER_KEYCOL3_VALUE USER_KEYCOL3_VALUE , ML.BUCKET_TYPE BUCKET_TYPE , ML.CUSTOM CUSTOM , ML.CREATED_BY CREATED_BY , ML.CREATION_DATE CREATION_DATE , ML.LAST_UPDATED_BY LAST_UPDATED_BY , ML.LAST_UPDATE_DATE LAST_UPDATE_DATE , ML.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , ML.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM MSC_DIMENSIONS_VL DIM, FND_LOOKUP_VALUES_VL FLV, MSC_LEVELS_B ML , MSC_LEVELS_TL MLT WHERE ML.DIMENSION_ID = DIM.DIMENSION_ID AND FLV.LOOKUP_TYPE = 'ORA_MSC_LEVEL_TYPE' AND FLV.LOOKUP_CODE = ML.LEVEL_POS_NUM AND ML.LEVEL_ID = MLT.LEVEL_ID AND MLT.LANGUAGE = USERENV('LANG') )