View: MSD_LEVEL_VALUES_V

Product:	MSD - Demand Planning
Description:	This view specifies the Level Value Associations for a level with its parent level value in a hierarchy along with the system generated primary keys for these level values. This is not stripped by demand plan Id.
Implementation/DBA Data:	APPS.MSD_LEVEL_VALUES_V

View Text

SELECT MLV1.LEVEL_ID
, MLV1.LEVEL_VALUE
, MLV1.LEVEL_PK
, MLV2.LEVEL_ID
, MLV2.LEVEL_VALUE
, MLV2.LEVEL_PK
, MLV1.ATTRIBUTE1
, MLV1.ATTRIBUTE2
, MLV1.ATTRIBUTE3
, MLV1.ATTRIBUTE4
, MLV1.ATTRIBUTE5
, MLV1.LAST_UPDATE_DATE
, MLV1.LAST_UPDATED_BY
, MLV1.CREATION_DATE
, MLV1.CREATED_BY
, MLV1.LAST_UPDATE_LOGIN
, GREATEST(MLV1.LAST_REFRESH_NUM
, MLA.LAST_REFRESH_NUM)
, GREATEST(MLV1.CREATED_BY_REFRESH_NUM
, MLA.CREATED_BY_REFRESH_NUM)
FROM MSD_LEVEL_VALUES MLV2
, MSD_LEVEL_VALUES MLV1
, MSD_LEVEL_ASSOCIATIONS MLA
WHERE MLV1.LEVEL_ID = MLA.LEVEL_ID
AND MLV1.INSTANCE = MLA.INSTANCE
AND MLV1.SR_LEVEL_PK = MLA.SR_LEVEL_PK
AND MLV2.LEVEL_ID = MLA.PARENT_LEVEL_ID
AND MLV2.INSTANCE = MLA.INSTANCE
AND MLV2.SR_LEVEL_PK = MLA.SR_PARENT_LEVEL_PK

Columns