Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | Not implemented in this database |
SELECT RDH.ROWID
, RDH.HIERARCHY_ID
, RDH.DEMAND_PLAN_ID
, RDP.DEMAND_PLAN_NAME
, RDH.HIERARCHY_NAME
, RDH.DESCRIPTION
, RDH.DIMENSION_CODE
, FCU.MEANING DIMENSION_NAME
, RDH.DISPLAY_SEQUENCE
, NVL(RDH.VALID_FLAG
, 2)
, RDH.DISPLAY_FLAG
, RDH.DEFINING_HIERARCHY_ID
, RDH2.HIERARCHY_NAME DEFINING_HIERARCHY_NAME
, RDH.SEED_FLAG
, RDH.LAST_UPDATE_DATE
, RDH.LAST_UPDATED_BY
, RDH.CREATION_DATE
, RDH.CREATED_BY
, RDH.LAST_UPDATE_LOGIN
, RDH.REQUEST_ID
, RDH.PROGRAM_APPLICATION_ID
, RDH.PROGRAM_ID
, RDH.PROGRAM_UPDATE_DATE
, RDH.ATTRIBUTE_CATEGORY
, RDH.ATTRIBUTE1
, RDH.ATTRIBUTE2
, RDH.ATTRIBUTE3
, RDH.ATTRIBUTE4
, RDH.ATTRIBUTE5
, RDH.ATTRIBUTE6
, RDH.ATTRIBUTE7
, RDH.ATTRIBUTE8
, RDH.ATTRIBUTE9
, RDH.ATTRIBUTE10
, RDH.ATTRIBUTE11
, RDH.ATTRIBUTE12
, RDH.ATTRIBUTE13
, RDH.ATTRIBUTE14
, RDH.ATTRIBUTE15
FROM RHX_DP_HIERARCHIES RDH2
, FND_COMMON_LOOKUPS FCU
, RHX_DP_DEMAND_PLANS RDP
, RHX_DP_HIERARCHIES RDH
WHERE RDP.DEMAND_PLAN_ID = RDH.DEMAND_PLAN_ID
AND FCU.LOOKUP_TYPE = 'DEMAND_PLANNER_DIMENSIONS'
AND FCU.LOOKUP_CODE = RDH.DIMENSION_CODE
AND RDH2.HIERARCHY_ID (+) = NVL(RDH.DEFINING_HIERARCHY_ID
, -999)