Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | Not implemented in this database |
SELECT L.LEVEL_ID
, L.LEVEL_NAME
, L.LEVEL_TYPE_CODE
, L.DIMENSION_CODE
, FCL.MEANING
, L.DEMAND_PLAN_ID
, DP.DEMAND_PLAN_NAME
, L.ADDITIONAL_CHAR_FLAG
, L.ATTRIBUTE_CATEGORY
, L.ATTRIBUTE1
, L.ATTRIBUTE2
, L.ATTRIBUTE3
, L.ATTRIBUTE4
, L.ATTRIBUTE5
, L.ATTRIBUTE6
, L.ATTRIBUTE7
, L.ATTRIBUTE8
, L.ATTRIBUTE9
, L.ATTRIBUTE10
, L.ATTRIBUTE11
, L.ATTRIBUTE12
, L.ATTRIBUTE13
, L.ATTRIBUTE14
, L.ATTRIBUTE15
FROM RHX_DP_DEMAND_PLANS DP
, FND_COMMON_LOOKUPS FCL
, RHX_DP_LEVELS L
WHERE FCL.LOOKUP_CODE = L.DIMENSION_CODE
AND FCL.LOOKUP_TYPE = 'DEMAND_PLANNER_DIMENSIONS'
AND DP.DEMAND_PLAN_ID = L.DEMAND_PLAN_ID