GMS_AWD_STR_END_PR_DATE_V

Details

• Schema: FUSION

• Object owner: GMS

• Object type: VIEW

Columns

Name
ID BP_START_DATE BP_END_DATE

Query

SQL_Statement
SELECT a.ID, c.bp_start_date bp_start_date, d.bp_end_date bp_end_date FROM GMS_AWARD_HEADERS_B a, (SELECT MIN(h.START_DATE) bp_start_date, h.AWARD_ID award_id FROM GMS_AWARD_BUDGET_PERIODS h GROUP BY h.AWARD_ID) c, (SELECT MAX(j.END_DATE) bp_end_date, j.AWARD_ID award_id FROM GMS_AWARD_BUDGET_PERIODS j GROUP BY j.AWARD_ID) d WHERE a.ID = c.award_id AND a.ID = d.award_id