VIEW: APPS.GL_INTERFACE_SOURCES_V

Source

View Text - Preformatted

SELECT distinct s.user_je_source_name, c.request_id, c.group_id, c.set_of_books_id from gl_interface c, gl_je_sources s WHERE s.user_je_source_name = c.user_je_source_name and c.request_id is not null

View Text - HTML Formatted

SELECT DISTINCT S.USER_JE_SOURCE_NAME
, C.REQUEST_ID
, C.GROUP_ID
, C.SET_OF_BOOKS_ID
FROM GL_INTERFACE C
, GL_JE_SOURCES S
WHERE S.USER_JE_SOURCE_NAME = C.USER_JE_SOURCE_NAME
AND C.REQUEST_ID IS NOT NULL