Product: | GMS - Grants Accounting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.GMS_STATUS_AWARD_ACCUM_V |
SELECT AWARD_ID
, AWARD_NUMBER
, AWARD_SHORT_NAME
, STATUS
, 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)) ) COMMITMENT_AMOUNT
, SUM(NVL(REQUISITION_AMOUNT
, 0))
, SUM(NVL(PURCHASE_ORDER_AMOUNT
, 0))
, SUM(NVL(SUPPLIER_INVOICE_AMOUNT
, 0))
, SUM(NVL(MANUAL_ENCUMBRANCE_AMOUNT
, 0))
, TYPE
, FUNDING_SOURCE_ID
, AWARD_ORGANIZATION_ID
FROM GMS_STATUS_AWARD_ACCUM_BASE_V GROUP BY AWARD_ID
, AWARD_NUMBER
, AWARD_SHORT_NAME
, STATUS
, TYPE
, FUNDING_SOURCE_ID
, AWARD_ORGANIZATION_ID