VIEW: APPS.GCS_GL_JI_GROUPS_V

Source

View Text - Preformatted

SELECT DISTINCT group_id, NULL interface_table_name, user_je_source_name, set_of_books_id, request_id FROM gl_interface WHERE group_id is not null UNION SELECT DISTINCT group_id, upper(interface_table_name) interface_table_name, src.user_je_source_name, set_of_books_id, request_id FROM gl_interface_control ic, gl_je_sources src WHERE ic.je_source_name = src.je_source_name AND group_id is not null AND nvl(upper(interface_table_name), 'GL_INTERFACE') <> 'GL_INTERFACE' ORDER BY 1

View Text - HTML Formatted

SELECT DISTINCT GROUP_ID
, NULL INTERFACE_TABLE_NAME
, USER_JE_SOURCE_NAME
, SET_OF_BOOKS_ID
, REQUEST_ID
FROM GL_INTERFACE
WHERE GROUP_ID IS NOT NULL UNION SELECT DISTINCT GROUP_ID
, UPPER(INTERFACE_TABLE_NAME) INTERFACE_TABLE_NAME
, SRC.USER_JE_SOURCE_NAME
, SET_OF_BOOKS_ID
, REQUEST_ID
FROM GL_INTERFACE_CONTROL IC
, GL_JE_SOURCES SRC
WHERE IC.JE_SOURCE_NAME = SRC.JE_SOURCE_NAME
AND GROUP_ID IS NOT NULL
AND NVL(UPPER(INTERFACE_TABLE_NAME)
, 'GL_INTERFACE') <> 'GL_INTERFACE' ORDER BY 1