GMS_PRJ_BUD_FS_V

Details

• Schema: FUSION

• Object owner: GMS

• Object type: VIEW

Columns

Name
AWARD_ID PROJECT_ID LINKAGE_ID BUDGET_PERIOD_ID BUDGET_PERIOD START_DATE END_DATE FUNDING_SOURCE_ID AWD_PROJ_LINKAGE_ID AWD_PRJ_FUND_SOURCE_ID

Query

SQL_Statement
select a.award_id, b.project_id, b.id as linkage_id, a.id as budget_period_id, a.budget_period, a.start_date, a.end_date, f.funding_source_id, f.AWD_PROJ_LINKAGE_ID, f.AWD_PRJ_FUND_SOURCE_ID from gms_award_budget_periods a, gms_award_projects b, GMS_AWD_PRJ_FND_SOURCES f where a.award_id= b.award_id and b.id = f.AWD_PROJ_LINKAGE_ID