VIEW: PA.PA_BUDGET_VERSIONS#

Source

View Text - Preformatted

select BUDGET_VERSION_ID BUDGET_VERSION_ID, PROJECT_ID PROJECT_ID, BUDGET_TYPE_CODE BUDGET_TYPE_CODE, VERSION_NUMBER VERSION_NUMBER, BUDGET_STATUS_CODE BUDGET_STATUS_CODE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CURRENT_FLAG CURRENT_FLAG, ORIGINAL_FLAG ORIGINAL_FLAG, CURRENT_ORIGINAL_FLAG CURRENT_ORIGINAL_FLAG, RESOURCE_ACCUMULATED_FLAG RESOURCE_ACCUMULATED_FLAG, RESOURCE_LIST_ID RESOURCE_LIST_ID, VERSION_NAME VERSION_NAME, BUDGET_ENTRY_METHOD_CODE BUDGET_ENTRY_METHOD_CODE, BASELINED_BY_PERSON_ID BASELINED_BY_PERSON_ID, BASELINED_DATE BASELINED_DATE, CHANGE_REASON_CODE CHANGE_REASON_CODE, LABOR_QUANTITY LABOR_QUANTITY, LABOR_UNIT_OF_MEASURE LABOR_UNIT_OF_MEASURE, RAW_COST RAW_COST, BURDENED_COST BURDENED_COST, REVENUE REVENUE, DESCRIPTION DESCRIPTION, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, FIRST_BUDGET_PERIOD FIRST_BUDGET_PERIOD, PM_PRODUCT_CODE PM_PRODUCT_CODE, PM_BUDGET_REFERENCE PM_BUDGET_REFERENCE, WF_STATUS_CODE WF_STATUS_CODE, ADW_NOTIFY_FLAG ADW_NOTIFY_FLAG, PRC_GENERATED_FLAG PRC_GENERATED_FLAG, PLAN_RUN_DATE PLAN_RUN_DATE, PLAN_PROCESSING_CODE PLAN_PROCESSING_CODE, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER, PERIOD_PROFILE_ID PERIOD_PROFILE_ID, FIN_PLAN_TYPE_ID FIN_PLAN_TYPE_ID, PARENT_PLAN_VERSION_ID PARENT_PLAN_VERSION_ID, PROJECT_STRUCTURE_VERSION_ID PROJECT_STRUCTURE_VERSION_ID, TOTAL_BORROWED_REVENUE TOTAL_BORROWED_REVENUE, TOTAL_TP_REVENUE_IN TOTAL_TP_REVENUE_IN, TOTAL_TP_REVENUE_OUT TOTAL_TP_REVENUE_OUT, TOTAL_REVENUE_ADJ TOTAL_REVENUE_ADJ, TOTAL_LENT_RESOURCE_COST TOTAL_LENT_RESOURCE_COST, TOTAL_TP_COST_IN TOTAL_TP_COST_IN, TOTAL_TP_COST_OUT TOTAL_TP_COST_OUT, TOTAL_COST_ADJ TOTAL_COST_ADJ, TOTAL_UNASSIGNED_TIME_COST TOTAL_UNASSIGNED_TIME_COST, TOTAL_UTILIZATION_PERCENT TOTAL_UTILIZATION_PERCENT, TOTAL_UTILIZATION_HOURS TOTAL_UTILIZATION_HOURS, TOTAL_UTILIZATION_ADJ TOTAL_UTILIZATION_ADJ, TOTAL_CAPACITY TOTAL_CAPACITY, TOTAL_HEAD_COUNT TOTAL_HEAD_COUNT, TOTAL_HEAD_COUNT_ADJ TOTAL_HEAD_COUNT_ADJ, CURRENT_WORKING_FLAG CURRENT_WORKING_FLAG, VERSION_TYPE VERSION_TYPE, REQUEST_ID REQUEST_ID, TOTAL_PROJECT_RAW_COST TOTAL_PROJECT_RAW_COST, TOTAL_PROJECT_BURDENED_COST TOTAL_PROJECT_BURDENED_COST, TOTAL_PROJECT_REVENUE TOTAL_PROJECT_REVENUE, LOCKED_BY_PERSON_ID LOCKED_BY_PERSON_ID, APPROVED_COST_PLAN_TYPE_FLAG APPROVED_COST_PLAN_TYPE_FLAG, APPROVED_REV_PLAN_TYPE_FLAG APPROVED_REV_PLAN_TYPE_FLAG, EST_PROJECT_RAW_COST EST_PROJECT_RAW_COST, EST_PROJECT_BURDENED_COST EST_PROJECT_BURDENED_COST, EST_PROJECT_REVENUE EST_PROJECT_REVENUE, EST_QUANTITY EST_QUANTITY, EST_PROJFUNC_RAW_COST EST_PROJFUNC_RAW_COST, EST_PROJFUNC_BURDENED_COST EST_PROJFUNC_BURDENED_COST, EST_PROJFUNC_REVENUE EST_PROJFUNC_REVENUE, CI_ID CI_ID, AGREEMENT_ID AGREEMENT_ID, PROCESS_UPDATE_WBS_FLAG PROCESS_UPDATE_WBS_FLAG, OBJECT_TYPE_CODE OBJECT_TYPE_CODE, OBJECT_ID OBJECT_ID, PRIMARY_COST_FORECAST_FLAG PRIMARY_COST_FORECAST_FLAG, PRIMARY_REV_FORECAST_FLAG PRIMARY_REV_FORECAST_FLAG, REV_PARTIALLY_IMPL_FLAG REV_PARTIALLY_IMPL_FLAG, EQUIPMENT_QUANTITY EQUIPMENT_QUANTITY, PJI_SUMMARIZED_FLAG PJI_SUMMARIZED_FLAG, WP_VERSION_FLAG WP_VERSION_FLAG, CURRENT_PLANNING_PERIOD CURRENT_PLANNING_PERIOD, PERIOD_MASK_ID PERIOD_MASK_ID, LAST_AMT_GEN_DATE LAST_AMT_GEN_DATE, ACTUAL_AMTS_THRU_PERIOD ACTUAL_AMTS_THRU_PERIOD, EST_EQUIPMENT_QUANTITY EST_EQUIPMENT_QUANTITY, ETC_START_DATE ETC_START_DATE, PURGED_FLAG PURGED_FLAG, OLAP_CHANGE_FLAG OLAP_CHANGE_FLAG from "PA"."PA_BUDGET_VERSIONS"

View Text - HTML Formatted

SELECT BUDGET_VERSION_ID BUDGET_VERSION_ID
, PROJECT_ID PROJECT_ID
, BUDGET_TYPE_CODE BUDGET_TYPE_CODE
, VERSION_NUMBER VERSION_NUMBER
, BUDGET_STATUS_CODE BUDGET_STATUS_CODE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CURRENT_FLAG CURRENT_FLAG
, ORIGINAL_FLAG ORIGINAL_FLAG
, CURRENT_ORIGINAL_FLAG CURRENT_ORIGINAL_FLAG
, RESOURCE_ACCUMULATED_FLAG RESOURCE_ACCUMULATED_FLAG
, RESOURCE_LIST_ID RESOURCE_LIST_ID
, VERSION_NAME VERSION_NAME
, BUDGET_ENTRY_METHOD_CODE BUDGET_ENTRY_METHOD_CODE
, BASELINED_BY_PERSON_ID BASELINED_BY_PERSON_ID
, BASELINED_DATE BASELINED_DATE
, CHANGE_REASON_CODE CHANGE_REASON_CODE
, LABOR_QUANTITY LABOR_QUANTITY
, LABOR_UNIT_OF_MEASURE LABOR_UNIT_OF_MEASURE
, RAW_COST RAW_COST
, BURDENED_COST BURDENED_COST
, REVENUE REVENUE
, DESCRIPTION DESCRIPTION
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, FIRST_BUDGET_PERIOD FIRST_BUDGET_PERIOD
, PM_PRODUCT_CODE PM_PRODUCT_CODE
, PM_BUDGET_REFERENCE PM_BUDGET_REFERENCE
, WF_STATUS_CODE WF_STATUS_CODE
, ADW_NOTIFY_FLAG ADW_NOTIFY_FLAG
, PRC_GENERATED_FLAG PRC_GENERATED_FLAG
, PLAN_RUN_DATE PLAN_RUN_DATE
, PLAN_PROCESSING_CODE PLAN_PROCESSING_CODE
, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER
, PERIOD_PROFILE_ID PERIOD_PROFILE_ID
, FIN_PLAN_TYPE_ID FIN_PLAN_TYPE_ID
, PARENT_PLAN_VERSION_ID PARENT_PLAN_VERSION_ID
, PROJECT_STRUCTURE_VERSION_ID PROJECT_STRUCTURE_VERSION_ID
, TOTAL_BORROWED_REVENUE TOTAL_BORROWED_REVENUE
, TOTAL_TP_REVENUE_IN TOTAL_TP_REVENUE_IN
, TOTAL_TP_REVENUE_OUT TOTAL_TP_REVENUE_OUT
, TOTAL_REVENUE_ADJ TOTAL_REVENUE_ADJ
, TOTAL_LENT_RESOURCE_COST TOTAL_LENT_RESOURCE_COST
, TOTAL_TP_COST_IN TOTAL_TP_COST_IN
, TOTAL_TP_COST_OUT TOTAL_TP_COST_OUT
, TOTAL_COST_ADJ TOTAL_COST_ADJ
, TOTAL_UNASSIGNED_TIME_COST TOTAL_UNASSIGNED_TIME_COST
, TOTAL_UTILIZATION_PERCENT TOTAL_UTILIZATION_PERCENT
, TOTAL_UTILIZATION_HOURS TOTAL_UTILIZATION_HOURS
, TOTAL_UTILIZATION_ADJ TOTAL_UTILIZATION_ADJ
, TOTAL_CAPACITY TOTAL_CAPACITY
, TOTAL_HEAD_COUNT TOTAL_HEAD_COUNT
, TOTAL_HEAD_COUNT_ADJ TOTAL_HEAD_COUNT_ADJ
, CURRENT_WORKING_FLAG CURRENT_WORKING_FLAG
, VERSION_TYPE VERSION_TYPE
, REQUEST_ID REQUEST_ID
, TOTAL_PROJECT_RAW_COST TOTAL_PROJECT_RAW_COST
, TOTAL_PROJECT_BURDENED_COST TOTAL_PROJECT_BURDENED_COST
, TOTAL_PROJECT_REVENUE TOTAL_PROJECT_REVENUE
, LOCKED_BY_PERSON_ID LOCKED_BY_PERSON_ID
, APPROVED_COST_PLAN_TYPE_FLAG APPROVED_COST_PLAN_TYPE_FLAG
, APPROVED_REV_PLAN_TYPE_FLAG APPROVED_REV_PLAN_TYPE_FLAG
, EST_PROJECT_RAW_COST EST_PROJECT_RAW_COST
, EST_PROJECT_BURDENED_COST EST_PROJECT_BURDENED_COST
, EST_PROJECT_REVENUE EST_PROJECT_REVENUE
, EST_QUANTITY EST_QUANTITY
, EST_PROJFUNC_RAW_COST EST_PROJFUNC_RAW_COST
, EST_PROJFUNC_BURDENED_COST EST_PROJFUNC_BURDENED_COST
, EST_PROJFUNC_REVENUE EST_PROJFUNC_REVENUE
, CI_ID CI_ID
, AGREEMENT_ID AGREEMENT_ID
, PROCESS_UPDATE_WBS_FLAG PROCESS_UPDATE_WBS_FLAG
, OBJECT_TYPE_CODE OBJECT_TYPE_CODE
, OBJECT_ID OBJECT_ID
, PRIMARY_COST_FORECAST_FLAG PRIMARY_COST_FORECAST_FLAG
, PRIMARY_REV_FORECAST_FLAG PRIMARY_REV_FORECAST_FLAG
, REV_PARTIALLY_IMPL_FLAG REV_PARTIALLY_IMPL_FLAG
, EQUIPMENT_QUANTITY EQUIPMENT_QUANTITY
, PJI_SUMMARIZED_FLAG PJI_SUMMARIZED_FLAG
, WP_VERSION_FLAG WP_VERSION_FLAG
, CURRENT_PLANNING_PERIOD CURRENT_PLANNING_PERIOD
, PERIOD_MASK_ID PERIOD_MASK_ID
, LAST_AMT_GEN_DATE LAST_AMT_GEN_DATE
, ACTUAL_AMTS_THRU_PERIOD ACTUAL_AMTS_THRU_PERIOD
, EST_EQUIPMENT_QUANTITY EST_EQUIPMENT_QUANTITY
, ETC_START_DATE ETC_START_DATE
, PURGED_FLAG PURGED_FLAG
, OLAP_CHANGE_FLAG OLAP_CHANGE_FLAG
FROM "PA"."PA_BUDGET_VERSIONS"