GMS_AWARD_FUNDINGS_VL

Details

• Schema: FUSION

• Object owner: GMS

• Object type: VIEW

Columns

Name
ID AWARD_ID BUDGET_PERIOD_ID AWARD_FUNDING_SOURCE_ID ISSUE_NUMBER ISSUE_TYPE ISSUE_DATE DIRECT_FUNDING_AMOUNT LC_DIRECT_FUNDING_AMOUNT INDIRECT_FUNDING_AMOUNT LC_INDIRECT_FUNDING_AMOUNT OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ISSUE_DESCRIPTION FUNDING_SOURCE_ID

Query

SQL_Statement

SELECT B.ID ID, B.AWARD_ID AWARD_ID, B.BUDGET_PERIOD_ID BUDGET_PERIOD_ID, B.AWARD_FUNDING_SOURCE_ID AWARD_FUNDING_SOURCE_ID, B.ISSUE_NUMBER ISSUE_NUMBER, B.ISSUE_TYPE ISSUE_TYPE, B.ISSUE_DATE ISSUE_DATE, B.DIRECT_FUNDING_AMOUNT DIRECT_FUNDING_AMOUNT, B.LC_DIRECT_FUNDING_AMOUNT LC_DIRECT_FUNDING_AMOUNT, B.INDIRECT_FUNDING_AMOUNT INDIRECT_FUNDING_AMOUNT, B.LC_INDIRECT_FUNDING_AMOUNT LC_INDIRECT_FUNDING_AMOUNT, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TL.ISSUE_DESCRIPTION ISSUE_DESCRIPTION, B.FUNDING_SOURCE_ID FUNDING_SOURCE_ID FROM GMS_AWARD_FUNDINGS_B B, GMS_AWARD_FUNDINGS_TL TL WHERE B.ID = TL.ID AND TL.LANGUAGE = USERENV('LANG')