FND Lobs

Description
Categories: Enginatics
Repository: Github
Generic file manager lob data, such as attachments, help files, imported and exported Blitz Report files etc.
Run FND Lobs and other Oracle EBS reports with Blitz Report™ on our demo environment
select
fl.file_id,
fl.file_name,
fl.file_content_type,
&file_data
fl.upload_date,
fl.expiration_date,
fl.program_name,
fl.program_tag,
fl.language,
fl.oracle_charset,
fl.file_format,
'select fl.* from fnd_lobs fl where fl.file_id='||fl.file_id sql_text
from
fnd_lobs fl
where
1=1
order by
fl.upload_date desc nulls last,
fl.file_id desc
Parameter Name SQL text Validation
File Name like
lower(fl.file_name) like lower(:file_name)
Char
Program Name
fl.program_name=:program_name
LOV
File Format
fl.file_format=:file_format
LOV
Language
fl.language in (select flv.language_code from fnd_languages_vl flv where flv.description=:language)
LOV
Include File Data
xxen_util.blob_to_clob(fl.file_data) file_data,
LOV
Uploaded within x days
fl.upload_date>sysdate-:days
Number
Non expiring only
fl.expiration_date is null
LOV