FND Help Documents and Targets

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Run FND Help Documents and Targets and other Oracle EBS reports with Blitz Report™ on our demo environment
select
fav.application_name,
fhd.application application_short_name,
fhd.file_name,
fhd.title,
fhd.language,
&target_name
fhd.custom_level,
fl.file_name full_file_name,
fl.program_tag,
&file_data
fl.file_content_type,
fl.upload_date,
fhd.file_id
from
fnd_application_vl fav,
fnd_help_documents fhd,
fnd_lobs fl,
(select fht.* from fnd_help_targets fht where '&show_targets'='Y') fht
where
1=1 and
xxen_util.application_short_name_trans(fav.application_short_name)=fhd.application and
fhd.file_id=fl.file_id(+) and
fhd.file_id=fht.file_id(+)
order by
application_name,
fhd.file_name,
fht.target_name
Parameter Name SQL text Validation
Application Name 
fav.application_name=:application_name
 LOV
Application Short Name 
fav.application_short_name=:short_name
 LOV
Show Targets 
Y
 LOV
Show File Data 
case when substr(fl.file_content_type,1,10)='text/html;' then xxen_util.blob_to_clob(fl.file_data) end file_data,
 LOV
Cutomization Level from 
fhd.custom_level>=:custom_level_from
 Number
Language Code 
fhd.language=:language
 LOV
Download
 
Related Blitz Reports
WIP MES Job Traveler Data Template EGO Item Image Definition Data Template FND Attached Documents GL Journals XDO Publisher Data Definitions PO Standard Notes Listing AP Invoices and Lines Blitz Report Example XLSX Files AP Payment Register- Not Supported: Reserved For Future Use
Blitz Report™

Blitz Report™ provides multiple benefits: