GMS_SPONSORS_VL

Details

• Schema: FUSION

• Object owner: GMS

• Object type: VIEW

Columns

Name
PARTY_ID SPONSOR_ID IND_RATE_SCH_ID BILL_TO_SPONSOR LOC_NUMBER FEDERAL_FLAG LOC_FLAG RELATED_SPONSOR_ACCT_ID COMMENTS CREATED_BY OBJECT_VERSION_NUMBER CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN SPONSOR_ACCT_ID STATUS_CODE

Query

SQL_Statement

SELECT B.PARTY_ID PARTY_ID, B.SPONSOR_ID SPONSOR_ID, B.IND_RATE_SCH_ID IND_RATE_SCH_ID, B.BILL_TO_SPONSOR BILL_TO_SPONSOR, B.LOC_NUMBER LOC_NUMBER, B.FEDERAL_FLAG FEDERAL_FLAG, B.LOC_FLAG LOC_FLAG, B.RELATED_SPONSOR_ACCT_ID RELATED_SPONSOR_ACCT_ID, TL.COMMENTS COMMENTS, B.CREATED_BY CREATED_BY, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, 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, B.SPONSOR_ACCT_ID SPONSOR_ACCT_ID, B.STATUS_CODE FROM GMS_SPONSORS_B B, GMS_SPONSORS_TL TL WHERE B.SPONSOR_ID = TL.SPONSOR_ID AND TL.LANGUAGE = USERENV('LANG')