GMS_CURRENT_BUDGET

Details

Schema: FUSION
Object owner: GMS
Object type: VIEW

Columns

Name
ID AWARD_ID BUDGET_PERIOD START_DATE END_DATE

Name

ID

AWARD_ID

BUDGET_PERIOD

START_DATE

END_DATE

Query

SQL_Statement
select a.id, a.award_id, a.budget_period, a.start_date, a.end_date from gms_award_budget_periods a where TRUNC(a.start_date) <= TRUNC(sysdate) and TRUNC(a.end_date) >= TRUNC(sysdate) union select a.id, a.award_id, a.budget_period, a.start_date, a.end_date from gms_award_budget_periods a where TRUNC(a.start_date) > TRUNC(sysdate) and a.start_date = (select min(b.start_date) from gms_award_budget_periods b where a.award_id = b.award_id group by b.award_id) union select a.id, a.award_id, a.budget_period, a.start_date, a.end_date from gms_award_budget_periods a where TRUNC(a.end_date) < TRUNC(sysdate) and a.end_date = (select max(b.end_date) from gms_award_budget_periods b where a.award_id = b.award_id group by b.award_id)

SQL_Statement

select a.id,

a.award_id,

a.budget_period,

a.start_date,

a.end_date

from gms_award_budget_periods a

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

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

union

select a.id,

a.award_id,

a.budget_period,

a.start_date,

a.end_date

from gms_award_budget_periods a

where TRUNC(a.start_date) > TRUNC(sysdate) and a.start_date = (select min(b.start_date) from gms_award_budget_periods b where a.award_id = b.award_id group by b.award_id)

union

select a.id,

a.award_id,

a.budget_period,

a.start_date,

a.end_date

from gms_award_budget_periods a

where TRUNC(a.end_date) < TRUNC(sysdate) and a.end_date = (select max(b.end_date) from gms_award_budget_periods b where a.award_id = b.award_id group by b.award_id)