GMS_PROJECT_BUDGET_PERIODS_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

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 from gms_award_budget_periods a, gms_award_projects b where a.award_id= b.award_id order by A.AWARD_ID, b.project_id, a.start_date