DBA Data[Home] [Help]

VIEW: APPS.GL_ALL_JE_SOURCE_NAME_VIEW

Source

View Text - Preformatted

SELECT s.je_source_name, s.user_je_source_name description FROM gl_je_sources s UNION SELECT l.lookup_code, l.meaning FROM gl_lookups l WHERE l.lookup_type = 'LITERAL' AND l.lookup_code = 'ALL'
View Text - HTML Formatted

SELECT S.JE_SOURCE_NAME
, S.USER_JE_SOURCE_NAME DESCRIPTION
FROM GL_JE_SOURCES S UNION SELECT L.LOOKUP_CODE
, L.MEANING
FROM GL_LOOKUPS L
WHERE L.LOOKUP_TYPE = 'LITERAL'
AND L.LOOKUP_CODE = 'ALL'