GMS_FUNDING_SOURCES

Details

Schema: FUSION
Object owner: GMS
Object type: VIEW

Columns

Name
LANGUAGE FUNDING_SOURCE_ID FUNDING_SOURCE_NAME

Name

LANGUAGE

FUNDING_SOURCE_ID

FUNDING_SOURCE_NAME

Query

SQL_Statement
select userenv('LANG') language,funding_source.funding_source_id funding_source_id,funding_source_name funding_source_name from gms_funding_sources_b funding_source,GMS_FUNDING_SOURCES_TL funding_sourcetl where funding_source.funding_source_id=funding_sourcetl.funding_source_id and funding_sourcetl.LANGUAGE= USERENV('LANG') and type='N' UNION ALL select userenv('LANG') language, funding_source_id funding_source_id,party_name funding_source_name from gms_funding_sources_b funding_source,hz_parties party where funding_source.source_id=party.party_id UNION ALL select userenv('LANG') language,funding_source_id funding_source_id,haotl.name funding_source_name from gms_funding_sources_b funding_source,HR_ORGANIZATION_UNITS_F_TL haotl where funding_source.source_id=haotl.ORGANIZATION_ID and haotl.LANGUAGE= USERENV('LANG')

SQL_Statement

select userenv('LANG') language,funding_source.funding_source_id funding_source_id,funding_source_name funding_source_name from gms_funding_sources_b funding_source,GMS_FUNDING_SOURCES_TL funding_sourcetl where funding_source.funding_source_id=funding_sourcetl.funding_source_id and funding_sourcetl.LANGUAGE= USERENV('LANG') and type='N'

UNION ALL

select userenv('LANG') language, funding_source_id funding_source_id,party_name funding_source_name from gms_funding_sources_b funding_source,hz_parties party where funding_source.source_id=party.party_id

UNION ALL

select userenv('LANG') language,funding_source_id funding_source_id,haotl.name funding_source_name from gms_funding_sources_b funding_source,HR_ORGANIZATION_UNITS_F_TL haotl where funding_source.source_id=haotl.ORGANIZATION_ID and haotl.LANGUAGE= USERENV('LANG')