SELECT A.LEDGER_ID , A.SUMMARY_CODE_COMBINATION_ID , A.DETAIL_CODE_COMBINATION_ID , A.TEMPLATE_ID , '_KF:SQLGL:GL#:GCC:_CO' FROM GL_ACCOUNT_HIERARCHIES A , GL_CODE_COMBINATIONS_KFV GCC WHERE A.SUMMARY_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID WITH READ ONLY