GMS_AWARD_NO_ISSUES_V

Details

• Schema: FUSION

• Object owner: GMS

• Object type: VIEW

Columns

Name
AWARD_ID BUDGET_PERIOD_ID BUDGET_PERIOD AWARD_FUNDING_SOURCE_ID

Query

SQL_Statement
select a.award_id, a.budget_period_id, a.budget_period, a.award_funding_source_id from gms_award_budget_fundings_v a where not exists (select * from gms_award_fundings_vl b where a.award_id = b.award_id and a.budget_period_id = b.budget_period_id and a.award_funding_source_id = b.award_funding_source_id)