Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | Not implemented in this database |
SELECT RHL.ROWID
, RDH.DEMAND_PLAN_ID
, RDH.DIMENSION_CODE
, RHL.HIERARCHY_ID
, RDH.HIERARCHY_NAME
, RHL.LEVEL_ID
, RDL1.LEVEL_NAME
, RHL.PARENT_LEVEL_ID
, RDL2.LEVEL_NAME PARENT_LEVEL_NAME
, RHL.RELATIONSHIP_VIEW
, RHL.PARENT_VALUE_COLUMN
, RHL.PARENT_ID_COLUMN
, RHL.JOIN_CONDITION
, RHL.SEED_FLAG
, RHL.LAST_UPDATE_DATE
, RHL.LAST_UPDATED_BY
, RHL.CREATION_DATE
, RHL.CREATED_BY
, RHL.LAST_UPDATE_LOGIN
, RHL.REQUEST_ID
, RHL.PROGRAM_APPLICATION_ID
, RHL.PROGRAM_ID
, RHL.PROGRAM_UPDATE_DATE
, RHL.ATTRIBUTE_CATEGORY
, RHL.ATTRIBUTE1
, RHL.ATTRIBUTE2
, RHL.ATTRIBUTE3
, RHL.ATTRIBUTE4
, RHL.ATTRIBUTE5
, RHL.ATTRIBUTE6
, RHL.ATTRIBUTE7
, RHL.ATTRIBUTE8
, RHL.ATTRIBUTE9
, RHL.ATTRIBUTE10
, RHL.ATTRIBUTE11
, RHL.ATTRIBUTE12
, RHL.ATTRIBUTE13
, RHL.ATTRIBUTE14
, RHL.ATTRIBUTE15
FROM RHX_DP_LEVELS RDL2
, RHX_DP_LEVELS RDL1
, RHX_DP_HIERARCHIES RDH
, RHX_DP_HIERARCHY_LEVELS RHL
WHERE RDH.HIERARCHY_ID = RHL.HIERARCHY_ID
AND RDL1.DEMAND_PLAN_ID = RDH.DEMAND_PLAN_ID
AND RDL1.DIMENSION_CODE = RDH.DIMENSION_CODE
AND RDL1.LEVEL_ID = RHL.LEVEL_ID
AND RDL2.DEMAND_PLAN_ID = RDL1.DEMAND_PLAN_ID
AND RDL2.DIMENSION_CODE = RDL1.DIMENSION_CODE
AND RDL2.LEVEL_ID = RHL.PARENT_LEVEL_ID