FND Help Documents and Targets

Description
Categories: Application, 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,
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
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
Show Targets
Y
LOV
Application Short Name
fav.application_short_name=:short_name
LOV
Language Code
fhd.language=:language
LOV
Show Targets
fht.target_name,
Cutomization Level from
fhd.custom_level>=:custom_level_from
Number