eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: FII_PROJ_PROJECT_LCV

Product:	FII - Financial Intelligence (Obsolete)
Description:	FII_PROJ_PROJECT_LCV is the Project level source view for the Project dimension in EDW
Implementation/DBA Data:	Not implemented in this database

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