Find Template Details
select b.template_id,
b.application_id,
b.application_short_name,
b.template_code,
l.template_name,
l.description,
b.ds_app_short_name,
b.template_type_code,
l.source_lang
from xdo_templates_b b, xdo_templates_tl l
where b.template_code = l.template_code
Order by 3