SELECT INT.GROUP_ID GROUP_ID , LGR.LEDGER_ID LEDGER_ID , SRC.JE_SOURCE_NAME JE_SOURCE_NAME FROM GL_JE_SOURCES SRC , GL_LEDGERS LGR , GL_INTERFACE INT WHERE ( INT.USER_JE_SOURCE_NAME = DECODE(SRC.IMPORT_USING_KEY_FLAG , 'Y' , SRC.JE_SOURCE_KEY , SRC.USER_JE_SOURCE_NAME) AND INT.SET_OF_BOOKS_ID = LGR.LEDGER_ID AND INT.LEDGER_ID = -1 AND INT.GROUP_ID IS NOT NULL) OR ( INT.USER_JE_SOURCE_NAME = DECODE(SRC.IMPORT_USING_KEY_FLAG , 'Y' , SRC.JE_SOURCE_KEY , SRC.USER_JE_SOURCE_NAME) AND INT.LEDGER_ID = LGR.LEDGER_ID AND INT.SET_OF_BOOKS_ID IN (-1 , LGR.LEDGER_ID) AND INT.GROUP_ID IS NOT NULL) GROUP BY INT.GROUP_ID , LGR.LEDGER_ID , SRC.JE_SOURCE_NAME UNION SELECT CTRL.GROUP_ID GROUP_ID , CTRL.SET_OF_BOOKS_ID LEDGER_ID , CTRL.JE_SOURCE_NAME JE_SOURCE_NAME FROM GL_INTERFACE_CONTROL CTRL WHERE GROUP_ID IS NOT NULL AND NVL(UPPER(INTERFACE_TABLE_NAME) , 'GL_INTERFACE') <> 'GL_INTERFACE' GROUP BY GROUP_ID , SET_OF_BOOKS_ID , JE_SOURCE_NAME