Product: | MSD - Demand Planning |
---|---|
Description: | This view provides the Hierachies, their corresponding State (Valid or Not) and the Dimension to which it belongs. |
Implementation/DBA Data: | APPS.MSD_HIERARCHIES_V |
SELECT MH.ROWID
, MH.HIERARCHY_ID
, MH.HIERARCHY_NAME
, MH.DESCRIPTION
, MH.DIMENSION_CODE
, FLV.MEANING
, MH.VALID_FLAG
, ML.MEANING
, MH.LAST_UPDATE_DATE
, MH.LAST_UPDATED_BY
, MH.CREATION_DATE
, MH.CREATED_BY
, MH.LAST_UPDATE_LOGIN
, MH.REQUEST_ID
, MH.PROGRAM_APPLICATION_ID
, MH.PROGRAM_ID
, MH.PROGRAM_UPDATE_DATE
, MH.ATTRIBUTE_CATEGORY
, MH.ATTRIBUTE1
, MH.ATTRIBUTE2
, MH.ATTRIBUTE3
, MH.ATTRIBUTE4
, MH.ATTRIBUTE5
, MH.ATTRIBUTE6
, MH.ATTRIBUTE7
, MH.ATTRIBUTE8
, MH.ATTRIBUTE9
, MH.ATTRIBUTE10
, MH.ATTRIBUTE11
, MH.ATTRIBUTE12
, MH.ATTRIBUTE13
, MH.ATTRIBUTE14
, MH.ATTRIBUTE15
FROM FND_LOOKUP_VALUES_VL FLV
, MFG_LOOKUPS ML
, MSD_HIERARCHIES MH
WHERE FLV.LOOKUP_CODE = MH.DIMENSION_CODE
AND FLV.LOOKUP_TYPE = 'MSD_DIMENSIONS'
AND ML.LOOKUP_CODE = MH.VALID_FLAG
AND ML.LOOKUP_TYPE = 'SYS_YES_NO'