Product: | MSD - Demand Planning |
---|---|
Description: | This view provides the Level Associations within a Hierarchy in the Real Dimension realm. |
Implementation/DBA Data: | APPS.MSD_HIERARCHY_LEVELS_V |
SELECT MHL.ROWID
, MHL.HIERARCHY_ID
, MHV.HIERARCHY_NAME
, MHL.LEVEL_ID
, MLV1.LEVEL_NAME
, MLV1.LEVEL_TYPE_CODE
, MLV1.LEVEL_TYPE
, MHL.PARENT_LEVEL_ID
, MLV2.LEVEL_NAME
, MLV2.LEVEL_TYPE_CODE
, MLV2.LEVEL_TYPE
, MHV.OWNING_DIMENSION_CODE
, MHV.OWNING_DIMENSION
, MHL.RELATIONSHIP_VIEW
, MHL.LEVEL_VALUE_COLUMN
, MHL.LEVEL_VALUE_PK_COLUMN
, MHL.PARENT_VALUE_COLUMN
, MHL.PARENT_VALUE_PK_COLUMN
, MHL.LAST_UPDATE_DATE
, MHL.LAST_UPDATED_BY
, MHL.CREATION_DATE
, MHL.CREATED_BY
, MHL.LAST_UPDATE_LOGIN
, MHL.REQUEST_ID
, MHL.PROGRAM_APPLICATION_ID
, MHL.PROGRAM_ID
, MHL.PROGRAM_UPDATE_DATE
FROM MSD_LEVELS_V MLV1
, MSD_LEVELS_V MLV2
, MSD_HIERARCHIES_V MHV
, MSD_HIERARCHY_LEVELS MHL
WHERE MLV1.LEVEL_ID = MHL.LEVEL_ID
AND MLV2.LEVEL_ID = MHL.PARENT_LEVEL_ID
AND MHV.HIERARCHY_ID = MHL.HIERARCHY_ID