VIEW: APPS.MSD_LEVELS_V

Source

View Text - Preformatted

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, ml.system_attribute1_context, ml.system_attribute2_context 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' and ml.plan_type is null

View Text - HTML Formatted

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
, ML.SYSTEM_ATTRIBUTE1_CONTEXT
, ML.SYSTEM_ATTRIBUTE2_CONTEXT
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'
AND ML.PLAN_TYPE IS NULL