GMS_PROJECT_PERIOD_FUNDINGS_V

Details

• Schema: FUSION

• Object owner: GMS

• Object type: VIEW

Columns

Name
AWARD_ID LINKAGE_ID LC_FUNDING_AMOUNT FUNDING_AMOUNT FUNDING_ID ID BUDGET_PERIOD_ID FUNDING_SOURCE_ID

Query

SQL_Statement
SELECT A.AWARD_ID, A.PROJECT_ID AS LINKAGE_ID, A.LC_FUNDING_AMOUNT, A.FUNDING_AMOUNT, A.FUNDING_ID, B.ID, B.BUDGET_PERIOD_ID, B.FUNDING_SOURCE_ID FROM GMS_AWARD_FUND_ALLOCATIONS A, GMS_AWARD_FUNDINGS_B B WHERE A.FUNDING_ID = B.ID