Product: | GMS - Grants Accounting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.GMS_STATUS_RESOURCES_V |
SELECT AWARD_ID
, PROJECT_ID
, PROJECT_NAME
, PROJECT_NUMBER
, RESOURCE_ID
, RESOURCE_NAME
, RESOURCE_LIST_MEMBER_ID
, RESOURCE_LIST_ID
, 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))
, START_DATE
, END_DATE
FROM GMS_STATUS_RESOURCES_BASE_V GROUP BY AWARD_ID
, PROJECT_ID
, PROJECT_NAME
, PROJECT_NUMBER
, RESOURCE_ID
, RESOURCE_NAME
, RESOURCE_LIST_MEMBER_ID
, RESOURCE_LIST_ID
, START_DATE
, END_DATE