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

Background:
For creating XML Publisher Report, we need to create Data Definition whose codeshould be exactly equal to the Application Short Name of the concurrent program. Then we create Template based on the Data Definition we have created.

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"
  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;

Post a Comment