PJF_PROJECTS_ALL_VL

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name

PROJECT_ID OBJECT_VERSION_NUMBER SEGMENT1 PROJECT_TYPE_ID CARRYING_OUT_ORGANIZATION_ID PUBLIC_SECTOR_FLAG PROJECT_STATUS_CODE START_DATE COMPLETION_DATE CLOSED_DATE CLIN_LINKED_CODE IC_CLIN_LINKED_CODE LIMIT_TO_TXN_CONTROLS_FLAG REQUEST_ID PROGRAM_ID PROGRAM_APPLICATION_ID PROGRAM_UPDATE_DATE SUMMARY_FLAG ENABLED_FLAG NAME DESCRIPTION GROUP_SPACE_TEMPLATE_NAME SEGMENT2 SEGMENT3 SEGMENT4 SEGMENT5 SEGMENT6 SEGMENT7 SEGMENT8 SEGMENT9 SEGMENT10 ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE21 ATTRIBUTE22 ATTRIBUTE23 ATTRIBUTE24 ATTRIBUTE25 ATTRIBUTE26 ATTRIBUTE27 ATTRIBUTE28 ATTRIBUTE29 ATTRIBUTE30 ATTRIBUTE31 ATTRIBUTE32 ATTRIBUTE33 ATTRIBUTE34 ATTRIBUTE35 ATTRIBUTE36 ATTRIBUTE37 ATTRIBUTE38 ATTRIBUTE39 ATTRIBUTE40 ATTRIBUTE41 ATTRIBUTE42 ATTRIBUTE43 ATTRIBUTE44 ATTRIBUTE45 ATTRIBUTE46 ATTRIBUTE47 ATTRIBUTE48 ATTRIBUTE49 ATTRIBUTE50 ATTRIBUTE1_NUMBER ATTRIBUTE2_NUMBER ATTRIBUTE3_NUMBER ATTRIBUTE4_NUMBER ATTRIBUTE5_NUMBER ATTRIBUTE6_NUMBER ATTRIBUTE7_NUMBER ATTRIBUTE8_NUMBER ATTRIBUTE9_NUMBER ATTRIBUTE10_NUMBER ATTRIBUTE11_NUMBER ATTRIBUTE12_NUMBER ATTRIBUTE13_NUMBER ATTRIBUTE14_NUMBER ATTRIBUTE15_NUMBER ATTRIBUTE1_DATE ATTRIBUTE2_DATE ATTRIBUTE3_DATE ATTRIBUTE4_DATE ATTRIBUTE5_DATE ATTRIBUTE6_DATE ATTRIBUTE7_DATE ATTRIBUTE8_DATE ATTRIBUTE9_DATE ATTRIBUTE10_DATE ATTRIBUTE11_DATE ATTRIBUTE12_DATE ATTRIBUTE13_DATE ATTRIBUTE14_DATE ATTRIBUTE15_DATE COST_IND_RATE_SCH_ID COST_IND_SCH_FIXED_DATE OVR_COST_IND_RATE_SCH_ID TEMPLATE_FLAG VERIFICATION_DATE CREATED_FROM_PROJECT_ID TEMPLATE_START_DATE_ACTIVE TEMPLATE_END_DATE_ACTIVE ORG_ID PROJECT_UNIT_ID LEGAL_ENTITY_ID PLANNING_PROJECT_FLAG PM_PRODUCT_CODE PM_PROJECT_REFERENCE ACTUAL_START_DATE ACTUAL_FINISH_DATE EARLY_START_DATE EARLY_FINISH_DATE LATE_START_DATE LATE_FINISH_DATE SCHEDULED_START_DATE SCHEDULED_FINISH_DATE PROJECT_CURRENCY_CODE ALLOW_CROSS_CHARGE_FLAG CC_PROCESS_LABOR_FLAG LABOR_TP_SCHEDULE_ID LABOR_TP_FIXED_DATE CC_PROCESS_NL_FLAG NL_TP_SCHEDULE_ID NL_TP_FIXED_DATE WORK_TYPE_ID SERVICE_TYPE_CODE PROJECT_VALUE EXPECTED_APPROVAL_DATE PROJFUNC_CURRENCY_CODE CURRENCY_CONV_RATE_TYPE CURRENCY_CONV_DATE_TYPE_CODE CURRENCY_CONV_DATE PRIORITY_CODE TARGET_START_DATE TARGET_FINISH_DATE BASELINE_START_DATE BASELINE_FINISH_DATE SCHEDULED_AS_OF_DATE BASELINE_AS_OF_DATE ACTUAL_AS_OF_DATE SCHEDULED_DURATION BASELINE_DURATION ACTUAL_DURATION ASSET_ALLOCATION_METHOD CAPITAL_EVENT_PROCESSING CINT_RATE_SCH_ID CINT_ELIGIBLE_FLAG CINT_STOP_DATE STRUCTURE_SHARING_CODE KPI_NOTIFICATION_INCLUDE_NOTES KPI_NOTIFICATION_ENABLED KPI_NOTIFICATION_RECIPIENTS BPEL_STATUS_CODE LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN OUTLINE_LEVEL PROJECT_CALENDAR_ID PROJECT_CATEGORY HOURS_PER_DAY EXTERNAL_PROJECT_ID PUBLIC_TEMPLATE_FLAG TEMPL_CREATED_BY_RES_ID EXECUTION_CUSTOMER_NAME GROUP_SPACE_NAME PROJECT_PLAN_VIEW_ACCESS BUDGETARY_CONTROL_FLAG INTEGRATED_PRODUCT_CODE INTEGRATED_PROJECT_REFERENCE

Query

SQL_Statement

SELECT B.PROJECT_ID PROJECT_ID, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.SEGMENT1 SEGMENT1, B.PROJECT_TYPE_ID PROJECT_TYPE_ID, B.CARRYING_OUT_ORGANIZATION_ID CARRYING_OUT_ORGANIZATION_ID, B.PUBLIC_SECTOR_FLAG PUBLIC_SECTOR_FLAG, B.PROJECT_STATUS_CODE PROJECT_STATUS_CODE, B.START_DATE START_DATE, B.COMPLETION_DATE COMPLETION_DATE, B.CLOSED_DATE CLOSED_DATE, B.CLIN_LINKED_CODE CLIN_LINKED_CODE, B.IC_CLIN_LINKED_CODE IC_CLIN_LINKED_CODE, B.LIMIT_TO_TXN_CONTROLS_FLAG LIMIT_TO_TXN_CONTROLS_FLAG, B.REQUEST_ID REQUEST_ID, B.PROGRAM_ID PROGRAM_ID, B.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, B.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, B.SUMMARY_FLAG SUMMARY_FLAG, B.ENABLED_FLAG ENABLED_FLAG, T.NAME NAME, T.DESCRIPTION DESCRIPTION, B.GROUP_SPACE_TEMPLATE_NAME GROUP_SPACE_TEMPLATE_NAME, B.SEGMENT2 SEGMENT2, B.SEGMENT3 SEGMENT3, B.SEGMENT4 SEGMENT4, B.SEGMENT5 SEGMENT5, B.SEGMENT6 SEGMENT6, B.SEGMENT7 SEGMENT7, B.SEGMENT8 SEGMENT8, B.SEGMENT9 SEGMENT9, B.SEGMENT10 SEGMENT10, B.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, B.ATTRIBUTE1 ATTRIBUTE1, B.ATTRIBUTE2 ATTRIBUTE2, B.ATTRIBUTE3 ATTRIBUTE3, B.ATTRIBUTE4 ATTRIBUTE4, B.ATTRIBUTE5 ATTRIBUTE5, B.ATTRIBUTE6 ATTRIBUTE6, B.ATTRIBUTE7 ATTRIBUTE7, B.ATTRIBUTE8 ATTRIBUTE8, B.ATTRIBUTE9 ATTRIBUTE9, B.ATTRIBUTE10 ATTRIBUTE10, B.ATTRIBUTE11 ATTRIBUTE11, B.ATTRIBUTE12 ATTRIBUTE12, B.ATTRIBUTE13 ATTRIBUTE13, B.ATTRIBUTE14 ATTRIBUTE14, B.ATTRIBUTE15 ATTRIBUTE15, B.ATTRIBUTE16 ATTRIBUTE16, B.ATTRIBUTE17 ATTRIBUTE17, B.ATTRIBUTE18 ATTRIBUTE18, B.ATTRIBUTE19 ATTRIBUTE19, B.ATTRIBUTE20 ATTRIBUTE20, B.ATTRIBUTE21 ATTRIBUTE21, B.ATTRIBUTE22 ATTRIBUTE22, B.ATTRIBUTE23 ATTRIBUTE23, B.ATTRIBUTE24 ATTRIBUTE24, B.ATTRIBUTE25 ATTRIBUTE25, B.ATTRIBUTE26 ATTRIBUTE26, B.ATTRIBUTE27 ATTRIBUTE27, B.ATTRIBUTE28 ATTRIBUTE28, B.ATTRIBUTE29 ATTRIBUTE29, B.ATTRIBUTE30 ATTRIBUTE30, B.ATTRIBUTE31 ATTRIBUTE31, B.ATTRIBUTE32 ATTRIBUTE32, B.ATTRIBUTE33 ATTRIBUTE33, B.ATTRIBUTE34 ATTRIBUTE34, B.ATTRIBUTE35 ATTRIBUTE35, B.ATTRIBUTE36 ATTRIBUTE36, B.ATTRIBUTE37 ATTRIBUTE37, B.ATTRIBUTE38 ATTRIBUTE38, B.ATTRIBUTE39 ATTRIBUTE39, B.ATTRIBUTE40 ATTRIBUTE40, B.ATTRIBUTE41 ATTRIBUTE41, B.ATTRIBUTE42 ATTRIBUTE42, B.ATTRIBUTE43 ATTRIBUTE43, B.ATTRIBUTE44 ATTRIBUTE44, B.ATTRIBUTE45 ATTRIBUTE45, B.ATTRIBUTE46 ATTRIBUTE46, B.ATTRIBUTE47 ATTRIBUTE47, B.ATTRIBUTE48 ATTRIBUTE48, B.ATTRIBUTE49 ATTRIBUTE49, B.ATTRIBUTE50 ATTRIBUTE50, B.ATTRIBUTE1_NUMBER ATTRIBUTE1_NUMBER, B.ATTRIBUTE2_NUMBER ATTRIBUTE2_NUMBER, B.ATTRIBUTE3_NUMBER ATTRIBUTE3_NUMBER, B.ATTRIBUTE4_NUMBER ATTRIBUTE4_NUMBER, B.ATTRIBUTE5_NUMBER ATTRIBUTE5_NUMBER, B.ATTRIBUTE6_NUMBER ATTRIBUTE6_NUMBER, B.ATTRIBUTE7_NUMBER ATTRIBUTE7_NUMBER, B.ATTRIBUTE8_NUMBER ATTRIBUTE8_NUMBER, B.ATTRIBUTE9_NUMBER ATTRIBUTE9_NUMBER, B.ATTRIBUTE10_NUMBER ATTRIBUTE10_NUMBER, B.ATTRIBUTE11_NUMBER ATTRIBUTE11_NUMBER, B.ATTRIBUTE12_NUMBER ATTRIBUTE12_NUMBER, B.ATTRIBUTE13_NUMBER ATTRIBUTE13_NUMBER, B.ATTRIBUTE14_NUMBER ATTRIBUTE14_NUMBER, B.ATTRIBUTE15_NUMBER ATTRIBUTE15_NUMBER, B.ATTRIBUTE1_DATE ATTRIBUTE1_DATE, B.ATTRIBUTE2_DATE ATTRIBUTE2_DATE, B.ATTRIBUTE3_DATE ATTRIBUTE3_DATE, B.ATTRIBUTE4_DATE ATTRIBUTE4_DATE, B.ATTRIBUTE5_DATE ATTRIBUTE5_DATE, B.ATTRIBUTE6_DATE ATTRIBUTE6_DATE, B.ATTRIBUTE7_DATE ATTRIBUTE7_DATE, B.ATTRIBUTE8_DATE ATTRIBUTE8_DATE, B.ATTRIBUTE9_DATE ATTRIBUTE9_DATE, B.ATTRIBUTE10_DATE ATTRIBUTE10_DATE, B.ATTRIBUTE11_DATE ATTRIBUTE11_DATE, B.ATTRIBUTE12_DATE ATTRIBUTE12_DATE, B.ATTRIBUTE13_DATE ATTRIBUTE13_DATE, B.ATTRIBUTE14_DATE ATTRIBUTE14_DATE, B.ATTRIBUTE15_DATE ATTRIBUTE15_DATE, B.COST_IND_RATE_SCH_ID COST_IND_RATE_SCH_ID, B.COST_IND_SCH_FIXED_DATE COST_IND_SCH_FIXED_DATE, B.OVR_COST_IND_RATE_SCH_ID OVR_COST_IND_RATE_SCH_ID, B.TEMPLATE_FLAG TEMPLATE_FLAG, B.VERIFICATION_DATE VERIFICATION_DATE, B.CREATED_FROM_PROJECT_ID CREATED_FROM_PROJECT_ID, B.TEMPLATE_START_DATE_ACTIVE TEMPLATE_START_DATE_ACTIVE, B.TEMPLATE_END_DATE_ACTIVE TEMPLATE_END_DATE_ACTIVE, B.ORG_ID ORG_ID, B.PROJECT_UNIT_ID PROJECT_UNIT_ID, B.LEGAL_ENTITY_ID LEGAL_ENTITY_ID, B.PLANNING_PROJECT_FLAG PLANNING_PROJECT_FLAG, B.PM_PRODUCT_CODE PM_PRODUCT_CODE, B.PM_PROJECT_REFERENCE PM_PROJECT_REFERENCE, B.ACTUAL_START_DATE ACTUAL_START_DATE, B.ACTUAL_FINISH_DATE ACTUAL_FINISH_DATE, B.EARLY_START_DATE EARLY_START_DATE, B.EARLY_FINISH_DATE EARLY_FINISH_DATE, B.LATE_START_DATE LATE_START_DATE, B.LATE_FINISH_DATE LATE_FINISH_DATE, B.SCHEDULED_START_DATE SCHEDULED_START_DATE, B.SCHEDULED_FINISH_DATE SCHEDULED_FINISH_DATE, B.PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE, B.ALLOW_CROSS_CHARGE_FLAG ALLOW_CROSS_CHARGE_FLAG, B.CC_PROCESS_LABOR_FLAG CC_PROCESS_LABOR_FLAG, B.LABOR_TP_SCHEDULE_ID LABOR_TP_SCHEDULE_ID, B.LABOR_TP_FIXED_DATE LABOR_TP_FIXED_DATE, B.CC_PROCESS_NL_FLAG CC_PROCESS_NL_FLAG, B.NL_TP_SCHEDULE_ID NL_TP_SCHEDULE_ID, B.NL_TP_FIXED_DATE NL_TP_FIXED_DATE, B.WORK_TYPE_ID WORK_TYPE_ID, B.SERVICE_TYPE_CODE SERVICE_TYPE_CODE, B.PROJECT_VALUE PROJECT_VALUE, B.EXPECTED_APPROVAL_DATE EXPECTED_APPROVAL_DATE, B.PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE, B.CURRENCY_CONV_RATE_TYPE CURRENCY_CONV_RATE_TYPE, B.CURRENCY_CONV_DATE_TYPE_CODE CURRENCY_CONV_DATE_TYPE_CODE, B.CURRENCY_CONV_DATE CURRENCY_CONV_DATE, B.PRIORITY_CODE PRIORITY_CODE, B.TARGET_START_DATE TARGET_START_DATE, B.TARGET_FINISH_DATE TARGET_FINISH_DATE, B.BASELINE_START_DATE BASELINE_START_DATE, B.BASELINE_FINISH_DATE BASELINE_FINISH_DATE, B.SCHEDULED_AS_OF_DATE SCHEDULED_AS_OF_DATE, B.BASELINE_AS_OF_DATE BASELINE_AS_OF_DATE, B.ACTUAL_AS_OF_DATE ACTUAL_AS_OF_DATE, B.SCHEDULED_DURATION SCHEDULED_DURATION, B.BASELINE_DURATION BASELINE_DURATION, B.ACTUAL_DURATION ACTUAL_DURATION, B.ASSET_ALLOCATION_METHOD ASSET_ALLOCATION_METHOD, B.CAPITAL_EVENT_PROCESSING CAPITAL_EVENT_PROCESSING, B.CINT_RATE_SCH_ID CINT_RATE_SCH_ID, B.CINT_ELIGIBLE_FLAG CINT_ELIGIBLE_FLAG, B.CINT_STOP_DATE CINT_STOP_DATE, B.STRUCTURE_SHARING_CODE STRUCTURE_SHARING_CODE, B.KPI_NOTIFICATION_INCLUDE_NOTES, B.KPI_NOTIFICATION_ENABLED, B.KPI_NOTIFICATION_RECIPIENTS, B.BPEL_STATUS_CODE, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.CREATION_DATE CREATION_DATE, B.CREATED_BY CREATED_BY, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.OUTLINE_LEVEL OUTLINE_LEVEL, B.PROJECT_CALENDAR_ID, B.PROJECT_CATEGORY, B.HOURS_PER_DAY, B.EXTERNAL_PROJECT_ID, B.PUBLIC_TEMPLATE_FLAG, B.TEMPL_CREATED_BY_RES_ID, T.EXECUTION_CUSTOMER_NAME, B.GROUP_SPACE_NAME GROUP_SPACE_NAME, B.PROJECT_PLAN_VIEW_ACCESS, B.BUDGETARY_CONTROL_FLAG, B.INTEGRATED_PRODUCT_CODE, B.INTEGRATED_PROJECT_REFERENCE FROM PJF_PROJECTS_ALL_B B, PJF_PROJECTS_ALL_TL T WHERE T.PROJECT_ID = B.PROJECT_ID AND LANGUAGE = USERENV('LANG')