eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: MSD_DP_HIERS_HLP_V

Product:	MSD - Demand Planning
Description:	This view associates the demand plan to its dimensions. This is used for Demand Plan forms. The usage of this view for anyother purpose is discouraged.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT DISTINCT DPD.DEMAND_PLAN_ID
, MDP.DEMAND_PLAN_NAME
, DPD.DP_DIMENSION_CODE
, MSL.MEANING DP_DIMENSION_NAME
FROM MSD_DP_DIMENSIONS DPD
, MSD_DEMAND_PLANS MDP
, FND_LOOKUP_VALUES_VL MSL
WHERE (DPD.DEMAND_PLAN_ID=MDP.DEMAND_PLAN_ID)
AND (DPD.DP_DIMENSION_CODE=MSL.LOOKUP_CODE)
AND (MSL.LOOKUP_TYPE='MSD_USER_DIMENSIONS')

Columns

Name
DEMAND_PLAN_ID
DEMAND_PLAN_NAME
DP_DIMENSION_CODE
DP_DIMENSION_NAME