[Home] [Help]
View: FIIBV_PROJ_PRJ_TYP_LCV
Product: | FII - Financial Intelligence (Obsolete) |
Description: | FIIBV_PROJ_PRJ_TYP_LCV is the Project Type level base view for the Project dimension in EDW |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PT.ORG_ID || '-' || PT.PROJECT_TYPE || '-' || ELI.INSTANCE_CODE
, PT.PROJECT_TYPE || DECODE(PT.ORG_ID
, NULL
, NULL
, '
, ' || ORG.NAME)
, PT.PROJECT_TYPE
, 'ALL'
, ELI.INSTANCE_CODE
, PT.LAST_UPDATE_DATE
, '_DF:PA:PA_PROJECT_TYPES_DESC_FLEX:PT'
FROM PA_PROJECT_TYPES_ALL PT
, HR_ALL_ORGANIZATION_UNITS ORG
, EDW_LOCAL_INSTANCE ELI
WHERE NVL(PT.ORG_ID
, -99) = ORG.ORGANIZATION_ID (+)
Columns
Name |
PRJ_TYP_PK |
NAME |
PROJECT_TYPE |
ALL_FK |
INSTANCE |
LAST_UPDATE_DATE |
"_DF:PRT:_EDW" |