[Home] [Help]
View: GMS_STATUS_AWARD_ACCUM_TASK_V
View Text
SELECT AWARD_ID
, PROJECT_ID
, TASK_ID
, TASK_NUMBER
, TASK_NAME
, SUM(NVL(TOTAL_REVENUE
, 0))
, SUM(NVL(BUDGET_AMOUNT
, 0))
, SUM(NVL(ACTUAL_COST
, 0))
, SUM(NVL(REQUISITION_AMOUNT
, 0))
, SUM(NVL(PURCHASE_ORDER_AMOUNT
, 0))
, SUM(NVL(SUPPLIER_INVOICE_AMOUNT
, 0))
, SUM(NVL(MANUAL_ENCUMBRANCE_AMOUNT
, 0))
FROM GMS_STATUS_ACCUM_TASK_BASE_V GROUP BY AWARD_ID
, PROJECT_ID
, TASK_ID
, TASK_NUMBER
, TASK_NAME
Columns
Name |
AWARD_ID |
PROJECT_ID |
TASK_ID |
TASK_NUMBER |
TASK_NAME |
TOTAL_REVENUE |
BUDGET_AMOUNT |
ACTUAL_COST |
REQUISITION_AMOUNT |
PURCHASE_ORDER_AMOUNT |
SUPPLIER_INVOICE_AMOUNT |
MANUAL_ENCUMBRANCE_AMOUNT |