VIEW: MSD.MSD_LEVEL_VALUES#

Source

View Text - Preformatted

select INSTANCE INSTANCE, LEVEL_ID LEVEL_ID, LEVEL_VALUE LEVEL_VALUE, LEVEL_VALUE_PK LEVEL_VALUE_PK, PARENT_LEVEL_ID PARENT_LEVEL_ID, PARENT_LEVEL_VALUE PARENT_LEVEL_VALUE, PARENT_LEVEL_VALUE_PK PARENT_LEVEL_VALUE_PK, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, SR_LEVEL_PK SR_LEVEL_PK, LEVEL_PK LEVEL_PK, LAST_REFRESH_NUM LAST_REFRESH_NUM, CREATED_BY_REFRESH_NUM CREATED_BY_REFRESH_NUM, ACTION_CODE ACTION_CODE, LEVEL_VALUE_DESC LEVEL_VALUE_DESC, SYSTEM_ATTRIBUTE1 SYSTEM_ATTRIBUTE1, SYSTEM_ATTRIBUTE2 SYSTEM_ATTRIBUTE2, DP_ENABLED_FLAG DP_ENABLED_FLAG from "MSD"."MSD_LEVEL_VALUES"

View Text - HTML Formatted

SELECT INSTANCE INSTANCE
, LEVEL_ID LEVEL_ID
, LEVEL_VALUE LEVEL_VALUE
, LEVEL_VALUE_PK LEVEL_VALUE_PK
, PARENT_LEVEL_ID PARENT_LEVEL_ID
, PARENT_LEVEL_VALUE PARENT_LEVEL_VALUE
, PARENT_LEVEL_VALUE_PK PARENT_LEVEL_VALUE_PK
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SR_LEVEL_PK SR_LEVEL_PK
, LEVEL_PK LEVEL_PK
, LAST_REFRESH_NUM LAST_REFRESH_NUM
, CREATED_BY_REFRESH_NUM CREATED_BY_REFRESH_NUM
, ACTION_CODE ACTION_CODE
, LEVEL_VALUE_DESC LEVEL_VALUE_DESC
, SYSTEM_ATTRIBUTE1 SYSTEM_ATTRIBUTE1
, SYSTEM_ATTRIBUTE2 SYSTEM_ATTRIBUTE2
, DP_ENABLED_FLAG DP_ENABLED_FLAG
FROM "MSD"."MSD_LEVEL_VALUES"