GMS_FUNDING_BY_PROJECT_V
Details
-
Schema: FUSION
-
Object owner: GMS
-
Object type: VIEW
Columns
| Name |
|---|
|
PROJECT_ID TOTAL_FUNDED_AMOUNT |
Query
| SQL_Statement |
|---|
|
SELECT GmsAfa.project_id project_id, SUM(NVL(GmsAfa.FUNDING_AMOUNT, 0)) TOTAL_FUNDED_AMOUNT FROM GMS_AWARD_FUND_ALLOCATIONS GmsAfa GROUP BY GmsAfa.project_id, GmsAfa.award_id |