Script to find details of Data Definition, Template, File Name of a Concurrent Program

 Script:

Provide Concurrent Program Short Name, Application Name (Eg. General Ledger) to the following script. It gets Data Definition information & Template information for you.

SELECT XDDV.data_source_code "Data Definition Code",
       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,

       XL.language,
       XL.territory
  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 = '&CP_Short_Name'
       AND FAT.application_name = '&Application_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

       AND XTT.language = 'US'

       AND FAT.language = 'US';