SELECT DISTINCT REQUEST_ID REQUEST_ID , SRC.JE_SOURCE_NAME SOURCE_NAME FROM GL_INTERFACE INT , GL_JE_SOURCES_TL SRC WHERE INT.REQUEST_ID IS NOT NULL AND INT.USER_JE_SOURCE_NAME = DECODE(SRC.IMPORT_USING_KEY_FLAG , 'Y' , SRC.JE_SOURCE_KEY , SRC.USER_JE_SOURCE_NAME) AND SRC.LANGUAGE = USERENV('LANG') UNION SELECT DISTINCT REQUEST_ID REQUEST_ID , JE_SOURCE_NAME SOURCE_NAME FROM GL_INTERFACE_CONTROL WHERE STATUS <> 'S' AND NVL(UPPER(INTERFACE_TABLE_NAME) , 'GL_INTERFACE') <> 'GL_INTERFACE'