View: MSD_DP_DIMENSIONS_V

Product:	MSD - Demand Planning
Description:	This view stores the associations between the Demand Plans User Defined Dimensions and the Real Dimensions.
Implementation/DBA Data:	APPS.MSD_DP_DIMENSIONS_V

View Text

SELECT MDD.ROWID
, MDD.DEMAND_PLAN_ID
, MDP.DEMAND_PLAN_NAME
, MDD.DP_DIMENSION_CODE
, FLV1.MEANING
, MDD.DIMENSION_CODE
, FLV2.MEANING
, MDD.LAST_UPDATE_DATE
, MDD.LAST_UPDATED_BY
, MDD.CREATION_DATE
, MDD.CREATED_BY
, MDD.LAST_UPDATE_LOGIN
, MDD.REQUEST_ID
, MDD.PROGRAM_APPLICATION_ID
, MDD.PROGRAM_ID
, MDD.PROGRAM_UPDATE_DATE
FROM FND_LOOKUP_VALUES_VL FLV1
, FND_LOOKUP_VALUES_VL FLV2
, MSD_DEMAND_PLANS MDP
, MSD_DP_DIMENSIONS MDD
WHERE FLV1.LOOKUP_CODE = MDD.DP_DIMENSION_CODE
AND FLV1.LOOKUP_TYPE = 'MSD_USER_DIMENSIONS'
AND FLV2.LOOKUP_CODE = MDD.DIMENSION_CODE
AND FLV2.LOOKUP_TYPE = 'MSD_DIMENSIONS'
AND MDP.DEMAND_PLAN_ID = MDD.DEMAND_PLAN_ID

Columns