[Home] [Help]
View: FII_PROJ_PROJECT_LCV
Product: | FII - Financial Intelligence |
Description: | FII_PROJ_PROJECT_LCV is the Project level source view for the Project dimension in EDW |
Implementation/DBA Data: |
APPS.FII_PROJ_PROJECT_LCV
|
View Text
SELECT PROJECT_PK
, NAME
, PROJECT
, PROJECT_NUMBER
, PRJ_TYP_FK
, PROJ_CLS1_FK
, PROJ_CLS2_FK
, PROJ_CLS3_FK
, PROJ_CLS4_FK
, PROJ_CLS5_FK
, PROJ_CLS6_FK
, PROJ_CLS7_FK
, INSTANCE
, DISTRIBUTION_RULE
, PROJECT_STATUS_CODE
, PROJECT_MANAGER
, LAST_UPDATE_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
FROM FIIBV_PROJ_PROJECT_LCV
Columns
Name |
PROJECT_PK |
NAME |
PROJECT |
PROJECT_NUMBER |
PRJ_TYP_FK |
PROJ_CLS1_FK |
PROJ_CLS2_FK |
PROJ_CLS3_FK |
PROJ_CLS4_FK |
PROJ_CLS5_FK |
PROJ_CLS6_FK |
PROJ_CLS7_FK |
INSTANCE |
DISTRIBUTION_RULE |
PROJECT_STATUS_CODE |
PROJECT_MANAGER |
LAST_UPDATE_DATE |
USER_ATTRIBUTE1 |
USER_ATTRIBUTE2 |
USER_ATTRIBUTE3 |
USER_ATTRIBUTE4 |
USER_ATTRIBUTE5 |