[Home] [Help] [Dependency Information]
Object Name: | PA_PROGRESS_ROLLUP# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROGRESS_ROLLUP_ID | NUMBER | (15) | Yes | |
PERCENT_COMPLETE_ID | NUMBER | (15) | ||
PROJECT_ID | NUMBER | (15) | Yes | |
OBJECT_ID | NUMBER | (15) | Yes | |
OBJECT_TYPE | VARCHAR2 | (30) | Yes | |
AS_OF_DATE | DATE | Yes | ||
OBJECT_VERSION_ID | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
PROGRESS_STATUS_CODE | VARCHAR2 | (150) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
INCREMENTAL_WORK_QUANTITY | NUMBER | (17) | ||
CUMULATIVE_WORK_QUANTITY | NUMBER | (17) | ||
BASE_PERCENT_COMPLETE | NUMBER | |||
EFF_ROLLUP_PERCENT_COMP | NUMBER | |||
COMPLETED_PERCENTAGE | NUMBER | |||
ESTIMATED_START_DATE | DATE | |||
ESTIMATED_FINISH_DATE | DATE | |||
ACTUAL_START_DATE | DATE | |||
ACTUAL_FINISH_DATE | DATE | |||
ESTIMATED_REMAINING_EFFORT | NUMBER | (17) | ||
RECORD_VERSION_NUMBER | NUMBER | (15) | ||
BASE_PERCENT_COMP_DERIV_CODE | VARCHAR2 | (30) | ||
BASE_PROGRESS_STATUS_CODE | VARCHAR2 | (150) | ||
EFF_ROLLUP_PROG_STAT_CODE | VARCHAR2 | (150) | ||
STRUCTURE_TYPE | VARCHAR2 | (30) | ||
PROJ_ELEMENT_ID | NUMBER | (15) | ||
STRUCTURE_VERSION_ID | NUMBER | (15) | ||
PPL_ACT_EFFORT_TO_DATE | NUMBER | |||
EQPMT_ACT_EFFORT_TO_DATE | NUMBER | |||
EQPMT_ETC_EFFORT | NUMBER | |||
OTH_ACT_COST_TO_DATE_TC | NUMBER | |||
OTH_ACT_COST_TO_DATE_FC | NUMBER | |||
OTH_ACT_COST_TO_DATE_PC | NUMBER | |||
OTH_ETC_COST_TC | NUMBER | |||
OTH_ETC_COST_FC | NUMBER | |||
OTH_ETC_COST_PC | NUMBER | |||
PPL_ACT_COST_TO_DATE_TC | NUMBER | |||
PPL_ACT_COST_TO_DATE_FC | NUMBER | |||
PPL_ACT_COST_TO_DATE_PC | NUMBER | |||
PPL_ETC_COST_TC | NUMBER | |||
PPL_ETC_COST_FC | NUMBER | |||
PPL_ETC_COST_PC | NUMBER | |||
EQPMT_ACT_COST_TO_DATE_TC | NUMBER | |||
EQPMT_ACT_COST_TO_DATE_FC | NUMBER | |||
EQPMT_ACT_COST_TO_DATE_PC | NUMBER | |||
EQPMT_ETC_COST_TC | NUMBER | |||
EQPMT_ETC_COST_FC | NUMBER | |||
EQPMT_ETC_COST_PC | NUMBER | |||
EARNED_VALUE | NUMBER | |||
TASK_WT_BASIS_CODE | VARCHAR2 | (30) | ||
SUBPRJ_PPL_ACT_EFFORT | NUMBER | |||
SUBPRJ_EQPMT_ACT_EFFORT | NUMBER | |||
SUBPRJ_PPL_ETC_EFFORT | NUMBER | |||
SUBPRJ_EQPMT_ETC_EFFORT | NUMBER | |||
SUBPRJ_PPL_ACT_COST_TC | NUMBER | |||
SUBPRJ_PPL_ACT_COST_FC | NUMBER | |||
SUBPRJ_PPL_ACT_COST_PC | NUMBER | |||
SUBPRJ_EQPMT_ACT_COST_TC | NUMBER | |||
SUBPRJ_EQPMT_ACT_COST_FC | NUMBER | |||
SUBPRJ_EQPMT_ACT_COST_PC | NUMBER | |||
SUBPRJ_OTH_ETC_COST_TC | NUMBER | |||
SUBPRJ_OTH_ETC_COST_FC | NUMBER | |||
SUBPRJ_OTH_ETC_COST_PC | NUMBER | |||
SUBPRJ_PPL_ETC_COST_TC | NUMBER | |||
SUBPRJ_PPL_ETC_COST_FC | NUMBER | |||
SUBPRJ_PPL_ETC_COST_PC | NUMBER | |||
SUBPRJ_EQPMT_ETC_COST_TC | NUMBER | |||
SUBPRJ_EQPMT_ETC_COST_FC | NUMBER | |||
SUBPRJ_EQPMT_ETC_COST_PC | NUMBER | |||
SUBPRJ_EARNED_VALUE | NUMBER | |||
CURRENT_FLAG | VARCHAR2 | (1) | ||
PROJFUNC_COST_RATE_TYPE | VARCHAR2 | (30) | ||
PROJFUNC_COST_EXCHANGE_RATE | NUMBER | |||
PROJFUNC_COST_RATE_DATE | DATE | |||
PROJ_COST_RATE_TYPE | VARCHAR2 | (30) | ||
PROJ_COST_EXCHANGE_RATE | NUMBER | |||
PROJ_COST_RATE_DATE | DATE | |||
TXN_CURRENCY_CODE | VARCHAR2 | (15) | ||
PROG_PA_PERIOD_NAME | VARCHAR2 | (30) | ||
PROG_GL_PERIOD_NAME | VARCHAR2 | (30) | ||
OTH_QUANTITY_TO_DATE | NUMBER | |||
OTH_ETC_QUANTITY | NUMBER | |||
OTH_ACT_RAWCOST_TO_DATE_TC | NUMBER | |||
OTH_ACT_RAWCOST_TO_DATE_FC | NUMBER | |||
OTH_ACT_RAWCOST_TO_DATE_PC | NUMBER | |||
OTH_ETC_RAWCOST_TC | NUMBER | |||
OTH_ETC_RAWCOST_FC | NUMBER | |||
OTH_ETC_RAWCOST_PC | NUMBER | |||
PPL_ACT_RAWCOST_TO_DATE_TC | NUMBER | |||
PPL_ACT_RAWCOST_TO_DATE_FC | NUMBER | |||
PPL_ACT_RAWCOST_TO_DATE_PC | NUMBER | |||
PPL_ETC_RAWCOST_TC | NUMBER | |||
PPL_ETC_RAWCOST_FC | NUMBER | |||
PPL_ETC_RAWCOST_PC | NUMBER | |||
EQPMT_ACT_RAWCOST_TO_DATE_TC | NUMBER | |||
EQPMT_ACT_RAWCOST_TO_DATE_FC | NUMBER | |||
EQPMT_ACT_RAWCOST_TO_DATE_PC | NUMBER | |||
EQPMT_ETC_RAWCOST_TC | NUMBER | |||
EQPMT_ETC_RAWCOST_FC | NUMBER | |||
EQPMT_ETC_RAWCOST_PC | NUMBER | |||
SUBPRJ_PPL_ACT_RAWCOST_TC | NUMBER | |||
SUBPRJ_PPL_ACT_RAWCOST_FC | NUMBER | |||
SUBPRJ_PPL_ACT_RAWCOST_PC | NUMBER | |||
SUBPRJ_EQPMT_ACT_RAWCOST_TC | NUMBER | |||
SUBPRJ_EQPMT_ACT_RAWCOST_FC | NUMBER | |||
SUBPRJ_EQPMT_ACT_RAWCOST_PC | NUMBER | |||
SUBPRJ_OTH_ETC_RAWCOST_TC | NUMBER | |||
SUBPRJ_OTH_ETC_RAWCOST_FC | NUMBER | |||
SUBPRJ_OTH_ETC_RAWCOST_PC | NUMBER | |||
SUBPRJ_PPL_ETC_RAWCOST_TC | NUMBER | |||
SUBPRJ_PPL_ETC_RAWCOST_FC | NUMBER | |||
SUBPRJ_PPL_ETC_RAWCOST_PC | NUMBER | |||
SUBPRJ_EQPMT_ETC_RAWCOST_TC | NUMBER | |||
SUBPRJ_EQPMT_ETC_RAWCOST_FC | NUMBER | |||
SUBPRJ_EQPMT_ETC_RAWCOST_PC | NUMBER | |||
SUBPRJ_OTH_ACT_COST_TO_DT_TC | NUMBER | |||
SUBPRJ_OTH_ACT_COST_TO_DT_FC | NUMBER | |||
SUBPRJ_OTH_ACT_COST_TO_DT_PC | NUMBER | |||
SPJ_OTH_ACT_RAWCOST_TO_DT_TC | NUMBER | |||
SPJ_OTH_ACT_RAWCOST_TO_DT_FC | NUMBER | |||
SPJ_OTH_ACT_RAWCOST_TO_DT_PC | NUMBER | |||
CBS_ELEMENT_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT PROGRESS_ROLLUP_ID
, PERCENT_COMPLETE_ID
, PROJECT_ID
, OBJECT_ID
, OBJECT_TYPE
, AS_OF_DATE
, OBJECT_VERSION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, PROGRESS_STATUS_CODE
, LAST_UPDATE_LOGIN
, INCREMENTAL_WORK_QUANTITY
, CUMULATIVE_WORK_QUANTITY
, BASE_PERCENT_COMPLETE
, EFF_ROLLUP_PERCENT_COMP
, COMPLETED_PERCENTAGE
, ESTIMATED_START_DATE
, ESTIMATED_FINISH_DATE
, ACTUAL_START_DATE
, ACTUAL_FINISH_DATE
, ESTIMATED_REMAINING_EFFORT
, RECORD_VERSION_NUMBER
, BASE_PERCENT_COMP_DERIV_CODE
, BASE_PROGRESS_STATUS_CODE
, EFF_ROLLUP_PROG_STAT_CODE
, STRUCTURE_TYPE
, PROJ_ELEMENT_ID
, STRUCTURE_VERSION_ID
, PPL_ACT_EFFORT_TO_DATE
, EQPMT_ACT_EFFORT_TO_DATE
, EQPMT_ETC_EFFORT
, OTH_ACT_COST_TO_DATE_TC
, OTH_ACT_COST_TO_DATE_FC
, OTH_ACT_COST_TO_DATE_PC
, OTH_ETC_COST_TC
, OTH_ETC_COST_FC
, OTH_ETC_COST_PC
, PPL_ACT_COST_TO_DATE_TC
, PPL_ACT_COST_TO_DATE_FC
, PPL_ACT_COST_TO_DATE_PC
, PPL_ETC_COST_TC
, PPL_ETC_COST_FC
, PPL_ETC_COST_PC
, EQPMT_ACT_COST_TO_DATE_TC
, EQPMT_ACT_COST_TO_DATE_FC
, EQPMT_ACT_COST_TO_DATE_PC
, EQPMT_ETC_COST_TC
, EQPMT_ETC_COST_FC
, EQPMT_ETC_COST_PC
, EARNED_VALUE
, TASK_WT_BASIS_CODE
, SUBPRJ_PPL_ACT_EFFORT
, SUBPRJ_EQPMT_ACT_EFFORT
, SUBPRJ_PPL_ETC_EFFORT
, SUBPRJ_EQPMT_ETC_EFFORT
, SUBPRJ_PPL_ACT_COST_TC
, SUBPRJ_PPL_ACT_COST_FC
, SUBPRJ_PPL_ACT_COST_PC
, SUBPRJ_EQPMT_ACT_COST_TC
, SUBPRJ_EQPMT_ACT_COST_FC
, SUBPRJ_EQPMT_ACT_COST_PC
, SUBPRJ_OTH_ETC_COST_TC
, SUBPRJ_OTH_ETC_COST_FC
, SUBPRJ_OTH_ETC_COST_PC
, SUBPRJ_PPL_ETC_COST_TC
, SUBPRJ_PPL_ETC_COST_FC
, SUBPRJ_PPL_ETC_COST_PC
, SUBPRJ_EQPMT_ETC_COST_TC
, SUBPRJ_EQPMT_ETC_COST_FC
, SUBPRJ_EQPMT_ETC_COST_PC
, SUBPRJ_EARNED_VALUE
, CURRENT_FLAG
, PROJFUNC_COST_RATE_TYPE
, PROJFUNC_COST_EXCHANGE_RATE
, PROJFUNC_COST_RATE_DATE
, PROJ_COST_RATE_TYPE
, PROJ_COST_EXCHANGE_RATE
, PROJ_COST_RATE_DATE
, TXN_CURRENCY_CODE
, PROG_PA_PERIOD_NAME
, PROG_GL_PERIOD_NAME
, OTH_QUANTITY_TO_DATE
, OTH_ETC_QUANTITY
, OTH_ACT_RAWCOST_TO_DATE_TC
, OTH_ACT_RAWCOST_TO_DATE_FC
, OTH_ACT_RAWCOST_TO_DATE_PC
, OTH_ETC_RAWCOST_TC
, OTH_ETC_RAWCOST_FC
, OTH_ETC_RAWCOST_PC
, PPL_ACT_RAWCOST_TO_DATE_TC
, PPL_ACT_RAWCOST_TO_DATE_FC
, PPL_ACT_RAWCOST_TO_DATE_PC
, PPL_ETC_RAWCOST_TC
, PPL_ETC_RAWCOST_FC
, PPL_ETC_RAWCOST_PC
, EQPMT_ACT_RAWCOST_TO_DATE_TC
, EQPMT_ACT_RAWCOST_TO_DATE_FC
, EQPMT_ACT_RAWCOST_TO_DATE_PC
, EQPMT_ETC_RAWCOST_TC
, EQPMT_ETC_RAWCOST_FC
, EQPMT_ETC_RAWCOST_PC
, SUBPRJ_PPL_ACT_RAWCOST_TC
, SUBPRJ_PPL_ACT_RAWCOST_FC
, SUBPRJ_PPL_ACT_RAWCOST_PC
, SUBPRJ_EQPMT_ACT_RAWCOST_TC
, SUBPRJ_EQPMT_ACT_RAWCOST_FC
, SUBPRJ_EQPMT_ACT_RAWCOST_PC
, SUBPRJ_OTH_ETC_RAWCOST_TC
, SUBPRJ_OTH_ETC_RAWCOST_FC
, SUBPRJ_OTH_ETC_RAWCOST_PC
, SUBPRJ_PPL_ETC_RAWCOST_TC
, SUBPRJ_PPL_ETC_RAWCOST_FC
, SUBPRJ_PPL_ETC_RAWCOST_PC
, SUBPRJ_EQPMT_ETC_RAWCOST_TC
, SUBPRJ_EQPMT_ETC_RAWCOST_FC
, SUBPRJ_EQPMT_ETC_RAWCOST_PC
, SUBPRJ_OTH_ACT_COST_TO_DT_TC
, SUBPRJ_OTH_ACT_COST_TO_DT_FC
, SUBPRJ_OTH_ACT_COST_TO_DT_PC
, SPJ_OTH_ACT_RAWCOST_TO_DT_TC
, SPJ_OTH_ACT_RAWCOST_TO_DT_FC
, SPJ_OTH_ACT_RAWCOST_TO_DT_PC
, CBS_ELEMENT_ID
FROM PA.PA_PROGRESS_ROLLUP#;
|
|
|