Code combination

select ACCT_CODE, count(ACCT_CODE)
 from xxgl_bal_updt fcb
having count(ACCT_CODE)>1
group by ACCT_CODE


select * from  gl_code_combinations gcc
where    gcc.segment1
       || '-'
       || gcc.segment2
       || '-'
       || gcc.segment3
       || '-'
       || gcc.segment4
       || '-'
       || gcc.segment5
       || '-'
       || gcc.segment6
       || '-'
       || gcc.segment7
       || '-'
       || gcc.segment8
       || '-'
       || gcc.segment9
       || '-'
       || gcc.segment10 ='124-000-000-0000-00000-126201-000-000-00000-00451'