SELECT PROJECT_ID , TASK_ID , RESOURCE_LIST_MEMBER_ID , TXN_ACCUM_ID , PA_PERIOD , EVENT_NUM , SUM(REVENUE_AMOUNT) FROM PA_STATUS_TASK_EV_BASE_V GROUP BY PROJECT_ID, TASK_ID, RESOURCE_LIST_MEMBER_ID, TXN_ACCUM_ID, PA_PERIOD, EVENT_NUM UNION SELECT PROJECT_ID , TASK_ID , RESOURCE_LIST_MEMBER_ID , TXN_ACCUM_ID , PA_PERIOD , EVENT_NUM , SUM(REVENUE_AMOUNT) FROM PA_STATUS_RSRC_EV_BASE_V GROUP BY PROJECT_ID, TASK_ID, RESOURCE_LIST_MEMBER_ID, TXN_ACCUM_ID, PA_PERIOD, EVENT_NUM
SELECT PROJECT_ID
, TASK_ID
, RESOURCE_LIST_MEMBER_ID
, TXN_ACCUM_ID
, PA_PERIOD
, EVENT_NUM
, SUM(REVENUE_AMOUNT)
FROM PA_STATUS_TASK_EV_BASE_V GROUP BY PROJECT_ID
, TASK_ID
, RESOURCE_LIST_MEMBER_ID
, TXN_ACCUM_ID
, PA_PERIOD
, EVENT_NUM UNION SELECT PROJECT_ID
, TASK_ID
, RESOURCE_LIST_MEMBER_ID
, TXN_ACCUM_ID
, PA_PERIOD
, EVENT_NUM
, SUM(REVENUE_AMOUNT)
FROM PA_STATUS_RSRC_EV_BASE_V GROUP BY PROJECT_ID
, TASK_ID
, RESOURCE_LIST_MEMBER_ID
, TXN_ACCUM_ID
, PA_PERIOD
, EVENT_NUM
|
|
|