Find a BI template based on a filename

Problem

You have a template file, but you can't figure out what template it belongs to

Solution

Run this piece of SQL, passing in the filename

select xt.template_code,  xd.application_short_name, xtt.template_name, xtt.description, xl.language, xl.territory, xl.file_name, xt.start_date template_start_date, xt.end_date template_end_date, xd.start_date data_src_start_date, xd.end_date data_src_end_Date
from XDO_TEMPLATES_B  xt,
     XDO_DS_DEFINITIONS_B xd,
     xdo_lobs xl,
     XDO_TEMPLATES_tl xtt
where xt.data_source_code = xd.data_source_code
and xl.lob_code = xt.template_code
and file_name like 'ABS_DE%Pack%'
 and xd.application_short_name   = xt.application_short_name
and xl.lob_type= 'TEMPLATE_SOURCE'
and xt.template_code = xtt.template_code
and xtt.language = 'US';