FND Help Documents and Targets
Description
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 |
|
LOV | |
Application Short Name |
|
LOV | |
Show Targets |
|
LOV | |
Show File Data |
|
LOV | |
Cutomization Level from |
|
Number | |
Language Code |
|
LOV |