To Query Email templates

gistfile1.txt

select
  a.id as article_id, m.template_id, a.url || a.external_id as url, m.country_code, m.language_code, m.wildcard_exclusion_locales
from obs.ARTICLE a, email.template_dms_map m
where a.id = m.dms_id and m.mapping_on = 1
      and regexp_like(m.template_id,'salesorder','i')
--   and a.id in (77068)
order by lower(external_id);






select region_id, tag, value from obs.translations
where tag in ('ee.odyssey.welcomeToUsana.body1','ee.odyssey.welcomeToUsana.body2','ee.odyssey.welcomeToUsana.body3','ee.odyssey.welcomeToUsana.body4','ee.odyssey.welcomeToUsana.PC.body1','ee.odyssey.welcomeToUsana.PC.textbody1','ee.odyssey.welcomeToUsana.textBody1','ee.odyssey.welcomeToUsana.textBody2','ee.odyssey.welcomeToUsana.textBody3','ee.odyssey.welcomeToUsana.textBody4','ee.odyssey.welcomeToUsana.textBody5','ee.odyssey.welcomeToUsana.textBody6','EE.WelcomeToUsana._fromName','EE.WelcomeToUsana._subject','EE.WelcomeToUsana_Text._subject')
      and region_id like 'en%'
--   and regexp_like(value,'pwp','i')
order by region_id, lower(tag);