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