[Home] [Help]
View: GMS_STATUS_ACTUALS_BASE2_V
View Text
SELECT GSAB1V.AWARD_ID
, GSAB1V.PROJECT_ID
, GSAB1V.TASK_ID
, GSAB1V.EXPENDITURE_ITEM_ID
, SUM (NVL (GSAB1V.REVENUE_AMOUNT
, 0))
, SUM (NVL (GSAB1V.BILLED_AMOUNT
, 0))
, SUM (NVL (GSAB1V.RAW_COST
, 0))
, SUM (NVL (GSAB1V.BURDENED_COST
, 0))
, NULL INVOICE_ID
, NULL PA_DATE
FROM GMS_STATUS_ACTUALS_BASE1_V GSAB1V GROUP BY GSAB1V.AWARD_ID
, GSAB1V.PROJECT_ID
, GSAB1V.TASK_ID
, GSAB1V.EXPENDITURE_ITEM_ID
Columns
Name |
AWARD_ID |
PROJECT_ID |
TASK_ID |
EXPENDITURE_ITEM_ID |
REVENUE_AMOUNT |
BILLED_AMOUNT |
RAW_COST |
BURDENED_COST |
INVOICE_ID |
PA_DATE |