eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: MSD_LEVEL_VALUES_V1

Product:	MSD - Demand Planning
Description:	This view specifies the Level Values along with the system generated primary keys for these level values. This view is used only for the Level Values form.
Implementation/DBA Data:	APPS.MSD_LEVEL_VALUES_V1

View Text

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.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
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

Columns

Name
ROW_ID
INSTANCE
INSTANCE_CODE
LEVEL_ID
LEVEL_NAME
DIMENSION_CODE
LEVEL_VALUE
LEVEL_PK
SR_LEVEL_PK
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
LAST_REFRESH_NUM
CREATED_BY_REFRESH_NUM