DBA Data[Home] [Help] [Dependency Information]

VIEW: PA.PA_PROGRESS_ROLLUP#

Object Details
Object Name: PA_PROGRESS_ROLLUP#
Object Type: VIEW
Owner: PA
Subobject Name:
Status: VALID

[View Source]

Columns
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)
Query Text

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#;

Dependencies

[top of page]

PA.PA_PROGRESS_ROLLUP# references the following:

SchemaPA
TablePA_PROGRESS_ROLLUP
PA.PA_PROGRESS_ROLLUP# is referenced by following:

SchemaAPPS
SynonymPA_PROGRESS_ROLLUP