[Home] [Help]
View: PA_STATUS_EV_BASE_V
View Text
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
Columns
Name |
PROJECT_ID |
TASK_ID |
RESOURCE_LIST_MEMBER_ID |
TXN_ACCUM_ID |
PA_PERIOD |
EVENT_NUM |
REVENUE_AMOUNT |