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_HIERARCHIES_V

Product:	MSD - Demand Planning
Description:	This view stores the Demand Plan Hierarchies Association.
Implementation/DBA Data:	APPS.MSD_DP_HIERARCHIES_V

View Text

SELECT MDH.ROWID
, MDH.DEMAND_PLAN_ID
, MDP.DEMAND_PLAN_NAME
, MDH.DP_DIMENSION_CODE
, FLV1.MEANING
, MDH.HIERARCHY_ID
, MHV.HIERARCHY_NAME
, MHV.DESCRIPTION
, MHV.OWNING_DIMENSION_CODE
, MHV.OWNING_DIMENSION
, MDH.LAST_UPDATE_DATE
, MDH.LAST_UPDATED_BY
, MDH.CREATION_DATE
, MDH.CREATED_BY
, MDH.LAST_UPDATE_LOGIN
, MDH.REQUEST_ID
, MDH.PROGRAM_APPLICATION_ID
, MDH.PROGRAM_ID
, MDH.PROGRAM_UPDATE_DATE
FROM FND_LOOKUP_VALUES_VL FLV1
, MSD_DEMAND_PLANS MDP
, MSD_HIERARCHIES_V MHV
, MSD_DP_HIERARCHIES MDH
WHERE FLV1.LOOKUP_CODE = MDH.DP_DIMENSION_CODE
AND FLV1.LOOKUP_TYPE = 'MSD_USER_DIMENSIONS'
AND MHV.HIERARCHY_ID = MDH.HIERARCHY_ID
AND MDP.DEMAND_PLAN_ID = MDH.DEMAND_PLAN_ID

Columns

Name
ROW_ID
DEMAND_PLAN_ID
DEMAND_PLAN_NAME
DP_DIMENSION_CODE
DP_DIMENSION
HIERARCHY_ID
HIERARCHY_NAME
HIERARCHY_DESCRIPTION
OWNING_DIMENSION_CODE
OWNING_DIMENSION
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE