Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | Not implemented in this database |
SELECT H.HIERARCHY_ID
, H.HIERARCHY_NAME
, H.DIMENSION_CODE
, FCL.MEANING
, H.DEMAND_PLAN_ID
, DP.DEMAND_PLAN_NAME
, H.DISPLAY_SEQUENCE
, H.DISPLAY_FLAG
, H.DEFINING_HIERARCHY_ID
, H.ATTRIBUTE_CATEGORY
, H.ATTRIBUTE1
, H.ATTRIBUTE2
, H.ATTRIBUTE3
, H.ATTRIBUTE4
, H.ATTRIBUTE5
, H.ATTRIBUTE6
, H.ATTRIBUTE7
, H.ATTRIBUTE8
, H.ATTRIBUTE9
, H.ATTRIBUTE10
, H.ATTRIBUTE11
, H.ATTRIBUTE12
, H.ATTRIBUTE13
, H.ATTRIBUTE14
, H.ATTRIBUTE15
FROM RHX_DP_DEMAND_PLANS DP
, FND_COMMON_LOOKUPS FCL
, RHX_DP_HIERARCHIES H
WHERE FCL.LOOKUP_CODE = H.DIMENSION_CODE
AND FCL.LOOKUP_TYPE = 'DEMAND_PLANNER_DIMENSIONS'
AND DP.DEMAND_PLAN_ID = H.DEMAND_PLAN_ID
AND H.VALID_FLAG = 1