[Home] [Help]
View: FIIBV_PROJ_CATEG7_LCV
Product: | FII - Financial Intelligence |
Description: | FIIBV_PROJ_CATEG7_LCV is the Category 7 base view for the Project dimension in EDW |
Implementation/DBA Data: |
APPS.FIIBV_PROJ_CATEG7_LCV
|
View Text
SELECT CLASS_CATEGORY || '-' || ELI.INSTANCE_CODE
, CLASS_CATEGORY
, CLASS_CATEGORY
, 'ALL'
, ELI.INSTANCE_CODE
, CL.LAST_UPDATE_DATE
, '_DF:PA:PA_CLASS_CATEGORIES_DESC_FLEX:CL'
FROM PA_CLASS_CATEGORIES CL
, EDW_LOCAL_SYSTEM_PARAMETERS CT
, EDW_LOCAL_INSTANCE ELI
WHERE CL.CLASS_CATEGORY = CT.CLASS_CATEG7
Columns
Name |
PROJ_CATEG7_PK |
NAME |
PROJECT_CATEGORY7 |
ALL_FK |
INSTANCE |
LAST_UPDATE_DATE |
"_DF:PCT:_EDW" |