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
[Home] [Help]