Query to find Data Definition, Template File Name of a Concurrent Program in Oracle Apps

Query to find Data Definition, Template File Name of a Concurrent Program in Oracle Apps

Script:

ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN';

SELECT  distinct xddv.data_source_code "Data Definition Code"

,xddv.data_source_code "Concurrent Short Name"

     ,  xddv.data_source_name "Data Definition"

     ,  xddv.description "Data Definition Description"

     ,  xtb.template_code "Template Code"

     ,  xtt.template_name "Template Name"

     ,  xtt.description "Template Description"

     ,  xtb.template_type_code "Type"

     ,  xl.file_name "File Name"

     ,  xtb.default_output_type "Default Output Type" , fat.application_name

  FROM  apps.xdo_ds_definitions_vl xddv

     ,  apps.xdo_templates_b xtb

     ,  apps.xdo_templates_tl xtt

     ,  apps.xdo_lobs xl

     ,  apps.fnd_application_tl fat

     ,  apps.fnd_application fa

 WHERE xddv.data_source_code = '&Concurrent_Program_Short_Name'

   AND xddv.application_short_name = fa.application_short_name

   AND fat.application_id = fa.application_id

   AND xtb.application_short_name = xddv.application_short_name

   AND xddv.data_source_code = xtb.data_source_code

   AND xtt.template_code = xtb.template_code

   AND xl.lob_code = xtb.template_code

   AND xl.xdo_file_type = xtb.template_type_code;

If you like please follow and comment