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

VIEW: PA.PA_PROJ_ROLLUP_BULK_TEMP#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
PROCESS_NUMBER NUMBER
Yes
OBJECT_ID NUMBER (15) Yes
OBJECT_TYPE VARCHAR2 (30) Yes
PARENT_OBJECT_ID NUMBER (15)
PARENT_OBJECT_TYPE VARCHAR2 (30)
CALENDAR_ID NUMBER (15)
CONSTRAINT_TYPE_CODE VARCHAR2 (1)
CONSTRAINT_DATE DATE

WBS_LEVEL NUMBER
Yes
START_DATE1 DATE

START_DATE_OVERRIDE1 DATE

FINISH_DATE1 DATE

DURATION1 NUMBER

TASK_STATUS1 NUMBER

PROGRESS_STATUS_WEIGHT1 NUMBER

PROGRESS_OVERRIDE1 NUMBER

REMAINING_EFFORT1 NUMBER

PERCENT_COMPLETE1 NUMBER

PERCENT_OVERRIDE1 NUMBER

TASK_WEIGHT1 NUMBER

NUMBER_FIELD1 NUMBER

ROLLUP_NODE1 VARCHAR2 (1)
DIRTY_FLAG1 VARCHAR2 (1)
ETC_COST1 NUMBER

PPL_ETC_COST1 NUMBER

EQPMT_ETC_COST1 NUMBER

PPL_UNPLAND_EFFORT1 NUMBER

EQPMT_ETC_EFFORT1 NUMBER

SUB_PRJ_ETC_COST1 NUMBER

SUB_PRJ_PPL_ETC_COST1 NUMBER

SUB_PRJ_EQPMT_ETC_COST1 NUMBER

SUB_PRJ_PPL_ETC_EFFORT1 NUMBER

SUB_PRJ_EQPMT_ETC_EFFORT1 NUMBER

EARNED_VALUE1 NUMBER

BAC_VALUE1 NUMBER

PERC_COMP_DERIVATIVE_CODE1 VARCHAR2 (30)
START_DATE2 DATE

START_DATE_OVERRIDE2 DATE

FINISH_DATE2 DATE

DURATION2 NUMBER

TASK_STATUS2 NUMBER

PROGRESS_STATUS_WEIGHT2 NUMBER

PROGRESS_OVERRIDE2 NUMBER

REMAINING_EFFORT2 NUMBER

PERCENT_COMPLETE2 NUMBER

PERCENT_OVERRIDE2 NUMBER

TASK_WEIGHT2 NUMBER

NUMBER_FIELD2 NUMBER

ROLLUP_NODE2 VARCHAR2 (1)
DIRTY_FLAG2 VARCHAR2 (1)
ETC_COST2 NUMBER

PPL_ETC_COST2 NUMBER

EQPMT_ETC_COST2 NUMBER

PPL_UNPLAND_EFFORT2 NUMBER

EQPMT_ETC_EFFORT2 NUMBER

SUB_PRJ_ETC_COST2 NUMBER

SUB_PRJ_PPL_ETC_COST2 NUMBER

SUB_PRJ_EQPMT_ETC_COST2 NUMBER

SUB_PRJ_PPL_ETC_EFFORT2 NUMBER

SUB_PRJ_EQPMT_ETC_EFFORT2 NUMBER

EARNED_VALUE2 NUMBER

BAC_VALUE2 NUMBER

PERC_COMP_DERIVATIVE_CODE2 VARCHAR2 (30)
START_DATE3 DATE

START_DATE_OVERRIDE3 DATE

FINISH_DATE3 DATE

DURATION3 NUMBER

TASK_STATUS3 NUMBER

PROGRESS_STATUS_WEIGHT3 NUMBER

PROGRESS_OVERRIDE3 NUMBER

REMAINING_EFFORT3 NUMBER

PERCENT_COMPLETE3 NUMBER

PERCENT_OVERRIDE3 NUMBER

TASK_WEIGHT3 NUMBER

NUMBER_FIELD3 NUMBER

ROLLUP_NODE3 VARCHAR2 (1)
DIRTY_FLAG3 VARCHAR2 (1)
ETC_COST3 NUMBER

PPL_ETC_COST3 NUMBER

EQPMT_ETC_COST3 NUMBER

PPL_UNPLAND_EFFORT3 NUMBER

EQPMT_ETC_EFFORT3 NUMBER

SUB_PRJ_ETC_COST3 NUMBER

SUB_PRJ_PPL_ETC_COST3 NUMBER

SUB_PRJ_EQPMT_ETC_COST3 NUMBER

SUB_PRJ_PPL_ETC_EFFORT3 NUMBER

SUB_PRJ_EQPMT_ETC_EFFORT3 NUMBER

EARNED_VALUE3 NUMBER

BAC_VALUE3 NUMBER

PERC_COMP_DERIVATIVE_CODE3 VARCHAR2 (30)
START_DATE4 DATE

START_DATE_OVERRIDE4 DATE

FINISH_DATE4 DATE

DURATION4 NUMBER

TASK_STATUS4 NUMBER

PROGRESS_STATUS_WEIGHT4 NUMBER

PROGRESS_OVERRIDE4 NUMBER

REMAINING_EFFORT4 NUMBER

PERCENT_COMPLETE4 NUMBER

PERCENT_OVERRIDE4 NUMBER

TASK_WEIGHT4 NUMBER

NUMBER_FIELD4 NUMBER

ROLLUP_NODE4 VARCHAR2 (1)
DIRTY_FLAG4 VARCHAR2 (1)
ETC_COST4 NUMBER

PPL_ETC_COST4 NUMBER

EQPMT_ETC_COST4 NUMBER

PPL_UNPLAND_EFFORT4 NUMBER

EQPMT_ETC_EFFORT4 NUMBER

SUB_PRJ_ETC_COST4 NUMBER

SUB_PRJ_PPL_ETC_COST4 NUMBER

SUB_PRJ_EQPMT_ETC_COST4 NUMBER

SUB_PRJ_PPL_ETC_EFFORT4 NUMBER

SUB_PRJ_EQPMT_ETC_EFFORT4 NUMBER

EARNED_VALUE4 NUMBER

BAC_VALUE4 NUMBER

PERC_COMP_DERIVATIVE_CODE4 VARCHAR2 (30)
START_DATE5 DATE

START_DATE_OVERRIDE5 DATE

FINISH_DATE5 DATE

DURATION5 NUMBER

TASK_STATUS5 NUMBER

PROGRESS_STATUS_WEIGHT5 NUMBER

PROGRESS_OVERRIDE5 NUMBER

REMAINING_EFFORT5 NUMBER

PERCENT_COMPLETE5 NUMBER

PERCENT_OVERRIDE5 NUMBER

TASK_WEIGHT5 NUMBER

NUMBER_FIELD5 NUMBER

ROLLUP_NODE5 VARCHAR2 (1)
DIRTY_FLAG5 VARCHAR2 (1)
ETC_COST5 NUMBER

PPL_ETC_COST5 NUMBER

EQPMT_ETC_COST5 NUMBER

PPL_UNPLAND_EFFORT5 NUMBER

EQPMT_ETC_EFFORT5 NUMBER

SUB_PRJ_ETC_COST5 NUMBER

SUB_PRJ_PPL_ETC_COST5 NUMBER

SUB_PRJ_EQPMT_ETC_COST5 NUMBER

SUB_PRJ_PPL_ETC_EFFORT5 NUMBER

SUB_PRJ_EQPMT_ETC_EFFORT5 NUMBER

EARNED_VALUE5 NUMBER

BAC_VALUE5 NUMBER

PERC_COMP_DERIVATIVE_CODE5 VARCHAR2 (30)
START_DATE6 DATE

START_DATE_OVERRIDE6 DATE

FINISH_DATE6 DATE

DURATION6 NUMBER

TASK_STATUS6 NUMBER

PROGRESS_STATUS_WEIGHT6 NUMBER

PROGRESS_OVERRIDE6 NUMBER

REMAINING_EFFORT6 NUMBER

PERCENT_COMPLETE6 NUMBER

PERCENT_OVERRIDE6 NUMBER

TASK_WEIGHT6 NUMBER

NUMBER_FIELD6 NUMBER

ROLLUP_NODE6 VARCHAR2 (1)
DIRTY_FLAG6 VARCHAR2 (1)
ETC_COST6 NUMBER

PPL_ETC_COST6 NUMBER

EQPMT_ETC_COST6 NUMBER

PPL_UNPLAND_EFFORT6 NUMBER

EQPMT_ETC_EFFORT6 NUMBER

SUB_PRJ_ETC_COST6 NUMBER

SUB_PRJ_PPL_ETC_COST6 NUMBER

SUB_PRJ_EQPMT_ETC_COST6 NUMBER

SUB_PRJ_PPL_ETC_EFFORT6 NUMBER

SUB_PRJ_EQPMT_ETC_EFFORT6 NUMBER

EARNED_VALUE6 NUMBER

BAC_VALUE6 NUMBER

PERC_COMP_DERIVATIVE_CODE6 VARCHAR2 (30)
SUMMARY_OBJECT_FLAG VARCHAR2 (1)
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# references the following:

SchemaPA
TablePA_PROJ_ROLLUP_BULK_TEMP
PA.PA_PROJ_ROLLUP_BULK_TEMP# is referenced by following:

SchemaAPPS
SynonymPA_PROJ_ROLLUP_BULK_TEMP