eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: RHX_DP_DATA_ELMNT_PUB_V

Product:	MRP - Master Scheduling/MRP
Description:	- Retrofitted
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT DISTINCT DE.DATA_ELEMENT_ID
, DL1.DATA_LEVEL_ID
, DE.DEMAND_PLAN_ID
, DP.DEMAND_PLAN_NAME
, DE.DATA_ELEMENT_SOURCE
, DE.DATA_ELEMENT_NAME
, DE.DATA_ELEMENT_GROUP
, DE.DATA_ELEMENT_TYPE_CODE
, DL1.LOWEST_LEVEL_ID
, L1.LEVEL_NAME
, DL2.LOWEST_LEVEL_ID
, L2.LEVEL_NAME
, DE.MODIFY_RELATIVE_TO
, NVL(DE.MODIFY_START
, 0)
, DE.DP_DB_FILENAME
, DE.DP_DB_FILENAME_FLAG
, DE.DATA_TYPE
, DE.DISPLAY_FORMAT
, DE.HISTORICAL_SUBS_FLAG
, DE.ROW_TYPE
, DE.LOCK_FLAG
, DE.PLAN_OPTIONAL_PARAMS
, DE.LOAD_OPTIONAL_PARAMS
, DE.START_DATE
, DE.END_DATE
, DE.LOAD_FLAG
, DE.ATTRIBUTE_CATEGORY
, DE.ATTRIBUTE1
, DE.ATTRIBUTE2
, DE.ATTRIBUTE3
, DE.ATTRIBUTE4
, DE.ATTRIBUTE5
, DE.ATTRIBUTE6
, DE.ATTRIBUTE7
, DE.ATTRIBUTE8
, DE.ATTRIBUTE9
, DE.ATTRIBUTE10
, DE.ATTRIBUTE11
, DE.ATTRIBUTE12
, DE.ATTRIBUTE13
, DE.ATTRIBUTE14
, DE.ATTRIBUTE15
FROM RHX_DP_LEVELS L2
, RHX_DP_DATA_LEVELS DL2
, RHX_DP_LEVELS L1
, RHX_DP_DATA_LEVELS DL1
, RHX_DP_DEMAND_PLANS DP
, RHX_DP_DATA_ELEMENTS DE
WHERE DE.DATA_ELEMENT_ID = DL1.DATA_ELEMENT_ID
AND DE.DATA_ELEMENT_ID = DL2.DATA_ELEMENT_ID
AND DL1.DIMENSION_CODE = 'GEO'
AND DP.DEMAND_PLAN_ID = DE.DEMAND_PLAN_ID
AND DL2.DIMENSION_CODE = 'PRD'
AND DL1.LOWEST_LEVEL_ID = L1.LEVEL_ID
AND DL2.LOWEST_LEVEL_ID = L2.LEVEL_ID
AND DE.DATA_ELEMENT_TYPE_CODE = 1
AND DE.DATA_ELEMENT_SOURCE NOT IN ('FORECAST'
, 'FORECAST_SET') UNION ALL SELECT DISTINCT DE.DATA_ELEMENT_ID
, DL1.DATA_LEVEL_ID
, DE.DEMAND_PLAN_ID
, DP.DEMAND_PLAN_NAME
, DE.DATA_ELEMENT_SOURCE
, DE.DATA_ELEMENT_NAME||RHX_DP.GET_PARAMETER('RHX_DP_P_DELIMITER')|| OD.ORGANIZATION_CODE
, DE.DATA_ELEMENT_GROUP
, DE.DATA_ELEMENT_TYPE_CODE
, DL1.LOWEST_LEVEL_ID
, L1.LEVEL_NAME
, DL2.LOWEST_LEVEL_ID
, L2.LEVEL_NAME
, DE.MODIFY_RELATIVE_TO
, NVL(DE.MODIFY_START
, 0)
, DE.DP_DB_FILENAME
, DE.DP_DB_FILENAME_FLAG
, DE.DATA_TYPE
, DE.DISPLAY_FORMAT
, DE.HISTORICAL_SUBS_FLAG
, DE.ROW_TYPE
, DE.LOCK_FLAG
, DE.PLAN_OPTIONAL_PARAMS
, DE.LOAD_OPTIONAL_PARAMS
, DE.START_DATE
, DE.END_DATE
, DE.LOAD_FLAG
, DE.ATTRIBUTE_CATEGORY
, DE.ATTRIBUTE1
, DE.ATTRIBUTE2
, DE.ATTRIBUTE3
, DE.ATTRIBUTE4
, DE.ATTRIBUTE5
, DE.ATTRIBUTE6
, DE.ATTRIBUTE7
, DE.ATTRIBUTE8
, DE.ATTRIBUTE9
, DE.ATTRIBUTE10
, DE.ATTRIBUTE11
, DE.ATTRIBUTE12
, DE.ATTRIBUTE13
, DE.ATTRIBUTE14
, DE.ATTRIBUTE15
FROM ORG_ORGANIZATION_DEFINITIONS OD
, RHX_DP_LEVELS L2
, RHX_DP_DATA_LEVELS DL2
, RHX_DP_LEVELS L1
, RHX_DP_DATA_LEVELS DL1
, RHX_DP_DEMAND_PLANS DP
, RHX_DP_DATA_ELEMENTS DE
WHERE DE.DATA_ELEMENT_ID = DL1.DATA_ELEMENT_ID
AND DE.DATA_ELEMENT_ID = DL2.DATA_ELEMENT_ID
AND DL1.DIMENSION_CODE = 'GEO'
AND DP.DEMAND_PLAN_ID = DE.DEMAND_PLAN_ID
AND DL2.DIMENSION_CODE = 'PRD'
AND DL1.LOWEST_LEVEL_ID = L1.LEVEL_ID
AND DL2.LOWEST_LEVEL_ID = L2.LEVEL_ID
AND DE.DATA_ELEMENT_TYPE_CODE = 1
AND DE.DATA_ELEMENT_SOURCE IN ('FORECAST'
, 'FORECAST_SET')
AND DE.ORGANIZATION_ID = OD.ORGANIZATION_ID UNION ALL SELECT DISTINCT DE.DATA_ELEMENT_ID
, -999
, DE.DEMAND_PLAN_ID
, DP.DEMAND_PLAN_NAME
, DATA_ELEMENT_SOURCE
, DE.DATA_ELEMENT_NAME || RHX_DP.GET_PARAMETER('RHX_DP_P_DELIMITER')|| OD.ORGANIZATION_CODE
, DE.DATA_ELEMENT_GROUP
, DE.DATA_ELEMENT_TYPE_CODE
, -999
, ' '
, -999
, ' '
, DE.MODIFY_RELATIVE_TO
, DE.MODIFY_START
, DE.DP_DB_FILENAME
, DE.DP_DB_FILENAME_FLAG
, DE.DATA_TYPE
, DE.DISPLAY_FORMAT
, DE.HISTORICAL_SUBS_FLAG
, DE.ROW_TYPE
, DE.LOCK_FLAG
, DE.PLAN_OPTIONAL_PARAMS
, DE.LOAD_OPTIONAL_PARAMS
, DE.START_DATE
, DE.END_DATE
, DE.LOAD_FLAG
, DE.ATTRIBUTE_CATEGORY
, DE.ATTRIBUTE1
, DE.ATTRIBUTE2
, DE.ATTRIBUTE3
, DE.ATTRIBUTE4
, DE.ATTRIBUTE5
, DE.ATTRIBUTE6
, DE.ATTRIBUTE7
, DE.ATTRIBUTE8
, DE.ATTRIBUTE9
, DE.ATTRIBUTE10
, DE.ATTRIBUTE11
, DE.ATTRIBUTE12
, DE.ATTRIBUTE13
, DE.ATTRIBUTE14
, DE.ATTRIBUTE15
FROM ORG_ORGANIZATION_DEFINITIONS OD
, RHX_DP_DEMAND_PLANS DP
, RHX_DP_DATA_ELEMENTS DE
WHERE DP.DEMAND_PLAN_ID = DE.DEMAND_PLAN_ID
AND DE.DATA_ELEMENT_TYPE_CODE = 2
AND DE.ORGANIZATION_ID = OD.ORGANIZATION_ID UNION ALL SELECT DISTINCT DE.DATA_ELEMENT_ID
, -999
, DE.DEMAND_PLAN_ID
, DP.DEMAND_PLAN_NAME
, DATA_ELEMENT_SOURCE
, DE.DATA_ELEMENT_NAME
, DE.DATA_ELEMENT_GROUP
, DE.DATA_ELEMENT_TYPE_CODE
, -999
, ' '
, -999
, ' '
, DE.MODIFY_RELATIVE_TO
, DE.MODIFY_START
, DE.DP_DB_FILENAME
, DE.DP_DB_FILENAME_FLAG
, DE.DATA_TYPE
, DE.DISPLAY_FORMAT
, DE.HISTORICAL_SUBS_FLAG
, DE.ROW_TYPE
, DE.LOCK_FLAG
, DE.PLAN_OPTIONAL_PARAMS
, DE.LOAD_OPTIONAL_PARAMS
, DE.START_DATE
, DE.END_DATE
, DE.LOAD_FLAG
, DE.ATTRIBUTE_CATEGORY
, DE.ATTRIBUTE1
, DE.ATTRIBUTE2
, DE.ATTRIBUTE3
, DE.ATTRIBUTE4
, DE.ATTRIBUTE5
, DE.ATTRIBUTE6
, DE.ATTRIBUTE7
, DE.ATTRIBUTE8
, DE.ATTRIBUTE9
, DE.ATTRIBUTE10
, DE.ATTRIBUTE11
, DE.ATTRIBUTE12
, DE.ATTRIBUTE13
, DE.ATTRIBUTE14
, DE.ATTRIBUTE15
FROM RHX_DP_DEMAND_PLANS DP
, RHX_DP_DATA_ELEMENTS DE
WHERE DP.DEMAND_PLAN_ID = DE.DEMAND_PLAN_ID
AND DE.DATA_ELEMENT_TYPE_CODE = 3

Columns

Name
DATA_ELEMENT_ID
DATA_LEVEL_ID
DEMAND_PLAN_ID
DEMAND_PLAN_NAME
DATA_ELEMENT_SOURCE
DATA_ELEMENT_NAME
DATA_ELEMENT_GROUP
DATA_ELEMENT_TYPE
LOWEST_LEVEL_ID_G
LOWEST_LEVEL_NAME_G
LOWEST_LEVEL_ID_P
LOWEST_LEVEL_NAME_P
MODIFY_RELATIVE_TO
MODIFY_START
DP_DB_FILENAME
DP_DB_FILENAME_FLAG
DATA_TYPE
DISPLAY_FORMAT
HISTORICAL_SUBS_FLAG
ROW_TYPE
LOCK_FLAG
PLAN_OPTIONAL_PARAMS
LOAD_OPTIONAL_PARAMS
START_DATE
END_DATE
LOAD_FLAG
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15