VIEW: PA.PA_PROGRESS_ROLLUP#

Source

View Text - Preformatted

select PROGRESS_ROLLUP_ID PROGRESS_ROLLUP_ID, PERCENT_COMPLETE_ID PERCENT_COMPLETE_ID, PROJECT_ID PROJECT_ID, OBJECT_ID OBJECT_ID, OBJECT_TYPE OBJECT_TYPE, AS_OF_DATE AS_OF_DATE, OBJECT_VERSION_ID OBJECT_VERSION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, PROGRESS_STATUS_CODE PROGRESS_STATUS_CODE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, INCREMENTAL_WORK_QUANTITY INCREMENTAL_WORK_QUANTITY, CUMULATIVE_WORK_QUANTITY CUMULATIVE_WORK_QUANTITY, BASE_PERCENT_COMPLETE BASE_PERCENT_COMPLETE, EFF_ROLLUP_PERCENT_COMP EFF_ROLLUP_PERCENT_COMP, COMPLETED_PERCENTAGE COMPLETED_PERCENTAGE, ESTIMATED_START_DATE ESTIMATED_START_DATE, ESTIMATED_FINISH_DATE ESTIMATED_FINISH_DATE, ACTUAL_START_DATE ACTUAL_START_DATE, ACTUAL_FINISH_DATE ACTUAL_FINISH_DATE, ESTIMATED_REMAINING_EFFORT ESTIMATED_REMAINING_EFFORT, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER, BASE_PERCENT_COMP_DERIV_CODE BASE_PERCENT_COMP_DERIV_CODE, BASE_PROGRESS_STATUS_CODE BASE_PROGRESS_STATUS_CODE, EFF_ROLLUP_PROG_STAT_CODE EFF_ROLLUP_PROG_STAT_CODE, STRUCTURE_TYPE STRUCTURE_TYPE, PROJ_ELEMENT_ID PROJ_ELEMENT_ID, STRUCTURE_VERSION_ID STRUCTURE_VERSION_ID, PPL_ACT_EFFORT_TO_DATE PPL_ACT_EFFORT_TO_DATE, EQPMT_ACT_EFFORT_TO_DATE EQPMT_ACT_EFFORT_TO_DATE, EQPMT_ETC_EFFORT EQPMT_ETC_EFFORT, OTH_ACT_COST_TO_DATE_TC OTH_ACT_COST_TO_DATE_TC, OTH_ACT_COST_TO_DATE_FC OTH_ACT_COST_TO_DATE_FC, OTH_ACT_COST_TO_DATE_PC OTH_ACT_COST_TO_DATE_PC, OTH_ETC_COST_TC OTH_ETC_COST_TC, OTH_ETC_COST_FC OTH_ETC_COST_FC, OTH_ETC_COST_PC OTH_ETC_COST_PC, PPL_ACT_COST_TO_DATE_TC PPL_ACT_COST_TO_DATE_TC, PPL_ACT_COST_TO_DATE_FC PPL_ACT_COST_TO_DATE_FC, PPL_ACT_COST_TO_DATE_PC PPL_ACT_COST_TO_DATE_PC, PPL_ETC_COST_TC PPL_ETC_COST_TC, PPL_ETC_COST_FC PPL_ETC_COST_FC, PPL_ETC_COST_PC PPL_ETC_COST_PC, EQPMT_ACT_COST_TO_DATE_TC EQPMT_ACT_COST_TO_DATE_TC, EQPMT_ACT_COST_TO_DATE_FC EQPMT_ACT_COST_TO_DATE_FC, EQPMT_ACT_COST_TO_DATE_PC EQPMT_ACT_COST_TO_DATE_PC, EQPMT_ETC_COST_TC EQPMT_ETC_COST_TC, EQPMT_ETC_COST_FC EQPMT_ETC_COST_FC, EQPMT_ETC_COST_PC EQPMT_ETC_COST_PC, EARNED_VALUE EARNED_VALUE, TASK_WT_BASIS_CODE TASK_WT_BASIS_CODE, SUBPRJ_PPL_ACT_EFFORT SUBPRJ_PPL_ACT_EFFORT, SUBPRJ_EQPMT_ACT_EFFORT SUBPRJ_EQPMT_ACT_EFFORT, SUBPRJ_PPL_ETC_EFFORT SUBPRJ_PPL_ETC_EFFORT, SUBPRJ_EQPMT_ETC_EFFORT SUBPRJ_EQPMT_ETC_EFFORT, SUBPRJ_PPL_ACT_COST_TC SUBPRJ_PPL_ACT_COST_TC, SUBPRJ_PPL_ACT_COST_FC SUBPRJ_PPL_ACT_COST_FC, SUBPRJ_PPL_ACT_COST_PC SUBPRJ_PPL_ACT_COST_PC, SUBPRJ_EQPMT_ACT_COST_TC SUBPRJ_EQPMT_ACT_COST_TC, SUBPRJ_EQPMT_ACT_COST_FC SUBPRJ_EQPMT_ACT_COST_FC, SUBPRJ_EQPMT_ACT_COST_PC SUBPRJ_EQPMT_ACT_COST_PC, SUBPRJ_OTH_ETC_COST_TC SUBPRJ_OTH_ETC_COST_TC, SUBPRJ_OTH_ETC_COST_FC SUBPRJ_OTH_ETC_COST_FC, SUBPRJ_OTH_ETC_COST_PC SUBPRJ_OTH_ETC_COST_PC, SUBPRJ_PPL_ETC_COST_TC SUBPRJ_PPL_ETC_COST_TC, SUBPRJ_PPL_ETC_COST_FC SUBPRJ_PPL_ETC_COST_FC, SUBPRJ_PPL_ETC_COST_PC SUBPRJ_PPL_ETC_COST_PC, SUBPRJ_EQPMT_ETC_COST_TC SUBPRJ_EQPMT_ETC_COST_TC, SUBPRJ_EQPMT_ETC_COST_FC SUBPRJ_EQPMT_ETC_COST_FC, SUBPRJ_EQPMT_ETC_COST_PC SUBPRJ_EQPMT_ETC_COST_PC, SUBPRJ_EARNED_VALUE SUBPRJ_EARNED_VALUE, CURRENT_FLAG CURRENT_FLAG, PROJFUNC_COST_RATE_TYPE PROJFUNC_COST_RATE_TYPE, PROJFUNC_COST_EXCHANGE_RATE PROJFUNC_COST_EXCHANGE_RATE, PROJFUNC_COST_RATE_DATE PROJFUNC_COST_RATE_DATE, PROJ_COST_RATE_TYPE PROJ_COST_RATE_TYPE, PROJ_COST_EXCHANGE_RATE PROJ_COST_EXCHANGE_RATE, PROJ_COST_RATE_DATE PROJ_COST_RATE_DATE, TXN_CURRENCY_CODE TXN_CURRENCY_CODE, PROG_PA_PERIOD_NAME PROG_PA_PERIOD_NAME, PROG_GL_PERIOD_NAME PROG_GL_PERIOD_NAME, OTH_QUANTITY_TO_DATE OTH_QUANTITY_TO_DATE, OTH_ETC_QUANTITY OTH_ETC_QUANTITY, OTH_ACT_RAWCOST_TO_DATE_TC OTH_ACT_RAWCOST_TO_DATE_TC, OTH_ACT_RAWCOST_TO_DATE_FC OTH_ACT_RAWCOST_TO_DATE_FC, OTH_ACT_RAWCOST_TO_DATE_PC OTH_ACT_RAWCOST_TO_DATE_PC, OTH_ETC_RAWCOST_TC OTH_ETC_RAWCOST_TC, OTH_ETC_RAWCOST_FC OTH_ETC_RAWCOST_FC, OTH_ETC_RAWCOST_PC OTH_ETC_RAWCOST_PC, PPL_ACT_RAWCOST_TO_DATE_TC PPL_ACT_RAWCOST_TO_DATE_TC, PPL_ACT_RAWCOST_TO_DATE_FC PPL_ACT_RAWCOST_TO_DATE_FC, PPL_ACT_RAWCOST_TO_DATE_PC PPL_ACT_RAWCOST_TO_DATE_PC, PPL_ETC_RAWCOST_TC PPL_ETC_RAWCOST_TC, PPL_ETC_RAWCOST_FC PPL_ETC_RAWCOST_FC, PPL_ETC_RAWCOST_PC PPL_ETC_RAWCOST_PC, EQPMT_ACT_RAWCOST_TO_DATE_TC EQPMT_ACT_RAWCOST_TO_DATE_TC, EQPMT_ACT_RAWCOST_TO_DATE_FC EQPMT_ACT_RAWCOST_TO_DATE_FC, EQPMT_ACT_RAWCOST_TO_DATE_PC EQPMT_ACT_RAWCOST_TO_DATE_PC, EQPMT_ETC_RAWCOST_TC EQPMT_ETC_RAWCOST_TC, EQPMT_ETC_RAWCOST_FC EQPMT_ETC_RAWCOST_FC, EQPMT_ETC_RAWCOST_PC EQPMT_ETC_RAWCOST_PC, SUBPRJ_PPL_ACT_RAWCOST_TC SUBPRJ_PPL_ACT_RAWCOST_TC, SUBPRJ_PPL_ACT_RAWCOST_FC SUBPRJ_PPL_ACT_RAWCOST_FC, SUBPRJ_PPL_ACT_RAWCOST_PC SUBPRJ_PPL_ACT_RAWCOST_PC, SUBPRJ_EQPMT_ACT_RAWCOST_TC SUBPRJ_EQPMT_ACT_RAWCOST_TC, SUBPRJ_EQPMT_ACT_RAWCOST_FC SUBPRJ_EQPMT_ACT_RAWCOST_FC, SUBPRJ_EQPMT_ACT_RAWCOST_PC SUBPRJ_EQPMT_ACT_RAWCOST_PC, SUBPRJ_OTH_ETC_RAWCOST_TC SUBPRJ_OTH_ETC_RAWCOST_TC, SUBPRJ_OTH_ETC_RAWCOST_FC SUBPRJ_OTH_ETC_RAWCOST_FC, SUBPRJ_OTH_ETC_RAWCOST_PC SUBPRJ_OTH_ETC_RAWCOST_PC, SUBPRJ_PPL_ETC_RAWCOST_TC SUBPRJ_PPL_ETC_RAWCOST_TC, SUBPRJ_PPL_ETC_RAWCOST_FC SUBPRJ_PPL_ETC_RAWCOST_FC, SUBPRJ_PPL_ETC_RAWCOST_PC SUBPRJ_PPL_ETC_RAWCOST_PC, SUBPRJ_EQPMT_ETC_RAWCOST_TC SUBPRJ_EQPMT_ETC_RAWCOST_TC, SUBPRJ_EQPMT_ETC_RAWCOST_FC SUBPRJ_EQPMT_ETC_RAWCOST_FC, SUBPRJ_EQPMT_ETC_RAWCOST_PC SUBPRJ_EQPMT_ETC_RAWCOST_PC, SUBPRJ_OTH_ACT_COST_TO_DT_TC SUBPRJ_OTH_ACT_COST_TO_DT_TC, SUBPRJ_OTH_ACT_COST_TO_DT_FC SUBPRJ_OTH_ACT_COST_TO_DT_FC, SUBPRJ_OTH_ACT_COST_TO_DT_PC SUBPRJ_OTH_ACT_COST_TO_DT_PC, SPJ_OTH_ACT_RAWCOST_TO_DT_TC SPJ_OTH_ACT_RAWCOST_TO_DT_TC, SPJ_OTH_ACT_RAWCOST_TO_DT_FC SPJ_OTH_ACT_RAWCOST_TO_DT_FC, SPJ_OTH_ACT_RAWCOST_TO_DT_PC SPJ_OTH_ACT_RAWCOST_TO_DT_PC, CBS_ELEMENT_ID CBS_ELEMENT_ID from "PA"."PA_PROGRESS_ROLLUP"

View Text - HTML Formatted

SELECT PROGRESS_ROLLUP_ID PROGRESS_ROLLUP_ID
, PERCENT_COMPLETE_ID PERCENT_COMPLETE_ID
, PROJECT_ID PROJECT_ID
, OBJECT_ID OBJECT_ID
, OBJECT_TYPE OBJECT_TYPE
, AS_OF_DATE AS_OF_DATE
, OBJECT_VERSION_ID OBJECT_VERSION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, PROGRESS_STATUS_CODE PROGRESS_STATUS_CODE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, INCREMENTAL_WORK_QUANTITY INCREMENTAL_WORK_QUANTITY
, CUMULATIVE_WORK_QUANTITY CUMULATIVE_WORK_QUANTITY
, BASE_PERCENT_COMPLETE BASE_PERCENT_COMPLETE
, EFF_ROLLUP_PERCENT_COMP EFF_ROLLUP_PERCENT_COMP
, COMPLETED_PERCENTAGE COMPLETED_PERCENTAGE
, ESTIMATED_START_DATE ESTIMATED_START_DATE
, ESTIMATED_FINISH_DATE ESTIMATED_FINISH_DATE
, ACTUAL_START_DATE ACTUAL_START_DATE
, ACTUAL_FINISH_DATE ACTUAL_FINISH_DATE
, ESTIMATED_REMAINING_EFFORT ESTIMATED_REMAINING_EFFORT
, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER
, BASE_PERCENT_COMP_DERIV_CODE BASE_PERCENT_COMP_DERIV_CODE
, BASE_PROGRESS_STATUS_CODE BASE_PROGRESS_STATUS_CODE
, EFF_ROLLUP_PROG_STAT_CODE EFF_ROLLUP_PROG_STAT_CODE
, STRUCTURE_TYPE STRUCTURE_TYPE
, PROJ_ELEMENT_ID PROJ_ELEMENT_ID
, STRUCTURE_VERSION_ID STRUCTURE_VERSION_ID
, PPL_ACT_EFFORT_TO_DATE PPL_ACT_EFFORT_TO_DATE
, EQPMT_ACT_EFFORT_TO_DATE EQPMT_ACT_EFFORT_TO_DATE
, EQPMT_ETC_EFFORT EQPMT_ETC_EFFORT
, OTH_ACT_COST_TO_DATE_TC OTH_ACT_COST_TO_DATE_TC
, OTH_ACT_COST_TO_DATE_FC OTH_ACT_COST_TO_DATE_FC
, OTH_ACT_COST_TO_DATE_PC OTH_ACT_COST_TO_DATE_PC
, OTH_ETC_COST_TC OTH_ETC_COST_TC
, OTH_ETC_COST_FC OTH_ETC_COST_FC
, OTH_ETC_COST_PC OTH_ETC_COST_PC
, PPL_ACT_COST_TO_DATE_TC PPL_ACT_COST_TO_DATE_TC
, PPL_ACT_COST_TO_DATE_FC PPL_ACT_COST_TO_DATE_FC
, PPL_ACT_COST_TO_DATE_PC PPL_ACT_COST_TO_DATE_PC
, PPL_ETC_COST_TC PPL_ETC_COST_TC
, PPL_ETC_COST_FC PPL_ETC_COST_FC
, PPL_ETC_COST_PC PPL_ETC_COST_PC
, EQPMT_ACT_COST_TO_DATE_TC EQPMT_ACT_COST_TO_DATE_TC
, EQPMT_ACT_COST_TO_DATE_FC EQPMT_ACT_COST_TO_DATE_FC
, EQPMT_ACT_COST_TO_DATE_PC EQPMT_ACT_COST_TO_DATE_PC
, EQPMT_ETC_COST_TC EQPMT_ETC_COST_TC
, EQPMT_ETC_COST_FC EQPMT_ETC_COST_FC
, EQPMT_ETC_COST_PC EQPMT_ETC_COST_PC
, EARNED_VALUE EARNED_VALUE
, TASK_WT_BASIS_CODE TASK_WT_BASIS_CODE
, SUBPRJ_PPL_ACT_EFFORT SUBPRJ_PPL_ACT_EFFORT
, SUBPRJ_EQPMT_ACT_EFFORT SUBPRJ_EQPMT_ACT_EFFORT
, SUBPRJ_PPL_ETC_EFFORT SUBPRJ_PPL_ETC_EFFORT
, SUBPRJ_EQPMT_ETC_EFFORT SUBPRJ_EQPMT_ETC_EFFORT
, SUBPRJ_PPL_ACT_COST_TC SUBPRJ_PPL_ACT_COST_TC
, SUBPRJ_PPL_ACT_COST_FC SUBPRJ_PPL_ACT_COST_FC
, SUBPRJ_PPL_ACT_COST_PC SUBPRJ_PPL_ACT_COST_PC
, SUBPRJ_EQPMT_ACT_COST_TC SUBPRJ_EQPMT_ACT_COST_TC
, SUBPRJ_EQPMT_ACT_COST_FC SUBPRJ_EQPMT_ACT_COST_FC
, SUBPRJ_EQPMT_ACT_COST_PC SUBPRJ_EQPMT_ACT_COST_PC
, SUBPRJ_OTH_ETC_COST_TC SUBPRJ_OTH_ETC_COST_TC
, SUBPRJ_OTH_ETC_COST_FC SUBPRJ_OTH_ETC_COST_FC
, SUBPRJ_OTH_ETC_COST_PC SUBPRJ_OTH_ETC_COST_PC
, SUBPRJ_PPL_ETC_COST_TC SUBPRJ_PPL_ETC_COST_TC
, SUBPRJ_PPL_ETC_COST_FC SUBPRJ_PPL_ETC_COST_FC
, SUBPRJ_PPL_ETC_COST_PC SUBPRJ_PPL_ETC_COST_PC
, SUBPRJ_EQPMT_ETC_COST_TC SUBPRJ_EQPMT_ETC_COST_TC
, SUBPRJ_EQPMT_ETC_COST_FC SUBPRJ_EQPMT_ETC_COST_FC
, SUBPRJ_EQPMT_ETC_COST_PC SUBPRJ_EQPMT_ETC_COST_PC
, SUBPRJ_EARNED_VALUE SUBPRJ_EARNED_VALUE
, CURRENT_FLAG CURRENT_FLAG
, PROJFUNC_COST_RATE_TYPE PROJFUNC_COST_RATE_TYPE
, PROJFUNC_COST_EXCHANGE_RATE PROJFUNC_COST_EXCHANGE_RATE
, PROJFUNC_COST_RATE_DATE PROJFUNC_COST_RATE_DATE
, PROJ_COST_RATE_TYPE PROJ_COST_RATE_TYPE
, PROJ_COST_EXCHANGE_RATE PROJ_COST_EXCHANGE_RATE
, PROJ_COST_RATE_DATE PROJ_COST_RATE_DATE
, TXN_CURRENCY_CODE TXN_CURRENCY_CODE
, PROG_PA_PERIOD_NAME PROG_PA_PERIOD_NAME
, PROG_GL_PERIOD_NAME PROG_GL_PERIOD_NAME
, OTH_QUANTITY_TO_DATE OTH_QUANTITY_TO_DATE
, OTH_ETC_QUANTITY OTH_ETC_QUANTITY
, OTH_ACT_RAWCOST_TO_DATE_TC OTH_ACT_RAWCOST_TO_DATE_TC
, OTH_ACT_RAWCOST_TO_DATE_FC OTH_ACT_RAWCOST_TO_DATE_FC
, OTH_ACT_RAWCOST_TO_DATE_PC OTH_ACT_RAWCOST_TO_DATE_PC
, OTH_ETC_RAWCOST_TC OTH_ETC_RAWCOST_TC
, OTH_ETC_RAWCOST_FC OTH_ETC_RAWCOST_FC
, OTH_ETC_RAWCOST_PC OTH_ETC_RAWCOST_PC
, PPL_ACT_RAWCOST_TO_DATE_TC PPL_ACT_RAWCOST_TO_DATE_TC
, PPL_ACT_RAWCOST_TO_DATE_FC PPL_ACT_RAWCOST_TO_DATE_FC
, PPL_ACT_RAWCOST_TO_DATE_PC PPL_ACT_RAWCOST_TO_DATE_PC
, PPL_ETC_RAWCOST_TC PPL_ETC_RAWCOST_TC
, PPL_ETC_RAWCOST_FC PPL_ETC_RAWCOST_FC
, PPL_ETC_RAWCOST_PC PPL_ETC_RAWCOST_PC
, EQPMT_ACT_RAWCOST_TO_DATE_TC EQPMT_ACT_RAWCOST_TO_DATE_TC
, EQPMT_ACT_RAWCOST_TO_DATE_FC EQPMT_ACT_RAWCOST_TO_DATE_FC
, EQPMT_ACT_RAWCOST_TO_DATE_PC EQPMT_ACT_RAWCOST_TO_DATE_PC
, EQPMT_ETC_RAWCOST_TC EQPMT_ETC_RAWCOST_TC
, EQPMT_ETC_RAWCOST_FC EQPMT_ETC_RAWCOST_FC
, EQPMT_ETC_RAWCOST_PC EQPMT_ETC_RAWCOST_PC
, SUBPRJ_PPL_ACT_RAWCOST_TC SUBPRJ_PPL_ACT_RAWCOST_TC
, SUBPRJ_PPL_ACT_RAWCOST_FC SUBPRJ_PPL_ACT_RAWCOST_FC
, SUBPRJ_PPL_ACT_RAWCOST_PC SUBPRJ_PPL_ACT_RAWCOST_PC
, SUBPRJ_EQPMT_ACT_RAWCOST_TC SUBPRJ_EQPMT_ACT_RAWCOST_TC
, SUBPRJ_EQPMT_ACT_RAWCOST_FC SUBPRJ_EQPMT_ACT_RAWCOST_FC
, SUBPRJ_EQPMT_ACT_RAWCOST_PC SUBPRJ_EQPMT_ACT_RAWCOST_PC
, SUBPRJ_OTH_ETC_RAWCOST_TC SUBPRJ_OTH_ETC_RAWCOST_TC
, SUBPRJ_OTH_ETC_RAWCOST_FC SUBPRJ_OTH_ETC_RAWCOST_FC
, SUBPRJ_OTH_ETC_RAWCOST_PC SUBPRJ_OTH_ETC_RAWCOST_PC
, SUBPRJ_PPL_ETC_RAWCOST_TC SUBPRJ_PPL_ETC_RAWCOST_TC
, SUBPRJ_PPL_ETC_RAWCOST_FC SUBPRJ_PPL_ETC_RAWCOST_FC
, SUBPRJ_PPL_ETC_RAWCOST_PC SUBPRJ_PPL_ETC_RAWCOST_PC
, SUBPRJ_EQPMT_ETC_RAWCOST_TC SUBPRJ_EQPMT_ETC_RAWCOST_TC
, SUBPRJ_EQPMT_ETC_RAWCOST_FC SUBPRJ_EQPMT_ETC_RAWCOST_FC
, SUBPRJ_EQPMT_ETC_RAWCOST_PC SUBPRJ_EQPMT_ETC_RAWCOST_PC
, SUBPRJ_OTH_ACT_COST_TO_DT_TC SUBPRJ_OTH_ACT_COST_TO_DT_TC
, SUBPRJ_OTH_ACT_COST_TO_DT_FC SUBPRJ_OTH_ACT_COST_TO_DT_FC
, SUBPRJ_OTH_ACT_COST_TO_DT_PC SUBPRJ_OTH_ACT_COST_TO_DT_PC
, SPJ_OTH_ACT_RAWCOST_TO_DT_TC SPJ_OTH_ACT_RAWCOST_TO_DT_TC
, SPJ_OTH_ACT_RAWCOST_TO_DT_FC SPJ_OTH_ACT_RAWCOST_TO_DT_FC
, SPJ_OTH_ACT_RAWCOST_TO_DT_PC SPJ_OTH_ACT_RAWCOST_TO_DT_PC
, CBS_ELEMENT_ID CBS_ELEMENT_ID
FROM "PA"."PA_PROGRESS_ROLLUP"