GMS_AWARD_ALL_FUND_TOTAL_V
Details
-
Schema: FUSION
-
Object owner: GMS
-
Object type: VIEW
Columns
Name |
---|
AWARD_ID TOTAL_FUND_AMOUNT TOTAL_LC_FUND_AMOUNT |
Query
SQL_Statement |
---|
SELECT FUNDINGS.AWARD_ID AWARD_ID, SUM(NVL(FUNDINGS.DIRECT_FUNDING_AMOUNT, 0) + NVL(FUNDINGS.INDIRECT_FUNDING_AMOUNT, 0)) TOTAL_FUND_AMOUNT, SUM(NVL(FUNDINGS.LC_DIRECT_FUNDING_AMOUNT, 0) + NVL(FUNDINGS.LC_INDIRECT_FUNDING_AMOUNT, 0)) TOTAL_LC_FUND_AMOUNT FROM GMS_AWARD_FUNDINGS_VL FUNDINGS GROUP BY FUNDINGS.AWARD_ID |