1. Tables and Views for Project Management
  2. GMS_XLA_FUNDING_SOURCE_V

GMS_XLA_FUNDING_SOURCE_V

Details

  • Schema: FUSION

  • Object owner: PJB

  • Object type: VIEW

Columns

Name

CONTRACT_ID

FUNDING_SOURCE_ID

FUNDING_SOURCE_NAME

FUNDING_SOURCE_TYPE

FUNDING_SOURCE_NUMBER

Query

SQL_Statement

SELECT AwdFundingSource.award_id CONTRACT_ID,

FundingSource.funding_source_id FUNDING_SOURCE_ID,

FundingSource.funding_source_id FUNDING_SOURCE_NAME,

FundingSource.Type FUNDING_SOURCE_TYPE,

FundingSource.FUNDING_SOURCE_ID FUNDING_SOURCE_NUMBER

FROM

gms_Award_funding_sources_b AwdFundingSource,

gms_funding_sources_b FundingSource

WHERE

AwdFundingSource.funding_source_id = FundingSource.funding_source_id