1. Tables and Views for Project Management
  2. GMS_AWARD_TOT_FUND_ALLOCS_V

GMS_AWARD_TOT_FUND_ALLOCS_V

Details

  • Schema: FUSION

  • Object owner: GMS

  • Object type: VIEW

Columns

Name

FUNDING_ID

TOTAL_FUNDED_AMOUNT

TOTAL_LC_FUNDED_AMOUNT

Query

SQL_Statement

SELECT

GmsAfa.FUNDING_ID FUNDING_ID,

SUM(NVL(GmsAfa.FUNDING_AMOUNT, 0)) TOTAL_FUNDED_AMOUNT ,

SUM(NVL(GmsAfa.LC_FUNDING_AMOUNT, 0)) TOTAL_LC_FUNDED_AMOUNT

FROM

GMS_AWARD_FUND_ALLOCATIONS GmsAfa

GROUP BY

GmsAfa.FUNDING_ID