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