DBA Data[Home] [Help]

VIEW: APPS.IGI_CBR_GL_JOURNAL_SOURCES_V

Source

View Text - Preformatted

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'
View Text - HTML Formatted

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'