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


TABLE: PA.PA_PROJ_ROLLUP_BULK_TEMP

Object Details
Object Name: PA_PROJ_ROLLUP_BULK_TEMP
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_PROJ_ROLLUP_BULK_TEMP
Subobject Name:
Status: VALID


This table is used to generate schedules for sets of dates in a project. Records are deleted from the table at the end of the user session.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_PROJ_ROLLUP_BULK_TEMP_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROCESS_NUMBER
ColumnOBJECT_TYPE
ColumnOBJECT_ID
PA_PROJ_ROLLUP_BULK_TEMP_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROCESS_NUMBER
ColumnPARENT_OBJECT_TYPE
ColumnPARENT_OBJECT_ID
Columns
Name Datatype Length Mandatory Comments
PROCESS_NUMBER NUMBER
Yes Process number for generating a schedule
OBJECT_ID NUMBER (15) Yes Object ID of the object to be processed
OBJECT_TYPE VARCHAR2 (30) Yes Object type for the processed object
PARENT_OBJECT_ID NUMBER (15)
The parent ID for the processed object ID
PARENT_OBJECT_TYPE VARCHAR2 (30)
The parent type for the processed object ID
CALENDAR_ID NUMBER (15)
The calendar ID for the processed object
CONSTRAINT_TYPE_CODE VARCHAR2 (1)
The constraint type for the processed object
CONSTRAINT_DATE DATE

The constraint date for the processed object
WBS_LEVEL NUMBER
Yes The WBS level for the processed object
START_DATE1 DATE

The start date for data set 1
START_DATE_OVERRIDE1 DATE

The override start date for data set 1
FINISH_DATE1 DATE

The finish date for data set 1
DURATION1 NUMBER

The duration for data set 1
TASK_STATUS1 NUMBER

The task status for data set 1
PROGRESS_STATUS_WEIGHT1 NUMBER

The progress status weight for data set 1
PROGRESS_OVERRIDE1 NUMBER

The progress status override for data set 1
REMAINING_EFFORT1 NUMBER

The estimated remaining effort for data set 1
PERCENT_COMPLETE1 NUMBER

The percent complete for data set 1
PERCENT_OVERRIDE1 NUMBER

The percent complete override for data set 1
TASK_WEIGHT1 NUMBER

The task weight for data set 1
NUMBER_FIELD1 NUMBER

The number field for data set 1
ROLLUP_NODE1 VARCHAR2 (1)
The rollup node flag for data set 1
DIRTY_FLAG1 VARCHAR2 (1)
The process dirty flag for data set 1
ETC_COST1 NUMBER

The estimate to complete cost for data set 1
PPL_ETC_COST1 NUMBER

The estimate to complete cost for people for data set 1
EQPMT_ETC_COST1 NUMBER

The estimate to complete cost for equipment for data set 1
PPL_UNPLAND_EFFORT1 NUMBER

The unplanned effort for people for data set 1
EQPMT_ETC_EFFORT1 NUMBER

The estimate to complete effort for equipment for data set 1
SUB_PRJ_ETC_COST1 NUMBER

The estimate to complete cost for subprojects for data set 1
SUB_PRJ_PPL_ETC_COST1 NUMBER

The subproject estimate to complete cost for people for data set 1
SUB_PRJ_EQPMT_ETC_COST1 NUMBER

The subproject estimate to complete cost for equipment for data set 1
SUB_PRJ_PPL_ETC_EFFORT1 NUMBER

The subproject estimate to complete effort for people for data set 1
SUB_PRJ_EQPMT_ETC_EFFORT1 NUMBER

The subproject estimate to complete effort for equipment for data set 1
EARNED_VALUE1 NUMBER

The actual or earned value for data set 1
BAC_VALUE1 NUMBER

The planned value or budget at completion (BAC) value for data set 1
PERC_COMP_DERIVATIVE_CODE1 VARCHAR2 (30)
The percentage derivative code for data set 1
START_DATE2 DATE

The start date for data set 2
START_DATE_OVERRIDE2 DATE

The override start date for data set 2
FINISH_DATE2 DATE

The finish date for data set 2
DURATION2 NUMBER

The duration for data set 2
TASK_STATUS2 NUMBER

The task status for data set 2
PROGRESS_STATUS_WEIGHT2 NUMBER

The progress status weight for data set 2
PROGRESS_OVERRIDE2 NUMBER

The progress status override for data set 2
REMAINING_EFFORT2 NUMBER

The estimated remaining effort for data set 2
PERCENT_COMPLETE2 NUMBER

The percent complete for data set 2
PERCENT_OVERRIDE2 NUMBER

The percent complete override for data set 2
TASK_WEIGHT2 NUMBER

The task weight for data set 2
NUMBER_FIELD2 NUMBER

The number field for data set 2
ROLLUP_NODE2 VARCHAR2 (1)
The rollup node flag for data set 2
DIRTY_FLAG2 VARCHAR2 (1)
The process dirty flag for data set 2
ETC_COST2 NUMBER

The estimate to complete cost for data set 2
PPL_ETC_COST2 NUMBER

The estimate to complete cost for people for data set 2
EQPMT_ETC_COST2 NUMBER

The estimate to complete cost for equipment for data set 2
PPL_UNPLAND_EFFORT2 NUMBER

The unplanned effort for people for data set 2
EQPMT_ETC_EFFORT2 NUMBER

The estimate to complete effort for equipment for data set 2
SUB_PRJ_ETC_COST2 NUMBER

The estimate to complete cost for subprojects for data set 2
SUB_PRJ_PPL_ETC_COST2 NUMBER

The subproject estimate to complete cost for people for data set 2
SUB_PRJ_EQPMT_ETC_COST2 NUMBER

The subproject estimate to complete cost for equipment for data set 2
SUB_PRJ_PPL_ETC_EFFORT2 NUMBER

The subproject estimate to complete effort for people for data set 2
SUB_PRJ_EQPMT_ETC_EFFORT2 NUMBER

The subproject estimate to complete effort for equipment for data set 2
EARNED_VALUE2 NUMBER

The actual or earned value for data set 2
BAC_VALUE2 NUMBER

The planned value or budget at completion (BAC) value for data set 2
PERC_COMP_DERIVATIVE_CODE2 VARCHAR2 (30)
The percentage derivative code for data set 2
START_DATE3 DATE

The start date for data set 3
START_DATE_OVERRIDE3 DATE

The override start date for data set 3
FINISH_DATE3 DATE

The finish date for data set 3
DURATION3 NUMBER

The duration for data set 3
TASK_STATUS3 NUMBER

The task status for data set 3
PROGRESS_STATUS_WEIGHT3 NUMBER

The progress status weight for data set 3
PROGRESS_OVERRIDE3 NUMBER

The progress status override for data set 3
REMAINING_EFFORT3 NUMBER

The estimated remaining effort for data set 3
PERCENT_COMPLETE3 NUMBER

The percent complete for data set 3
PERCENT_OVERRIDE3 NUMBER

The percent complete override for data set 3
TASK_WEIGHT3 NUMBER

The task weight for data set 3
NUMBER_FIELD3 NUMBER

The number field for data set 3
ROLLUP_NODE3 VARCHAR2 (1)
The rollup node flag for data set 3
DIRTY_FLAG3 VARCHAR2 (1)
The process dirty flag for data set 3
ETC_COST3 NUMBER

The estimate to complete cost for data set 3
PPL_ETC_COST3 NUMBER

The estimate to complete cost for people for data set 3
EQPMT_ETC_COST3 NUMBER

The estimate to complete cost for equipment for data set 3
PPL_UNPLAND_EFFORT3 NUMBER

The unplanned effort for people for data set 3
EQPMT_ETC_EFFORT3 NUMBER

The estimate to complete effort for equipment for data set 3
SUB_PRJ_ETC_COST3 NUMBER

The estimate to complete cost for subprojects for data set 3
SUB_PRJ_PPL_ETC_COST3 NUMBER

The subproject estimate to complete cost for people for data set 3
SUB_PRJ_EQPMT_ETC_COST3 NUMBER

The subproject estimate to complete cost for equipment for data set 3
SUB_PRJ_PPL_ETC_EFFORT3 NUMBER

The subproject estimate to complete effort for people for data set 3
SUB_PRJ_EQPMT_ETC_EFFORT3 NUMBER

The subproject estimate to complete effort for equipment for data set 3
EARNED_VALUE3 NUMBER

The actual or earned value for data set 3
BAC_VALUE3 NUMBER

The planned value or budget at completion (BAC) value for data set 3
PERC_COMP_DERIVATIVE_CODE3 VARCHAR2 (30)
The percentage derivative code for data set 3
START_DATE4 DATE

The start date for data set 4
START_DATE_OVERRIDE4 DATE

The override start date for data set 4
FINISH_DATE4 DATE

The finish date for data set 4
DURATION4 NUMBER

The duration for data set 4
TASK_STATUS4 NUMBER

The task status for data set 4
PROGRESS_STATUS_WEIGHT4 NUMBER

The progress status weight for data set 4
PROGRESS_OVERRIDE4 NUMBER

The progress status override for data set 4
REMAINING_EFFORT4 NUMBER

The estimated remaining effort for data set 4
PERCENT_COMPLETE4 NUMBER

The percent complete for data set 4
PERCENT_OVERRIDE4 NUMBER

The percent complete override for data set 4
TASK_WEIGHT4 NUMBER

The task weight for data set 4
NUMBER_FIELD4 NUMBER

The number field for data set 4
ROLLUP_NODE4 VARCHAR2 (1)
The rollup node flag for data set 4
DIRTY_FLAG4 VARCHAR2 (1)
The process dirty flag for data set 4
ETC_COST4 NUMBER

The estimate to complete cost for data set 4
PPL_ETC_COST4 NUMBER

The estimate to complete cost for people for data set 4
EQPMT_ETC_COST4 NUMBER

The estimate to complete cost for equipment for data set 4
PPL_UNPLAND_EFFORT4 NUMBER

The unplanned effort for people for data set 4
EQPMT_ETC_EFFORT4 NUMBER

The estimate to complete effort for equipment for data set 4
SUB_PRJ_ETC_COST4 NUMBER

The estimate to complete cost for subprojects for data set 4
SUB_PRJ_PPL_ETC_COST4 NUMBER

The subproject estimate to complete cost for people for data set 4
SUB_PRJ_EQPMT_ETC_COST4 NUMBER

The subproject estimate to complete cost for equipment for data set 4
SUB_PRJ_PPL_ETC_EFFORT4 NUMBER

The subproject estimate to complete effort for people for data set 4
SUB_PRJ_EQPMT_ETC_EFFORT4 NUMBER

The subproject estimate to complete effort for equipment for data set 4
EARNED_VALUE4 NUMBER

The actual or earned value for data set 4
BAC_VALUE4 NUMBER

The planned value or budget at completion (BAC) value for data set 4
PERC_COMP_DERIVATIVE_CODE4 VARCHAR2 (30)
The percentage derivative code for data set 4
START_DATE5 DATE

The start date for data set 5
START_DATE_OVERRIDE5 DATE

The override start date for data set 5
FINISH_DATE5 DATE

The finish date for data set 5
DURATION5 NUMBER

The duration for data set 5
TASK_STATUS5 NUMBER

The task status for data set 5
PROGRESS_STATUS_WEIGHT5 NUMBER

The progress status weight for data set 5
PROGRESS_OVERRIDE5 NUMBER

The progress status override for data set 5
REMAINING_EFFORT5 NUMBER

The estimated remaining effort for data set 5
PERCENT_COMPLETE5 NUMBER

The percent complete for data set 5
PERCENT_OVERRIDE5 NUMBER

The percent complete override for data set 5
TASK_WEIGHT5 NUMBER

The task weight for data set 5
NUMBER_FIELD5 NUMBER

The number field for data set 5
ROLLUP_NODE5 VARCHAR2 (1)
The rollup node flag for data set 5
DIRTY_FLAG5 VARCHAR2 (1)
The process dirty flag for data set 5
ETC_COST5 NUMBER

The estimate to complete cost for data set 5
PPL_ETC_COST5 NUMBER

The estimate to complete cost for people for data set 5
EQPMT_ETC_COST5 NUMBER

The estimate to complete cost for equipment for data set 5
PPL_UNPLAND_EFFORT5 NUMBER

The unplanned effort for people for data set 5
EQPMT_ETC_EFFORT5 NUMBER

The estimate to complete effort for equipment for data set 5
SUB_PRJ_ETC_COST5 NUMBER

The estimate to complete cost for subprojects for data set 5
SUB_PRJ_PPL_ETC_COST5 NUMBER

The subproject estimate to complete cost for people for data set 5
SUB_PRJ_EQPMT_ETC_COST5 NUMBER

The subproject estimate to complete cost for equipment for data set 5
SUB_PRJ_PPL_ETC_EFFORT5 NUMBER

The subproject estimate to complete effort for people for data set 5
SUB_PRJ_EQPMT_ETC_EFFORT5 NUMBER

The subproject estimate to complete effort for equipment for data set 5
EARNED_VALUE5 NUMBER

The actual or earned value for data set 5
BAC_VALUE5 NUMBER

The planned value or budget at completion (BAC) value for data set 5
PERC_COMP_DERIVATIVE_CODE5 VARCHAR2 (30)
The percentage derivative code for data set 5
START_DATE6 DATE

The start date for data set 6
START_DATE_OVERRIDE6 DATE

The override start date for data set 6
FINISH_DATE6 DATE

The finish date for data set 6
DURATION6 NUMBER

The duration for data set 6
TASK_STATUS6 NUMBER

The task status for data set 6
PROGRESS_STATUS_WEIGHT6 NUMBER

The progress status weight for data set 6
PROGRESS_OVERRIDE6 NUMBER

The progress status override for data set 6
REMAINING_EFFORT6 NUMBER

The estimated remaining effort for data set 6
PERCENT_COMPLETE6 NUMBER

The percent complete for data set 6
PERCENT_OVERRIDE6 NUMBER

The percent complete override for data set 6
TASK_WEIGHT6 NUMBER

The task weight for data set 6
NUMBER_FIELD6 NUMBER

The number field for data set 6
ROLLUP_NODE6 VARCHAR2 (1)
The rollup node flag for data set 6
DIRTY_FLAG6 VARCHAR2 (1)
The process dirty flag for data set 6
ETC_COST6 NUMBER

The estimate to complete cost for data set 6
PPL_ETC_COST6 NUMBER

The estimate to complete cost for people for data set 6
EQPMT_ETC_COST6 NUMBER

The estimate to complete cost for equipment for data set 6
PPL_UNPLAND_EFFORT6 NUMBER

The unplanned effort for people for data set 6
EQPMT_ETC_EFFORT6 NUMBER

The estimate to complete effort for equipment for data set 6
SUB_PRJ_ETC_COST6 NUMBER

The estimate to complete cost for subprojects for data set 6
SUB_PRJ_PPL_ETC_COST6 NUMBER

The subproject estimate to complete cost for people for data set 6
SUB_PRJ_EQPMT_ETC_COST6 NUMBER

The subproject estimate to complete cost for equipment for data set 6
SUB_PRJ_PPL_ETC_EFFORT6 NUMBER

The subproject estimate to complete effort for people for data set 6
SUB_PRJ_EQPMT_ETC_EFFORT6 NUMBER

The subproject estimate to complete effort for equipment for data set 6
EARNED_VALUE6 NUMBER

The actual or earned value for data set 6
BAC_VALUE6 NUMBER

The planned value or budget at completion (BAC) value for data set 6
PERC_COMP_DERIVATIVE_CODE6 VARCHAR2 (30)
The percentage derivative code for data set 6
SUMMARY_OBJECT_FLAG VARCHAR2 (1)
Summary object flag
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PROCESS_NUMBER
,      OBJECT_ID
,      OBJECT_TYPE
,      PARENT_OBJECT_ID
,      PARENT_OBJECT_TYPE
,      CALENDAR_ID
,      CONSTRAINT_TYPE_CODE
,      CONSTRAINT_DATE
,      WBS_LEVEL
,      START_DATE1
,      START_DATE_OVERRIDE1
,      FINISH_DATE1
,      DURATION1
,      TASK_STATUS1
,      PROGRESS_STATUS_WEIGHT1
,      PROGRESS_OVERRIDE1
,      REMAINING_EFFORT1
,      PERCENT_COMPLETE1
,      PERCENT_OVERRIDE1
,      TASK_WEIGHT1
,      NUMBER_FIELD1
,      ROLLUP_NODE1
,      DIRTY_FLAG1
,      ETC_COST1
,      PPL_ETC_COST1
,      EQPMT_ETC_COST1
,      PPL_UNPLAND_EFFORT1
,      EQPMT_ETC_EFFORT1
,      SUB_PRJ_ETC_COST1
,      SUB_PRJ_PPL_ETC_COST1
,      SUB_PRJ_EQPMT_ETC_COST1
,      SUB_PRJ_PPL_ETC_EFFORT1
,      SUB_PRJ_EQPMT_ETC_EFFORT1
,      EARNED_VALUE1
,      BAC_VALUE1
,      PERC_COMP_DERIVATIVE_CODE1
,      START_DATE2
,      START_DATE_OVERRIDE2
,      FINISH_DATE2
,      DURATION2
,      TASK_STATUS2
,      PROGRESS_STATUS_WEIGHT2
,      PROGRESS_OVERRIDE2
,      REMAINING_EFFORT2
,      PERCENT_COMPLETE2
,      PERCENT_OVERRIDE2
,      TASK_WEIGHT2
,      NUMBER_FIELD2
,      ROLLUP_NODE2
,      DIRTY_FLAG2
,      ETC_COST2
,      PPL_ETC_COST2
,      EQPMT_ETC_COST2
,      PPL_UNPLAND_EFFORT2
,      EQPMT_ETC_EFFORT2
,      SUB_PRJ_ETC_COST2
,      SUB_PRJ_PPL_ETC_COST2
,      SUB_PRJ_EQPMT_ETC_COST2
,      SUB_PRJ_PPL_ETC_EFFORT2
,      SUB_PRJ_EQPMT_ETC_EFFORT2
,      EARNED_VALUE2
,      BAC_VALUE2
,      PERC_COMP_DERIVATIVE_CODE2
,      START_DATE3
,      START_DATE_OVERRIDE3
,      FINISH_DATE3
,      DURATION3
,      TASK_STATUS3
,      PROGRESS_STATUS_WEIGHT3
,      PROGRESS_OVERRIDE3
,      REMAINING_EFFORT3
,      PERCENT_COMPLETE3
,      PERCENT_OVERRIDE3
,      TASK_WEIGHT3
,      NUMBER_FIELD3
,      ROLLUP_NODE3
,      DIRTY_FLAG3
,      ETC_COST3
,      PPL_ETC_COST3
,      EQPMT_ETC_COST3
,      PPL_UNPLAND_EFFORT3
,      EQPMT_ETC_EFFORT3
,      SUB_PRJ_ETC_COST3
,      SUB_PRJ_PPL_ETC_COST3
,      SUB_PRJ_EQPMT_ETC_COST3
,      SUB_PRJ_PPL_ETC_EFFORT3
,      SUB_PRJ_EQPMT_ETC_EFFORT3
,      EARNED_VALUE3
,      BAC_VALUE3
,      PERC_COMP_DERIVATIVE_CODE3
,      START_DATE4
,      START_DATE_OVERRIDE4
,      FINISH_DATE4
,      DURATION4
,      TASK_STATUS4
,      PROGRESS_STATUS_WEIGHT4
,      PROGRESS_OVERRIDE4
,      REMAINING_EFFORT4
,      PERCENT_COMPLETE4
,      PERCENT_OVERRIDE4
,      TASK_WEIGHT4
,      NUMBER_FIELD4
,      ROLLUP_NODE4
,      DIRTY_FLAG4
,      ETC_COST4
,      PPL_ETC_COST4
,      EQPMT_ETC_COST4
,      PPL_UNPLAND_EFFORT4
,      EQPMT_ETC_EFFORT4
,      SUB_PRJ_ETC_COST4
,      SUB_PRJ_PPL_ETC_COST4
,      SUB_PRJ_EQPMT_ETC_COST4
,      SUB_PRJ_PPL_ETC_EFFORT4
,      SUB_PRJ_EQPMT_ETC_EFFORT4
,      EARNED_VALUE4
,      BAC_VALUE4
,      PERC_COMP_DERIVATIVE_CODE4
,      START_DATE5
,      START_DATE_OVERRIDE5
,      FINISH_DATE5
,      DURATION5
,      TASK_STATUS5
,      PROGRESS_STATUS_WEIGHT5
,      PROGRESS_OVERRIDE5
,      REMAINING_EFFORT5
,      PERCENT_COMPLETE5
,      PERCENT_OVERRIDE5
,      TASK_WEIGHT5
,      NUMBER_FIELD5
,      ROLLUP_NODE5
,      DIRTY_FLAG5
,      ETC_COST5
,      PPL_ETC_COST5
,      EQPMT_ETC_COST5
,      PPL_UNPLAND_EFFORT5
,      EQPMT_ETC_EFFORT5
,      SUB_PRJ_ETC_COST5
,      SUB_PRJ_PPL_ETC_COST5
,      SUB_PRJ_EQPMT_ETC_COST5
,      SUB_PRJ_PPL_ETC_EFFORT5
,      SUB_PRJ_EQPMT_ETC_EFFORT5
,      EARNED_VALUE5
,      BAC_VALUE5
,      PERC_COMP_DERIVATIVE_CODE5
,      START_DATE6
,      START_DATE_OVERRIDE6
,      FINISH_DATE6
,      DURATION6
,      TASK_STATUS6
,      PROGRESS_STATUS_WEIGHT6
,      PROGRESS_OVERRIDE6
,      REMAINING_EFFORT6
,      PERCENT_COMPLETE6
,      PERCENT_OVERRIDE6
,      TASK_WEIGHT6
,      NUMBER_FIELD6
,      ROLLUP_NODE6
,      DIRTY_FLAG6
,      ETC_COST6
,      PPL_ETC_COST6
,      EQPMT_ETC_COST6
,      PPL_UNPLAND_EFFORT6
,      EQPMT_ETC_EFFORT6
,      SUB_PRJ_ETC_COST6
,      SUB_PRJ_PPL_ETC_COST6
,      SUB_PRJ_EQPMT_ETC_COST6
,      SUB_PRJ_PPL_ETC_EFFORT6
,      SUB_PRJ_EQPMT_ETC_EFFORT6
,      EARNED_VALUE6
,      BAC_VALUE6
,      PERC_COMP_DERIVATIVE_CODE6
,      SUMMARY_OBJECT_FLAG
FROM PA.PA_PROJ_ROLLUP_BULK_TEMP;

Dependencies

[top of page]

PA.PA_PROJ_ROLLUP_BULK_TEMP does not reference any database object

PA.PA_PROJ_ROLLUP_BULK_TEMP is referenced by following:

SchemaAPPS
SynonymPA_PROJ_ROLLUP_BULK_TEMP