Concurrent Program and XML Publisher or BI Publisher Data Definition and Template details

         select USER_CONCURRENT_PROGRAM_NAME, cpn.CONCURRENT_PROGRAM_NAME CONCURRENT_PROGRAM_SHORT_NAME,fe.EXECUTABLE_NAME 
         ,dsn.DATA_SOURCE_NAME, ds.DATA_SOURCE_CODE,tn.TEMPLATE_NAME,   t.TEMPLATE_CODE
          from apps.fnd_concurrent_programs_vl cpn, apps.FND_EXECUTABLES fe
          ,apps.XDO_DS_DEFINITIONS_b ds, apps.XDO_DS_DEFINITIONS_tl dsn, apps.XDO_TEMPLATES_B t
          ,apps.XDO_TEMPLATES_tl tn
          where  cpn.EXECUTABLE_ID = fe.EXECUTABLE_ID
          and ds.DATA_SOURCE_CODE = cpn.CONCURRENT_PROGRAM_NAME
          and ds.DATA_SOURCE_CODE = dsn.DATA_SOURCE_CODE
          and dsn.language = 'US'
          and ds.DATA_SOURCE_CODE = t.DATA_SOURCE_CODE
          and t.TEMPLATE_CODE = tn.TEMPLATE_CODE
          and tn.language = 'US'
          order by 1 desc;