sql

select 
  cco.option_code, substr(cco.option_code, 18) pt_code, pt.payment_type_id 
  from psec_client_config_option cco, paycfg_payment_type pt
  where substr(cco.option_code, 18) = pt.payment_type_id 
  --where cco.client_code = pt.client_code
  and cco.option_code like 'ACCOUNT_PATTERN%' 
  and cco.client_code = ( select client_code from psec_client where short_name = upper('cott')) 
  order by pt_code;