GMS_COST_SHARE_AWARDS_V

Details

  • Schema: FUSION

  • Object owner: GMS

  • Object type: VIEW

Columns

Name

AWARD_ID

Query

SQL_Statement

SELECT DISTINCT AWARD_ID FROM GMS_AWARD_FUNDING_SOURCES_B AwardFundingSource, GMS_FUNDING_SOURCES_B FundingSource

WHERE AwardFundingSource.FUNDING_SOURCE_ID = FundingSource.FUNDING_SOURCE_ID

AND FundingSource.TYPE IN ('N', 'O')