VIEW: APPS.FIIBV_PROJ_PROJECT_LCV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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