Skip to content FND Design Data [Home] [Help]

View: FIIBV_PROJ_CLS1_LCV

Product: FII - Financial Intelligence
Description: FIIBV_PROJ_CLS1_LCV is the Class 1 base view for the Project dimension in EDW
Implementation/DBA Data: ViewAPPS.FIIBV_PROJ_CLS1_LCV
View Text

SELECT CLASS_CODE || '-' || ELI.INSTANCE_CODE
, CLASS_CODE
, CLASS_CODE
, CLASS_CATEGORY || '-' || ELI.INSTANCE_CODE
, ELI.INSTANCE_CODE
, CL.LAST_UPDATE_DATE
, '_DF:PA:PA_CLASS_CODES_DESC_FLEX:CL'
FROM PA_CLASS_CODES CL
, EDW_LOCAL_SYSTEM_PARAMETERS CT
, EDW_LOCAL_INSTANCE ELI
WHERE CL.CLASS_CATEGORY = CT.CLASS_CATEG1

Columns

Name
PROJ_CLS1_PK
NAME
PROJECT_CLASS1
PROJ_CATEG1_FK
INSTANCE
LAST_UPDATE_DATE
"_DF:PCL:_EDW"