PJO_PLAN_VERSIONS_VL

Details

• Schema: FUSION

• Object owner: PJO

• Object type: VIEW

Columns

Name

PLAN_VERSION_ID ORIGINAL_FLAG VERSION_NAME DESCRIPTION LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER OBJECT_TYPE_CODE PROJECT_ID OBJECT_ID1 PLAN_TYPE_ID PLANNED_FOR_CODE PLAN_STATUS_CODE VERSION_NUMBER LOCKED_BY_PERSON_ID CURRENT_PLAN_STATUS_FLAG BASELINED_BY_PERSON_ID BASELINED_DATE PEOPLE_QUANTITY EQUIPMENT_QUANTITY PFC_RAW_COST PFC_BRDND_COST PFC_REVENUE TOTAL_PC_RAW_COST TOTAL_PC_BRDND_COST TOTAL_PC_REVENUE PM_PRODUCT_CODE PM_BUDGET_REFERENCE WF_STATUS_CODE PLAN_RUN_DATE REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE PJI_SUMMARIZED_FLAG LAST_AMT_GEN_DATE ACTUAL_AMTS_THRU_PERIOD ETC_START_DATE PJS_SUMMARY_ID PLAN_CLASS_CODE MULTI_ERROR_FLAG PLAN_PROCESS_STATUS_CODE STRUCTURE_VERSION_ID PLAN_PROCESSING_CODE SUBMITTED_BY SUBMITTED_DATE REJECTION_DATE REJECTED_BY BUDGETARY_CONTROLS_FLAG LAST_REFRESH_DATE PROCESS_FLAG ESS_STATUS ESS_REQUEST_ID PROCESSING_TIME LINES_PROCESSED ADDL_ATTRIBUTE_NUM_1 ADDL_ATTRIBUTE_NUM_2 ADDL_ATTRIBUTE_NUM_3 ADDL_ATTRIBUTE_NUM_4 ADDL_ATTRIBUTE_NUM_5 ADDL_ATTRIBUTE_NUM_6 ADDL_ATTRIBUTE_NUM_7 ADDL_ATTRIBUTE_NUM_8 ADDL_ATTRIBUTE_NUM_9 ADDL_ATTRIBUTE_NUM_10 ADDL_ATTRIBUTE_VAR_1 ADDL_ATTRIBUTE_VAR_2 ADDL_ATTRIBUTE_VAR_3 ADDL_ATTRIBUTE_VAR_4 ADDL_ATTRIBUTE_VAR_5 ADDL_ATTRIBUTE_VAR_6 ADDL_ATTRIBUTE_VAR_7 ADDL_ATTRIBUTE_VAR_8 ADDL_ATTRIBUTE_VAR_9 ADDL_ATTRIBUTE_VAR_10 ADDL_ATTRIBUTE_DATE_1 ADDL_ATTRIBUTE_DATE_2 ADDL_ATTRIBUTE_DATE_3 ADDL_ATTRIBUTE_DATE_4 ADDL_ATTRIBUTE_DATE_5 CHANGE_DOCUMENT_FLAG ENHANCED_BC_FLAG

Query

SQL_Statement

SELECT B.PLAN_VERSION_ID, B.ORIGINAL_FLAG, T.VERSION_NAME, T.DESCRIPTION, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.OBJECT_TYPE_CODE, B.PROJECT_ID, B.OBJECT_ID1, B.PLAN_TYPE_ID, B.PLANNED_FOR_CODE, B.PLAN_STATUS_CODE, B.VERSION_NUMBER, B.LOCKED_BY_PERSON_ID, B.CURRENT_PLAN_STATUS_FLAG, B.BASELINED_BY_PERSON_ID, B.BASELINED_DATE, B.PEOPLE_QUANTITY, B.EQUIPMENT_QUANTITY, B.PFC_RAW_COST, B.PFC_BRDND_COST, B.PFC_REVENUE, B.TOTAL_PC_RAW_COST, B.TOTAL_PC_BRDND_COST, B.TOTAL_PC_REVENUE, B.PM_PRODUCT_CODE, B.PM_BUDGET_REFERENCE, B.WF_STATUS_CODE, B.PLAN_RUN_DATE, B.REQUEST_ID, B.JOB_DEFINITION_NAME, B.JOB_DEFINITION_PACKAGE, B.PJI_SUMMARIZED_FLAG, B.LAST_AMT_GEN_DATE, B.ACTUAL_AMTS_THRU_PERIOD, B.ETC_START_DATE, B.PJS_SUMMARY_ID, B.PLAN_CLASS_CODE, B.MULTI_ERROR_FLAG, B.PLAN_PROCESS_STATUS_CODE, B.STRUCTURE_VERSION_ID, B.PLAN_PROCESSING_CODE, B.SUBMITTED_BY, B.SUBMITTED_DATE, B.REJECTION_DATE, B.REJECTED_BY, B.BUDGETARY_CONTROLS_FLAG, B.LAST_REFRESH_DATE, B.PROCESS_FLAG, B.ESS_STATUS, B.ESS_REQUEST_ID, B.PROCESSING_TIME, B.LINES_PROCESSED, B.ADDL_ATTRIBUTE_NUM_1, B.ADDL_ATTRIBUTE_NUM_2, B.ADDL_ATTRIBUTE_NUM_3, B.ADDL_ATTRIBUTE_NUM_4, B.ADDL_ATTRIBUTE_NUM_5, B.ADDL_ATTRIBUTE_NUM_6, B.ADDL_ATTRIBUTE_NUM_7, B.ADDL_ATTRIBUTE_NUM_8, B.ADDL_ATTRIBUTE_NUM_9, B.ADDL_ATTRIBUTE_NUM_10, B.ADDL_ATTRIBUTE_VAR_1, B.ADDL_ATTRIBUTE_VAR_2, B.ADDL_ATTRIBUTE_VAR_3, B.ADDL_ATTRIBUTE_VAR_4, B.ADDL_ATTRIBUTE_VAR_5, B.ADDL_ATTRIBUTE_VAR_6, B.ADDL_ATTRIBUTE_VAR_7, B.ADDL_ATTRIBUTE_VAR_8, B.ADDL_ATTRIBUTE_VAR_9, B.ADDL_ATTRIBUTE_VAR_10, B.ADDL_ATTRIBUTE_DATE_1, B.ADDL_ATTRIBUTE_DATE_2, B.ADDL_ATTRIBUTE_DATE_3, B.ADDL_ATTRIBUTE_DATE_4, B.ADDL_ATTRIBUTE_DATE_5, B.CHANGE_DOCUMENT_FLAG, B.ENHANCED_BC_FLAG FROM PJO_PLAN_VERSIONS_TL T, PJO_PLAN_VERSIONS_B B WHERE B.PLAN_VERSION_ID = T.PLAN_VERSION_ID AND T.LANGUAGE = USERENV('LANG')