Skip to content

Instantly share code, notes, and snippets.

@nastajus

nastajus/sql

Created November 9, 2015 19:55
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nastajus/7866eef071dca31f1704 to your computer and use it in GitHub Desktop.
Save nastajus/7866eef071dca31f1704 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment