Product: | MSD - Demand Planning |
---|---|
Description: | This view provides the Levels, their Owning Dimension. It also specifies the Level Type. |
Implementation/DBA Data: | APPS.MSD_LEVELS_V |
SELECT ML.ROWID
, ML.LEVEL_ID
, ML.LEVEL_NAME
, ML.DESCRIPTION
, ML.DIMENSION_CODE
, FLV1.MEANING
, ML.LEVEL_TYPE_CODE
, FLV2.MEANING
, ML.ATTRIBUTE1_CONTEXT
, ML.ATTRIBUTE2_CONTEXT
, ML.ATTRIBUTE3_CONTEXT
, ML.ATTRIBUTE4_CONTEXT
, ML.ATTRIBUTE5_CONTEXT
, ML.LAST_UPDATE_DATE
, ML.LAST_UPDATED_BY
, ML.CREATION_DATE
, ML.CREATED_BY
, ML.LAST_UPDATE_LOGIN
, ML.REQUEST_ID
, ML.PROGRAM_APPLICATION_ID
, ML.PROGRAM_ID
, ML.PROGRAM_UPDATE_DATE
, ML.ATTRIBUTE_CATEGORY
, ML.ATTRIBUTE1
, ML.ATTRIBUTE2
, ML.ATTRIBUTE3
, ML.ATTRIBUTE4
, ML.ATTRIBUTE5
, ML.ATTRIBUTE6
, ML.ATTRIBUTE7
, ML.ATTRIBUTE8
, ML.ATTRIBUTE9
, ML.ATTRIBUTE10
, ML.ATTRIBUTE11
, ML.ATTRIBUTE12
, ML.ATTRIBUTE13
, ML.ATTRIBUTE14
, ML.ATTRIBUTE15
FROM FND_LOOKUP_VALUES_VL FLV1
, FND_LOOKUP_VALUES_VL FLV2
, MSD_LEVELS ML
WHERE FLV1.LOOKUP_CODE = ML.DIMENSION_CODE
AND FLV1.LOOKUP_TYPE = 'MSD_DIMENSIONS'
AND FLV2.LOOKUP_CODE = ML.LEVEL_TYPE_CODE
AND FLV2.LOOKUP_TYPE = 'MSD_LEVEL_TYPE'