Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | Not implemented in this database |
SELECT DATA.DP_DATA_ID
, DATA.LINE_ID
, DATA.DEMAND_PLAN_ID
, DEMAND_PLANS.DEMAND_PLAN_NAME
, DATA.DATA_ELEMENT_ID
, DATA_ELEMENTS.DATA_ELEMENT_NAME
, DATA.DATA_VALUE
, DATA.LOWEST_LEVEL_ID_G
, GEOGRAPHY.LEVEL_NAME
, DATA.LOWEST_LEVEL_VALUE_G
, DATA.LOWEST_LEVEL_ID_P
, ITEM.LEVEL_NAME
, DATA.LOWEST_LEVEL_VALUE_P
, DATA.LOWEST_LEVEL_ID_T
, TIME.LEVEL_NAME
, DATA.LOWEST_LEVEL_VALUE_T
, DATA.LAST_UPDATE_DATE
, DATA.LAST_UPDATED_BY
, DATA.CREATION_DATE
, DATA.CREATED_BY
, DATA.LAST_UPDATE_LOGIN
, DATA.REQUEST_ID
, DATA.PROGRAM_APPLICATION_ID
, DATA.PROGRAM_ID
, DATA.PROGRAM_UPDATE_DATE
, DATA.ATTRIBUTE_CATEGORY
, DATA.ATTRIBUTE1
, DATA.ATTRIBUTE2
, DATA.ATTRIBUTE3
, DATA.ATTRIBUTE4
, DATA.ATTRIBUTE5
, DATA.ATTRIBUTE6
, DATA.ATTRIBUTE7
, DATA.ATTRIBUTE8
, DATA.ATTRIBUTE9
, DATA.ATTRIBUTE10
, DATA.ATTRIBUTE11
, DATA.ATTRIBUTE12
, DATA.ATTRIBUTE13
, DATA.ATTRIBUTE14
, DATA.ATTRIBUTE15
FROM RHX_DP_DATA DATA
, RHX_DP_LEVELS TIME
, RHX_DP_LEVELS ITEM
, RHX_DP_LEVELS GEOGRAPHY
, RHX_DP_DATA_ELEMENTS DATA_ELEMENTS
, RHX_DP_DEMAND_PLANS DEMAND_PLANS
WHERE DATA.DEMAND_PLAN_ID=DEMAND_PLANS.DEMAND_PLAN_ID
AND DATA.DATA_ELEMENT_ID=DATA_ELEMENTS.DATA_ELEMENT_ID
AND DATA.LOWEST_LEVEL_ID_G=GEOGRAPHY.LEVEL_ID
AND DATA.LOWEST_LEVEL_ID_P=ITEM.LEVEL_ID
AND DATA.LOWEST_LEVEL_ID_T=TIME.LEVEL_ID