GMS_AWARD_DATE_V

Details

• Schema: FUSION

• Object owner: GMS

• Object type: VIEW

Columns

Name
START_DATE END_DATE ID CLOSE_DATE PRE_AWARD_DATE

Query

SQL_Statement

SELECT MIN(gms_award_budget_periods.start_date) AS start_date, MAX(gms_award_budget_periods.end_date) AS end_date, gms_award_budget_periods.award_id AS id, gms_award_headers_b.close_date, gms_award_headers_b.pre_award_date FROM gms_award_budget_periods, gms_award_headers_b WHERE gms_award_budget_periods.award_id = gms_award_headers_b.id GROUP BY gms_award_budget_periods.award_id, gms_award_headers_b.close_date, gms_award_headers_b.pre_award_date