Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | Not implemented in this database |
SELECT RDL.ROWID
, RDL.DATA_LEVEL_ID
, RDL.DATA_ELEMENT_ID
, RDE.DATA_ELEMENT_NAME
, RL.DEMAND_PLAN_ID
, FCU.LOOKUP_CODE DIMENSION_CODE
, FCU.MEANING DIMENSION_NAME
, RDL.LOWEST_LEVEL_ID
, RL.LEVEL_NAME
, RDL.DATA_COLUMN_NAME
, RDL.DATA_ID_COLUMN_NAME
, RDL.SEED_FLAG
, RDL.LAST_UPDATE_DATE
, RDL.LAST_UPDATED_BY
, RDL.CREATION_DATE
, RDL.CREATED_BY
, RDL.LAST_UPDATE_LOGIN
, RDL.REQUEST_ID
, RDL.PROGRAM_APPLICATION_ID
, RDL.PROGRAM_ID
, RDL.PROGRAM_UPDATE_DATE
, RDL.ATTRIBUTE_CATEGORY
, RDL.ATTRIBUTE1
, RDL.ATTRIBUTE2
, RDL.ATTRIBUTE3
, RDL.ATTRIBUTE4
, RDL.ATTRIBUTE5
, RDL.ATTRIBUTE6
, RDL.ATTRIBUTE7
, RDL.ATTRIBUTE8
, RDL.ATTRIBUTE9
, RDL.ATTRIBUTE10
, RDL.ATTRIBUTE11
, RDL.ATTRIBUTE12
, RDL.ATTRIBUTE13
, RDL.ATTRIBUTE14
, RDL.ATTRIBUTE15
FROM FND_COMMON_LOOKUPS FCU
, RHX_DP_LEVELS RL
, RHX_DP_DATA_ELEMENTS RDE
, RHX_DP_DATA_LEVELS RDL
WHERE RDL.DATA_ELEMENT_ID = RDE.DATA_ELEMENT_ID
AND RL.LEVEL_ID (+) = RDL.LOWEST_LEVEL_ID
AND NVL(RL.DEMAND_PLAN_ID
, RDE.DEMAND_PLAN_ID) = RDE.DEMAND_PLAN_ID
AND FCU.LOOKUP_TYPE = 'DEMAND_PLANNER_DIMENSIONS'
AND FCU.LOOKUP_CODE = RDL.DIMENSION_CODE