GMS_CURRENT_BUDGET_PERIOD

Details

Schema: FUSION
Object owner: GMS
Object type: VIEW

Columns

Name
AWARD_ID END_AWARD_ID PERIOD_START_DATE PERIOD_END_DATE

Name

AWARD_ID

END_AWARD_ID

PERIOD_START_DATE

PERIOD_END_DATE

Query

SQL_Statement
select a.award_id, b.award_id as end_award_id , min(a.start_date) as period_start_date, min(b.end_date) as period_end_date from gms_award_budget_periods a, gms_award_budget_periods b, gms_award_headers_b c where TRUNC(a.start_date) <= TRUNC(sysdate) and TRUNC(b.end_date) >= TRUNC(sysdate) and a.award_id = b.award_id and a.award_id = c.id group by a.award_id, b.award_id, c.expanded_auth_flag union select a.award_id, b.award_id as end_award_id , min(a.start_date) as period_start_date, max(b.end_date) as period_end_date from gms_award_budget_periods a, gms_award_budget_periods b, gms_award_headers_b c where TRUNC(b.end_date) < TRUNC(sysdate) and a.award_id = b.award_id and a.award_id = c.id and a.award_id not in (select d.award_id from gms_award_budget_periods d where TRUNC(d.start_date) <= TRUNC(sysdate) and TRUNC(d.end_date) >= TRUNC(sysdate)) group by a.award_id, b.award_id, c.expanded_auth_flag

SQL_Statement

select a.award_id,

b.award_id as end_award_id ,

min(a.start_date) as period_start_date,

min(b.end_date) as period_end_date

from gms_award_budget_periods a, gms_award_budget_periods b, gms_award_headers_b c

where TRUNC(a.start_date) <= TRUNC(sysdate)

and TRUNC(b.end_date) >= TRUNC(sysdate)

and a.award_id = b.award_id

and a.award_id = c.id

group by a.award_id, b.award_id, c.expanded_auth_flag

union