View: MSD_LEVEL_ASSOCIATIONS_V1

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 view is used only for the Level Associations form.
Implementation/DBA Data:	APPS.MSD_LEVEL_ASSOCIATIONS_V1

View Text

SELECT MLA.ROWID ROW_ID
, MLA.INSTANCE
, MAI.INSTANCE_CODE
, MLA.LEVEL_ID
, ML1.LEVEL_NAME
, ML1.DIMENSION_CODE
, MLV1.LEVEL_VALUE
, MLV1.LEVEL_PK
, MLA.SR_LEVEL_PK
, MLA.PARENT_LEVEL_ID
, ML2.LEVEL_NAME "PARENT_LEVEL_NAME"
, MLV2.LEVEL_VALUE "PARENT_LEVEL_VALUE"
, MLA.SR_PARENT_LEVEL_PK
, MLA.LAST_UPDATE_DATE
, MLA.LAST_UPDATED_BY
, MLA.CREATION_DATE
, MLA.CREATED_BY
, MLA.LAST_UPDATE_LOGIN
, MLA.REQUEST_ID
, MLA.PROGRAM_APPLICATION_ID
, MLA.PROGRAM_ID
, MLA.PROGRAM_UPDATE_DATE
, MLA.LAST_REFRESH_NUM
, MLA.CREATED_BY_REFRESH_NUM
FROM MSD_LEVEL_VALUES MLV1
, MSD_LEVEL_VALUES MLV2
, MSD_LEVELS ML1
, MSD_LEVELS ML2
, MSD_LEVEL_ASSOCIATIONS MLA
, MSC_APPS_INSTANCES MAI
WHERE ML1.LEVEL_ID = MLA.LEVEL_ID
AND MLV1.LEVEL_ID = MLA.LEVEL_ID
AND MLV1.INSTANCE = MLA.INSTANCE
AND MLV1.SR_LEVEL_PK = MLA.SR_LEVEL_PK
AND ML1.LEVEL_ID = MLV1.LEVEL_ID
AND ML2.LEVEL_ID = MLV2.LEVEL_ID
AND MLV2.LEVEL_ID = MLA.PARENT_LEVEL_ID
AND MLV2.INSTANCE = MLA.INSTANCE
AND MLV2.SR_LEVEL_PK = MLA.SR_PARENT_LEVEL_PK
AND ML2.LEVEL_ID = MLA.PARENT_LEVEL_ID
AND MLA.INSTANCE = MAI.INSTANCE_ID

Columns