Query to get Concurrent Program Name from rtf name (link between XDO_lobs and fnd_concurrent_program))

SELECT DISTINCT user_concurrent_program_name
              , fcp.concurrent_program_name
              , xtt.template_name
              , xddv.data_source_name
              , xddv.data_source_code
              , xl.file_name
              , xl.lob_code
              , xl.LANGUAGE
              , xl.territory
              , xl.creation_date
              , xl.last_update_date
           FROM fnd_concurrent_programs_tl fcpt
              , fnd_concurrent_programs fcp
              , xdo_templates_b xtb
              , xdo_templates_tl xtt
              , xdo_ds_definitions_vl xddv
              , xdo_lobs xl
WHERE           fcpt.concurrent_program_id = fcp.concurrent_program_id
            AND xtb.data_source_code = fcp.concurrent_program_name
            AND xtb.template_code = xtt.template_code
            AND xtb.data_source_code = xddv.data_source_code
            AND xl.lob_code = xtb.template_code
            AND xl.xdo_file_type = xtb.template_type_code
            AND xl.file_name LIKE '%XXX_RAXINV_RTF_JAPAN_V16.rtf%'