Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | Not implemented in this database |
SELECT RDL.ROWID ROW_ID
, RDL.LEVEL_ID
, RDL.LEVEL_NAME
, RDL.DEMAND_PLAN_ID
, RDP.DEMAND_PLAN_NAME
, RDL.DIMENSION_CODE
, FCU.MEANING DIMENSION_NAME
, RDL.DESCRIPTION
, 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.LEVEL_TYPE_CODE
, RDL.DATABASE_VIEW
, RDL.LEVEL_VALUE_COLUMN
, RDL.LEVEL_VALUE_ID_COLUMN
, RDL.WHERE_CLAUSE
, RDL.ADDITIONAL_CHAR_FLAG
, RDL.SEED_FLAG
, RDL.BUCKET_START_DATE_COLUMN
, RDL.BUCKET_END_DATE_COLUMN
, 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 MFG_LOOKUPS MLU
, FND_COMMON_LOOKUPS FCU
, RHX_DP_DEMAND_PLANS RDP
, RHX_DP_LEVELS RDL
WHERE RDP.DEMAND_PLAN_ID = RDL.DEMAND_PLAN_ID
AND FCU.LOOKUP_TYPE = 'DEMAND_PLANNER_DIMENSIONS'
AND FCU.LOOKUP_CODE = RDL.DIMENSION_CODE
AND MLU.LOOKUP_TYPE = 'RHX_DP_LEVEL_TYPE'
AND MLU.LOOKUP_CODE = RDL.LEVEL_TYPE_CODE