VIEW: APPS.MSD_LEVEL_VALUES_V1

Source

View Text - Preformatted

SELECT mlv.rowid row_id, mlv.instance, mai.instance_code, mlv.level_id, ml.level_name, ml.dimension_code, mlv.level_value, mlv.level_pk, mlv.sr_level_pk, mlv.level_value_desc, mlv.attribute1, mlv.attribute2, mlv.attribute3, mlv.attribute4, mlv.attribute5, mlv.last_update_date, mlv.last_updated_by, mlv.creation_date, mlv.created_by, mlv.last_update_login, mlv.request_id, mlv.program_application_id, mlv.program_id, mlv.program_update_date, mlv.last_refresh_num, mlv.created_by_refresh_num, mlv.dp_enabled_flag from msd_level_values mlv, msd_levels ml, msc_apps_instances mai WHERE ml.level_id = mlv.level_id and mlv.instance = mai.instance_id and ml.plan_type is null

View Text - HTML Formatted

SELECT MLV.ROWID ROW_ID
, MLV.INSTANCE
, MAI.INSTANCE_CODE
, MLV.LEVEL_ID
, ML.LEVEL_NAME
, ML.DIMENSION_CODE
, MLV.LEVEL_VALUE
, MLV.LEVEL_PK
, MLV.SR_LEVEL_PK
, MLV.LEVEL_VALUE_DESC
, MLV.ATTRIBUTE1
, MLV.ATTRIBUTE2
, MLV.ATTRIBUTE3
, MLV.ATTRIBUTE4
, MLV.ATTRIBUTE5
, MLV.LAST_UPDATE_DATE
, MLV.LAST_UPDATED_BY
, MLV.CREATION_DATE
, MLV.CREATED_BY
, MLV.LAST_UPDATE_LOGIN
, MLV.REQUEST_ID
, MLV.PROGRAM_APPLICATION_ID
, MLV.PROGRAM_ID
, MLV.PROGRAM_UPDATE_DATE
, MLV.LAST_REFRESH_NUM
, MLV.CREATED_BY_REFRESH_NUM
, MLV.DP_ENABLED_FLAG
FROM MSD_LEVEL_VALUES MLV
, MSD_LEVELS ML
, MSC_APPS_INSTANCES MAI
WHERE ML.LEVEL_ID = MLV.LEVEL_ID
AND MLV.INSTANCE = MAI.INSTANCE_ID
AND ML.PLAN_TYPE IS NULL