GMS_AWD_XCC_BUDGET_PERIODS_V

Details

• Schema: FUSION

• Object owner: GMS

• Object type: VIEW

Columns

Name
BUDGET_START_DATE BUDGET_END_DATE BUDGET_PERIOD BUDGET_PERIOD_ID AWARD_ID PRE_AWARD_DATE CLOSE_DATE EXPANDED_AUTH_FLAG

Query

SQL_Statement

SELECT DECODE(a.START_DATE, c.bp_start_date, NVL(b.PRE_AWARD_DATE, c.bp_start_date), a.START_DATE) budget_start_date, a.END_DATE budget_end_date, a.BUDGET_PERIOD, a.ID AS budget_period_id, a.AWARD_ID, b.PRE_AWARD_DATE, b.CLOSE_DATE, b.EXPANDED_AUTH_FLAG FROM GMS_AWARD_BUDGET_PERIODS a, GMS_AWARD_HEADERS_B b, (SELECT MIN(h.START_DATE) AS bp_start_date, h.AWARD_ID AS award_id FROM GMS_AWARD_BUDGET_PERIODS h GROUP BY h.AWARD_ID) c WHERE a.AWARD_ID = b.ID AND a.AWARD_ID = c.award_id ORDER BY a.START_DATE