FND Design Data [Home] [Help]

View: RHX_DP_LEVELS_V

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

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

Columns

Name
ROW_ID
LEVEL_ID
LEVEL_NAME
DEMAND_PLAN_ID
DEMAND_PLAN_NAME
DIMENSION_CODE
DIMENSION_NAME
DESCRIPTION
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
LEVEL_TYPE_CODE
DATABASE_VIEW
LEVEL_VALUE_COLUMN
LEVEL_VALUE_ID_COLUMN
WHERE_CLAUSE
ADDITIONAL_CHAR_FLAG
SEED_FLAG
BUCKET_START_DATE_COLUMN
BUCKET_END_DATE_COLUMN
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15