VIEW: PA.PA_PROJ_ROLLUP_OBJ_TEMP#

Source

View Text - Preformatted

select PROCESS_NUMBER PROCESS_NUMBER, OBJECT_ID OBJECT_ID, OBJECT_TYPE OBJECT_TYPE, PARENT_OBJECT_ID PARENT_OBJECT_ID, PARENT_OBJECT_TYPE PARENT_OBJECT_TYPE, CALENDAR_ID CALENDAR_ID, CONSTRAINT_TYPE CONSTRAINT_TYPE, CONSTRAINT_DATE CONSTRAINT_DATE, WBS_LEVEL WBS_LEVEL, START_DATE1 START_DATE1, FINISH_DATE1 FINISH_DATE1, DURATION1 DURATION1, TASK_STATUS1 TASK_STATUS1, PROGRESS_STATUS_WEIGHT1 PROGRESS_STATUS_WEIGHT1, PROGRESS_OVERRIDE1 PROGRESS_OVERRIDE1, REMAINING_EFFORT1 REMAINING_EFFORT1, PERCENT_COMPLETE1 PERCENT_COMPLETE1, PERCENT_OVERRIDE1 PERCENT_OVERRIDE1, TASK_WEIGHT1 TASK_WEIGHT1, NUMBER_FIELD1 NUMBER_FIELD1, ROLLUP_NODE1_FLAG ROLLUP_NODE1_FLAG, DIRTY1_FLAG DIRTY1_FLAG, START_DATE2 START_DATE2, FINISH_DATE2 FINISH_DATE2, DURATION2 DURATION2, TASK_STATUS2 TASK_STATUS2, PROGRESS_STATUS_WEIGHT2 PROGRESS_STATUS_WEIGHT2, PROGRESS_OVERRIDE2 PROGRESS_OVERRIDE2, REMAINING_EFFORT2 REMAINING_EFFORT2, PERCENT_COMPLETE2 PERCENT_COMPLETE2, PERCENT_OVERRIDE2 PERCENT_OVERRIDE2, TASK_WEIGHT2 TASK_WEIGHT2, NUMBER_FIELD2 NUMBER_FIELD2, ROLLUP_NODE2_FLAG ROLLUP_NODE2_FLAG, DIRTY2_FLAG DIRTY2_FLAG, START_DATE3 START_DATE3, FINISH_DATE3 FINISH_DATE3, DURATION3 DURATION3, TASK_STATUS3 TASK_STATUS3, PROGRESS_STATUS_WEIGHT3 PROGRESS_STATUS_WEIGHT3, PROGRESS_OVERRIDE3 PROGRESS_OVERRIDE3, REMAINING_EFFORT3 REMAINING_EFFORT3, PERCENT_COMPLETE3 PERCENT_COMPLETE3, PERCENT_OVERRIDE3 PERCENT_OVERRIDE3, TASK_WEIGHT3 TASK_WEIGHT3, NUMBER_FIELD3 NUMBER_FIELD3, ROLLUP_NODE3_FLAG ROLLUP_NODE3_FLAG, DIRTY3_FLAG DIRTY3_FLAG, START_DATE4 START_DATE4, FINISH_DATE4 FINISH_DATE4, DURATION4 DURATION4, TASK_STATUS4 TASK_STATUS4, PROGRESS_STATUS_WEIGHT4 PROGRESS_STATUS_WEIGHT4, PROGRESS_OVERRIDE4 PROGRESS_OVERRIDE4, REMAINING_EFFORT4 REMAINING_EFFORT4, PERCENT_COMPLETE4 PERCENT_COMPLETE4, PERCENT_OVERRIDE4 PERCENT_OVERRIDE4, TASK_WEIGHT4 TASK_WEIGHT4, NUMBER_FIELD4 NUMBER_FIELD4, ROLLUP_NODE4_FLAG ROLLUP_NODE4_FLAG, DIRTY4_FLAG DIRTY4_FLAG, START_DATE5 START_DATE5, FINISH_DATE5 FINISH_DATE5, DURATION5 DURATION5, TASK_STATUS5 TASK_STATUS5, PROGRESS_STATUS_WEIGHT5 PROGRESS_STATUS_WEIGHT5, PROGRESS_OVERRIDE5 PROGRESS_OVERRIDE5, REMAINING_EFFORT5 REMAINING_EFFORT5, PERCENT_COMPLETE5 PERCENT_COMPLETE5, PERCENT_OVERRIDE5 PERCENT_OVERRIDE5, TASK_WEIGHT5 TASK_WEIGHT5, NUMBER_FIELD5 NUMBER_FIELD5, ROLLUP_NODE5_FLAG ROLLUP_NODE5_FLAG, DIRTY5_FLAG DIRTY5_FLAG, START_DATE6 START_DATE6, FINISH_DATE6 FINISH_DATE6, DURATION6 DURATION6, TASK_STATUS6 TASK_STATUS6, PROGRESS_STATUS_WEIGHT6 PROGRESS_STATUS_WEIGHT6, PROGRESS_OVERRIDE6 PROGRESS_OVERRIDE6, REMAINING_EFFORT6 REMAINING_EFFORT6, PERCENT_COMPLETE6 PERCENT_COMPLETE6, PERCENT_OVERRIDE6 PERCENT_OVERRIDE6, TASK_WEIGHT6 TASK_WEIGHT6, NUMBER_FIELD6 NUMBER_FIELD6, ROLLUP_NODE6_FLAG ROLLUP_NODE6_FLAG, DIRTY6_FLAG DIRTY6_FLAG from "PA"."PA_PROJ_ROLLUP_OBJ_TEMP"

View Text - HTML Formatted

SELECT PROCESS_NUMBER PROCESS_NUMBER
, OBJECT_ID OBJECT_ID
, OBJECT_TYPE OBJECT_TYPE
, PARENT_OBJECT_ID PARENT_OBJECT_ID
, PARENT_OBJECT_TYPE PARENT_OBJECT_TYPE
, CALENDAR_ID CALENDAR_ID
, CONSTRAINT_TYPE CONSTRAINT_TYPE
, CONSTRAINT_DATE CONSTRAINT_DATE
, WBS_LEVEL WBS_LEVEL
, START_DATE1 START_DATE1
, FINISH_DATE1 FINISH_DATE1
, DURATION1 DURATION1
, TASK_STATUS1 TASK_STATUS1
, PROGRESS_STATUS_WEIGHT1 PROGRESS_STATUS_WEIGHT1
, PROGRESS_OVERRIDE1 PROGRESS_OVERRIDE1
, REMAINING_EFFORT1 REMAINING_EFFORT1
, PERCENT_COMPLETE1 PERCENT_COMPLETE1
, PERCENT_OVERRIDE1 PERCENT_OVERRIDE1
, TASK_WEIGHT1 TASK_WEIGHT1
, NUMBER_FIELD1 NUMBER_FIELD1
, ROLLUP_NODE1_FLAG ROLLUP_NODE1_FLAG
, DIRTY1_FLAG DIRTY1_FLAG
, START_DATE2 START_DATE2
, FINISH_DATE2 FINISH_DATE2
, DURATION2 DURATION2
, TASK_STATUS2 TASK_STATUS2
, PROGRESS_STATUS_WEIGHT2 PROGRESS_STATUS_WEIGHT2
, PROGRESS_OVERRIDE2 PROGRESS_OVERRIDE2
, REMAINING_EFFORT2 REMAINING_EFFORT2
, PERCENT_COMPLETE2 PERCENT_COMPLETE2
, PERCENT_OVERRIDE2 PERCENT_OVERRIDE2
, TASK_WEIGHT2 TASK_WEIGHT2
, NUMBER_FIELD2 NUMBER_FIELD2
, ROLLUP_NODE2_FLAG ROLLUP_NODE2_FLAG
, DIRTY2_FLAG DIRTY2_FLAG
, START_DATE3 START_DATE3
, FINISH_DATE3 FINISH_DATE3
, DURATION3 DURATION3
, TASK_STATUS3 TASK_STATUS3
, PROGRESS_STATUS_WEIGHT3 PROGRESS_STATUS_WEIGHT3
, PROGRESS_OVERRIDE3 PROGRESS_OVERRIDE3
, REMAINING_EFFORT3 REMAINING_EFFORT3
, PERCENT_COMPLETE3 PERCENT_COMPLETE3
, PERCENT_OVERRIDE3 PERCENT_OVERRIDE3
, TASK_WEIGHT3 TASK_WEIGHT3
, NUMBER_FIELD3 NUMBER_FIELD3
, ROLLUP_NODE3_FLAG ROLLUP_NODE3_FLAG
, DIRTY3_FLAG DIRTY3_FLAG
, START_DATE4 START_DATE4
, FINISH_DATE4 FINISH_DATE4
, DURATION4 DURATION4
, TASK_STATUS4 TASK_STATUS4
, PROGRESS_STATUS_WEIGHT4 PROGRESS_STATUS_WEIGHT4
, PROGRESS_OVERRIDE4 PROGRESS_OVERRIDE4
, REMAINING_EFFORT4 REMAINING_EFFORT4
, PERCENT_COMPLETE4 PERCENT_COMPLETE4
, PERCENT_OVERRIDE4 PERCENT_OVERRIDE4
, TASK_WEIGHT4 TASK_WEIGHT4
, NUMBER_FIELD4 NUMBER_FIELD4
, ROLLUP_NODE4_FLAG ROLLUP_NODE4_FLAG
, DIRTY4_FLAG DIRTY4_FLAG
, START_DATE5 START_DATE5
, FINISH_DATE5 FINISH_DATE5
, DURATION5 DURATION5
, TASK_STATUS5 TASK_STATUS5
, PROGRESS_STATUS_WEIGHT5 PROGRESS_STATUS_WEIGHT5
, PROGRESS_OVERRIDE5 PROGRESS_OVERRIDE5
, REMAINING_EFFORT5 REMAINING_EFFORT5
, PERCENT_COMPLETE5 PERCENT_COMPLETE5
, PERCENT_OVERRIDE5 PERCENT_OVERRIDE5
, TASK_WEIGHT5 TASK_WEIGHT5
, NUMBER_FIELD5 NUMBER_FIELD5
, ROLLUP_NODE5_FLAG ROLLUP_NODE5_FLAG
, DIRTY5_FLAG DIRTY5_FLAG
, START_DATE6 START_DATE6
, FINISH_DATE6 FINISH_DATE6
, DURATION6 DURATION6
, TASK_STATUS6 TASK_STATUS6
, PROGRESS_STATUS_WEIGHT6 PROGRESS_STATUS_WEIGHT6
, PROGRESS_OVERRIDE6 PROGRESS_OVERRIDE6
, REMAINING_EFFORT6 REMAINING_EFFORT6
, PERCENT_COMPLETE6 PERCENT_COMPLETE6
, PERCENT_OVERRIDE6 PERCENT_OVERRIDE6
, TASK_WEIGHT6 TASK_WEIGHT6
, NUMBER_FIELD6 NUMBER_FIELD6
, ROLLUP_NODE6_FLAG ROLLUP_NODE6_FLAG
, DIRTY6_FLAG DIRTY6_FLAG
FROM "PA"."PA_PROJ_ROLLUP_OBJ_TEMP"