View: IGI_CBR_GL_JOURNAL_SOURCES_V

Product:	IGI - Public Sector Financials International
Description:	Retrieves the journal source name from GL_JE_SOURCES_TL and links it with the ALL option from IGI_LOOKUPS for lookup_type IGI_CBR_JOURNAL_SOURCES.
Implementation/DBA Data:	APPS.IGI_CBR_GL_JOURNAL_SOURCES_V

View Text

SELECT USER_JE_SOURCE_NAME
, JE_SOURCE_NAME
FROM GL_JE_SOURCES_TL UNION SELECT DESCRIPTION USER_JE_SOURCE_NAME
, LOOKUP_CODE JE_SOURCE_NAME
FROM IGI_LOOKUPS
WHERE LOOKUP_TYPE ='IGI_CBR_JOURNAL_SOURCES'

Columns