FND Help Documents and Targets

➜ Back to Library
Description
Categories: Enginatics
Repository: Github

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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 XXGL Journals GL Journals XDO Publisher Data Definitions PO Standard Notes Listing PO Approved Supplier List Blitz Report Example Excel Files
Blitz Report™

Blitz Report™ provides multiple benefits: