GMS_FUNDING_SOURCES_XCC_V

Details

• Schema: FUSION

• Object owner: GMS

• Object type: VIEW

Columns

Name
LANGUAGE FUNDING_SOURCE_ID FUNDING_SOURCE_NAME FUNDING_SOURCE_NUMBER

Query

SQL_Statement
SELECT TL.LANGUAGE, TL.FUNDING_SOURCE_ID, DECODE(TL.FUNDING_SOURCE_NAME,NULL, (SELECT PARTY_NAME FROM HZ_PARTIES WHERE PARTY_ID=B.SOURCE_ID ),TL.FUNDING_SOURCE_NAME) FUNDING_SOURCE_NAME, B.FUNDING_SOURCE_NUMBER FUNDING_SOURCE_NUMBER FROM GMS_FUNDING_SOURCES_B B, GMS_FUNDING_SOURCES_TL TL WHERE B.FUNDING_SOURCE_ID=TL.FUNDING_SOURCE_ID AND TL.LANGUAGE =USERENV('LANG')