View: FIIBV_PROJ_PROJECT_LCV

Product:	FII - Financial Intelligence
Description:	FIIBV_PROJ_PROJECT_LCV is the Project level base view for the Project dimension in EDW
Implementation/DBA Data:	APPS.FIIBV_PROJ_PROJECT_LCV

View Text

SELECT PA.PROJECT_ID || '-' || ELI.INSTANCE_CODE || '-' || 'PJ' PROJECT_PK
, PA.SEGMENT1 NAME
, PA.NAME PROJECT
, PA.SEGMENT1 PROJECT_NUMBER
, PA.ORG_ID || '-' || PA.PROJECT_TYPE || '-' || ELI.INSTANCE_CODE PRJ_TYP_FK
, EDW_PROJ_CLS.GET_CLASS_FK(PA.PROJECT_ID
, ELSP.CLASS_CATEG1) PROJ_CLS1_FK
, EDW_PROJ_CLS.GET_CLASS_FK(PA.PROJECT_ID
, ELSP.CLASS_CATEG2) PROJ_CLS2_FK
, EDW_PROJ_CLS.GET_CLASS_FK(PA.PROJECT_ID
, ELSP.CLASS_CATEG3) PROJ_CLS3_FK
, EDW_PROJ_CLS.GET_CLASS_FK(PA.PROJECT_ID
, ELSP.CLASS_CATEG4) PROJ_CLS4_FK
, EDW_PROJ_CLS.GET_CLASS_FK(PA.PROJECT_ID
, ELSP.CLASS_CATEG5) PROJ_CLS5_FK
, EDW_PROJ_CLS.GET_CLASS_FK(PA.PROJECT_ID
, ELSP.CLASS_CATEG6) PROJ_CLS6_FK
, EDW_PROJ_CLS.GET_CLASS_FK(PA.PROJECT_ID
, ELSP.CLASS_CATEG7) PROJ_CLS7_FK
, ELI.INSTANCE_CODE INSTANCE
, PA.DISTRIBUTION_RULE DISTRIBUTION_RULE
, PA.PROJECT_STATUS_CODE PROJECT_STATUS_CODE
, NULL PROJECT_MANAGER
, PA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, '_DF:PA:PA_PROJECTS_DESC_FLEX:PA'
, '_DF:_DUMMY:PJM:PJM_SEIBAN_NUMBERS:SB'
FROM PA_PROJECTS_ALL PA
, EDW_LOCAL_SYSTEM_PARAMETERS ELSP
, EDW_LOCAL_INSTANCE ELI UNION ALL SELECT SB.PROJECT_ID || '-' || ELI.INSTANCE_CODE || '-' || 'PJ' PROJECT_PK
, SB.PROJECT_NUMBER NAME
, SB.PROJECT_NAME PROJECT
, SB.PROJECT_NUMBER PROJECT_NUMBER
, 'FII_PJM_SEIBAN_PROJECT_TYPE-' || ELI.INSTANCE_CODE PRJ_TYP_FK
, 'NA_EDW' PROJ_CLS1_FK
, 'NA_EDW' PROJ_CLS2_FK
, 'NA_EDW' PROJ_CLS3_FK
, 'NA_EDW' PROJ_CLS4_FK
, 'NA_EDW' PROJ_CLS5_FK
, 'NA_EDW' PROJ_CLS6_FK
, 'NA_EDW' PROJ_CLS7_FK
, ELI.INSTANCE_CODE INSTANCE
, TO_CHAR( NULL ) DISTRIBUTION_RULE
, TO_CHAR( NULL ) PROJECT_STATUS_CODE
, TO_CHAR( NULL ) PROJECT_MANAGER
, SB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, '_DF:_DUMMY:PA:PA_PROJECTS_DESC_FLEX:PA'
, '_DF:PJM:PJM_SEIBAN_NUMBERS:SB'
FROM PJM_SEIBAN_NUMBERS SB
, EDW_LOCAL_INSTANCE ELI

Columns