GMS_AWARD_NO_ALLOCATIONS_V

Details

• Schema: FUSION

• Object owner: GMS

• Object type: VIEW

Columns

Name
AWARD_ID BUDGET_PERIOD_ID AWARD_FUNDING_SOURCE_ID ISSUE_TYPE ID ISSUE_NUMBER

Query

SQL_Statement
select a.award_id, a.budget_period_id, a.award_funding_source_id, a.issue_type, a.id, a.issue_number from gms_award_fundings_vl a where not exists (select * from gms_award_fund_allocations b where a.id = b.funding_id)