FND Help Documents and Targets

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
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 NameSQL textValidation
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
AP Invoices and Lines EGO Item Image Definition Data Template COPY OF: AP Invoices and Lines AP Invoices and Lines - Test FND Attached Documents LSE: AP Invoices and Lines(Test) WIP MES Job Traveler Data Template GL Journals (Drilldown) AT: GL Journals (Drilldown)
Blitz Report™