VIEW: PA.PA_PROJ_ROLLUP_BULK_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_CODE CONSTRAINT_TYPE_CODE, CONSTRAINT_DATE CONSTRAINT_DATE, WBS_LEVEL WBS_LEVEL, START_DATE1 START_DATE1, START_DATE_OVERRIDE1 START_DATE_OVERRIDE1, 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 ROLLUP_NODE1, DIRTY_FLAG1 DIRTY_FLAG1, ETC_COST1 ETC_COST1, PPL_ETC_COST1 PPL_ETC_COST1, EQPMT_ETC_COST1 EQPMT_ETC_COST1, PPL_UNPLAND_EFFORT1 PPL_UNPLAND_EFFORT1, EQPMT_ETC_EFFORT1 EQPMT_ETC_EFFORT1, SUB_PRJ_ETC_COST1 SUB_PRJ_ETC_COST1, SUB_PRJ_PPL_ETC_COST1 SUB_PRJ_PPL_ETC_COST1, SUB_PRJ_EQPMT_ETC_COST1 SUB_PRJ_EQPMT_ETC_COST1, SUB_PRJ_PPL_ETC_EFFORT1 SUB_PRJ_PPL_ETC_EFFORT1, SUB_PRJ_EQPMT_ETC_EFFORT1 SUB_PRJ_EQPMT_ETC_EFFORT1, EARNED_VALUE1 EARNED_VALUE1, BAC_VALUE1 BAC_VALUE1, PERC_COMP_DERIVATIVE_CODE1 PERC_COMP_DERIVATIVE_CODE1, START_DATE2 START_DATE2, START_DATE_OVERRIDE2 START_DATE_OVERRIDE2, 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 ROLLUP_NODE2, DIRTY_FLAG2 DIRTY_FLAG2, ETC_COST2 ETC_COST2, PPL_ETC_COST2 PPL_ETC_COST2, EQPMT_ETC_COST2 EQPMT_ETC_COST2, PPL_UNPLAND_EFFORT2 PPL_UNPLAND_EFFORT2, EQPMT_ETC_EFFORT2 EQPMT_ETC_EFFORT2, SUB_PRJ_ETC_COST2 SUB_PRJ_ETC_COST2, SUB_PRJ_PPL_ETC_COST2 SUB_PRJ_PPL_ETC_COST2, SUB_PRJ_EQPMT_ETC_COST2 SUB_PRJ_EQPMT_ETC_COST2, SUB_PRJ_PPL_ETC_EFFORT2 SUB_PRJ_PPL_ETC_EFFORT2, SUB_PRJ_EQPMT_ETC_EFFORT2 SUB_PRJ_EQPMT_ETC_EFFORT2, EARNED_VALUE2 EARNED_VALUE2, BAC_VALUE2 BAC_VALUE2, PERC_COMP_DERIVATIVE_CODE2 PERC_COMP_DERIVATIVE_CODE2, START_DATE3 START_DATE3, START_DATE_OVERRIDE3 START_DATE_OVERRIDE3, 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 ROLLUP_NODE3, DIRTY_FLAG3 DIRTY_FLAG3, ETC_COST3 ETC_COST3, PPL_ETC_COST3 PPL_ETC_COST3, EQPMT_ETC_COST3 EQPMT_ETC_COST3, PPL_UNPLAND_EFFORT3 PPL_UNPLAND_EFFORT3, EQPMT_ETC_EFFORT3 EQPMT_ETC_EFFORT3, SUB_PRJ_ETC_COST3 SUB_PRJ_ETC_COST3, SUB_PRJ_PPL_ETC_COST3 SUB_PRJ_PPL_ETC_COST3, SUB_PRJ_EQPMT_ETC_COST3 SUB_PRJ_EQPMT_ETC_COST3, SUB_PRJ_PPL_ETC_EFFORT3 SUB_PRJ_PPL_ETC_EFFORT3, SUB_PRJ_EQPMT_ETC_EFFORT3 SUB_PRJ_EQPMT_ETC_EFFORT3, EARNED_VALUE3 EARNED_VALUE3, BAC_VALUE3 BAC_VALUE3, PERC_COMP_DERIVATIVE_CODE3 PERC_COMP_DERIVATIVE_CODE3, START_DATE4 START_DATE4, START_DATE_OVERRIDE4 START_DATE_OVERRIDE4, 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 ROLLUP_NODE4, DIRTY_FLAG4 DIRTY_FLAG4, ETC_COST4 ETC_COST4, PPL_ETC_COST4 PPL_ETC_COST4, EQPMT_ETC_COST4 EQPMT_ETC_COST4, PPL_UNPLAND_EFFORT4 PPL_UNPLAND_EFFORT4, EQPMT_ETC_EFFORT4 EQPMT_ETC_EFFORT4, SUB_PRJ_ETC_COST4 SUB_PRJ_ETC_COST4, SUB_PRJ_PPL_ETC_COST4 SUB_PRJ_PPL_ETC_COST4, SUB_PRJ_EQPMT_ETC_COST4 SUB_PRJ_EQPMT_ETC_COST4, SUB_PRJ_PPL_ETC_EFFORT4 SUB_PRJ_PPL_ETC_EFFORT4, SUB_PRJ_EQPMT_ETC_EFFORT4 SUB_PRJ_EQPMT_ETC_EFFORT4, EARNED_VALUE4 EARNED_VALUE4, BAC_VALUE4 BAC_VALUE4, PERC_COMP_DERIVATIVE_CODE4 PERC_COMP_DERIVATIVE_CODE4, START_DATE5 START_DATE5, START_DATE_OVERRIDE5 START_DATE_OVERRIDE5, 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 ROLLUP_NODE5, DIRTY_FLAG5 DIRTY_FLAG5, ETC_COST5 ETC_COST5, PPL_ETC_COST5 PPL_ETC_COST5, EQPMT_ETC_COST5 EQPMT_ETC_COST5, PPL_UNPLAND_EFFORT5 PPL_UNPLAND_EFFORT5, EQPMT_ETC_EFFORT5 EQPMT_ETC_EFFORT5, SUB_PRJ_ETC_COST5 SUB_PRJ_ETC_COST5, SUB_PRJ_PPL_ETC_COST5 SUB_PRJ_PPL_ETC_COST5, SUB_PRJ_EQPMT_ETC_COST5 SUB_PRJ_EQPMT_ETC_COST5, SUB_PRJ_PPL_ETC_EFFORT5 SUB_PRJ_PPL_ETC_EFFORT5, SUB_PRJ_EQPMT_ETC_EFFORT5 SUB_PRJ_EQPMT_ETC_EFFORT5, EARNED_VALUE5 EARNED_VALUE5, BAC_VALUE5 BAC_VALUE5, PERC_COMP_DERIVATIVE_CODE5 PERC_COMP_DERIVATIVE_CODE5, START_DATE6 START_DATE6, START_DATE_OVERRIDE6 START_DATE_OVERRIDE6, 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 ROLLUP_NODE6, DIRTY_FLAG6 DIRTY_FLAG6, ETC_COST6 ETC_COST6, PPL_ETC_COST6 PPL_ETC_COST6, EQPMT_ETC_COST6 EQPMT_ETC_COST6, PPL_UNPLAND_EFFORT6 PPL_UNPLAND_EFFORT6, EQPMT_ETC_EFFORT6 EQPMT_ETC_EFFORT6, SUB_PRJ_ETC_COST6 SUB_PRJ_ETC_COST6, SUB_PRJ_PPL_ETC_COST6 SUB_PRJ_PPL_ETC_COST6, SUB_PRJ_EQPMT_ETC_COST6 SUB_PRJ_EQPMT_ETC_COST6, SUB_PRJ_PPL_ETC_EFFORT6 SUB_PRJ_PPL_ETC_EFFORT6, SUB_PRJ_EQPMT_ETC_EFFORT6 SUB_PRJ_EQPMT_ETC_EFFORT6, EARNED_VALUE6 EARNED_VALUE6, BAC_VALUE6 BAC_VALUE6, PERC_COMP_DERIVATIVE_CODE6 PERC_COMP_DERIVATIVE_CODE6, SUMMARY_OBJECT_FLAG SUMMARY_OBJECT_FLAG from "PA"."PA_PROJ_ROLLUP_BULK_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_CODE CONSTRAINT_TYPE_CODE
, CONSTRAINT_DATE CONSTRAINT_DATE
, WBS_LEVEL WBS_LEVEL
, START_DATE1 START_DATE1
, START_DATE_OVERRIDE1 START_DATE_OVERRIDE1
, 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 ROLLUP_NODE1
, DIRTY_FLAG1 DIRTY_FLAG1
, ETC_COST1 ETC_COST1
, PPL_ETC_COST1 PPL_ETC_COST1
, EQPMT_ETC_COST1 EQPMT_ETC_COST1
, PPL_UNPLAND_EFFORT1 PPL_UNPLAND_EFFORT1
, EQPMT_ETC_EFFORT1 EQPMT_ETC_EFFORT1
, SUB_PRJ_ETC_COST1 SUB_PRJ_ETC_COST1
, SUB_PRJ_PPL_ETC_COST1 SUB_PRJ_PPL_ETC_COST1
, SUB_PRJ_EQPMT_ETC_COST1 SUB_PRJ_EQPMT_ETC_COST1
, SUB_PRJ_PPL_ETC_EFFORT1 SUB_PRJ_PPL_ETC_EFFORT1
, SUB_PRJ_EQPMT_ETC_EFFORT1 SUB_PRJ_EQPMT_ETC_EFFORT1
, EARNED_VALUE1 EARNED_VALUE1
, BAC_VALUE1 BAC_VALUE1
, PERC_COMP_DERIVATIVE_CODE1 PERC_COMP_DERIVATIVE_CODE1
, START_DATE2 START_DATE2
, START_DATE_OVERRIDE2 START_DATE_OVERRIDE2
, 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 ROLLUP_NODE2
, DIRTY_FLAG2 DIRTY_FLAG2
, ETC_COST2 ETC_COST2
, PPL_ETC_COST2 PPL_ETC_COST2
, EQPMT_ETC_COST2 EQPMT_ETC_COST2
, PPL_UNPLAND_EFFORT2 PPL_UNPLAND_EFFORT2
, EQPMT_ETC_EFFORT2 EQPMT_ETC_EFFORT2
, SUB_PRJ_ETC_COST2 SUB_PRJ_ETC_COST2
, SUB_PRJ_PPL_ETC_COST2 SUB_PRJ_PPL_ETC_COST2
, SUB_PRJ_EQPMT_ETC_COST2 SUB_PRJ_EQPMT_ETC_COST2
, SUB_PRJ_PPL_ETC_EFFORT2 SUB_PRJ_PPL_ETC_EFFORT2
, SUB_PRJ_EQPMT_ETC_EFFORT2 SUB_PRJ_EQPMT_ETC_EFFORT2
, EARNED_VALUE2 EARNED_VALUE2
, BAC_VALUE2 BAC_VALUE2
, PERC_COMP_DERIVATIVE_CODE2 PERC_COMP_DERIVATIVE_CODE2
, START_DATE3 START_DATE3
, START_DATE_OVERRIDE3 START_DATE_OVERRIDE3
, 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 ROLLUP_NODE3
, DIRTY_FLAG3 DIRTY_FLAG3
, ETC_COST3 ETC_COST3
, PPL_ETC_COST3 PPL_ETC_COST3
, EQPMT_ETC_COST3 EQPMT_ETC_COST3
, PPL_UNPLAND_EFFORT3 PPL_UNPLAND_EFFORT3
, EQPMT_ETC_EFFORT3 EQPMT_ETC_EFFORT3
, SUB_PRJ_ETC_COST3 SUB_PRJ_ETC_COST3
, SUB_PRJ_PPL_ETC_COST3 SUB_PRJ_PPL_ETC_COST3
, SUB_PRJ_EQPMT_ETC_COST3 SUB_PRJ_EQPMT_ETC_COST3
, SUB_PRJ_PPL_ETC_EFFORT3 SUB_PRJ_PPL_ETC_EFFORT3
, SUB_PRJ_EQPMT_ETC_EFFORT3 SUB_PRJ_EQPMT_ETC_EFFORT3
, EARNED_VALUE3 EARNED_VALUE3
, BAC_VALUE3 BAC_VALUE3
, PERC_COMP_DERIVATIVE_CODE3 PERC_COMP_DERIVATIVE_CODE3
, START_DATE4 START_DATE4
, START_DATE_OVERRIDE4 START_DATE_OVERRIDE4
, 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 ROLLUP_NODE4
, DIRTY_FLAG4 DIRTY_FLAG4
, ETC_COST4 ETC_COST4
, PPL_ETC_COST4 PPL_ETC_COST4
, EQPMT_ETC_COST4 EQPMT_ETC_COST4
, PPL_UNPLAND_EFFORT4 PPL_UNPLAND_EFFORT4
, EQPMT_ETC_EFFORT4 EQPMT_ETC_EFFORT4
, SUB_PRJ_ETC_COST4 SUB_PRJ_ETC_COST4
, SUB_PRJ_PPL_ETC_COST4 SUB_PRJ_PPL_ETC_COST4
, SUB_PRJ_EQPMT_ETC_COST4 SUB_PRJ_EQPMT_ETC_COST4
, SUB_PRJ_PPL_ETC_EFFORT4 SUB_PRJ_PPL_ETC_EFFORT4
, SUB_PRJ_EQPMT_ETC_EFFORT4 SUB_PRJ_EQPMT_ETC_EFFORT4
, EARNED_VALUE4 EARNED_VALUE4
, BAC_VALUE4 BAC_VALUE4
, PERC_COMP_DERIVATIVE_CODE4 PERC_COMP_DERIVATIVE_CODE4
, START_DATE5 START_DATE5
, START_DATE_OVERRIDE5 START_DATE_OVERRIDE5
, 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 ROLLUP_NODE5
, DIRTY_FLAG5 DIRTY_FLAG5
, ETC_COST5 ETC_COST5
, PPL_ETC_COST5 PPL_ETC_COST5
, EQPMT_ETC_COST5 EQPMT_ETC_COST5
, PPL_UNPLAND_EFFORT5 PPL_UNPLAND_EFFORT5
, EQPMT_ETC_EFFORT5 EQPMT_ETC_EFFORT5
, SUB_PRJ_ETC_COST5 SUB_PRJ_ETC_COST5
, SUB_PRJ_PPL_ETC_COST5 SUB_PRJ_PPL_ETC_COST5
, SUB_PRJ_EQPMT_ETC_COST5 SUB_PRJ_EQPMT_ETC_COST5
, SUB_PRJ_PPL_ETC_EFFORT5 SUB_PRJ_PPL_ETC_EFFORT5
, SUB_PRJ_EQPMT_ETC_EFFORT5 SUB_PRJ_EQPMT_ETC_EFFORT5
, EARNED_VALUE5 EARNED_VALUE5
, BAC_VALUE5 BAC_VALUE5
, PERC_COMP_DERIVATIVE_CODE5 PERC_COMP_DERIVATIVE_CODE5
, START_DATE6 START_DATE6
, START_DATE_OVERRIDE6 START_DATE_OVERRIDE6
, 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 ROLLUP_NODE6
, DIRTY_FLAG6 DIRTY_FLAG6
, ETC_COST6 ETC_COST6
, PPL_ETC_COST6 PPL_ETC_COST6
, EQPMT_ETC_COST6 EQPMT_ETC_COST6
, PPL_UNPLAND_EFFORT6 PPL_UNPLAND_EFFORT6
, EQPMT_ETC_EFFORT6 EQPMT_ETC_EFFORT6
, SUB_PRJ_ETC_COST6 SUB_PRJ_ETC_COST6
, SUB_PRJ_PPL_ETC_COST6 SUB_PRJ_PPL_ETC_COST6
, SUB_PRJ_EQPMT_ETC_COST6 SUB_PRJ_EQPMT_ETC_COST6
, SUB_PRJ_PPL_ETC_EFFORT6 SUB_PRJ_PPL_ETC_EFFORT6
, SUB_PRJ_EQPMT_ETC_EFFORT6 SUB_PRJ_EQPMT_ETC_EFFORT6
, EARNED_VALUE6 EARNED_VALUE6
, BAC_VALUE6 BAC_VALUE6
, PERC_COMP_DERIVATIVE_CODE6 PERC_COMP_DERIVATIVE_CODE6
, SUMMARY_OBJECT_FLAG SUMMARY_OBJECT_FLAG
FROM "PA"."PA_PROJ_ROLLUP_BULK_TEMP"