FND Lobs

Description
Categories: Enginatics
Repository: Github Columns: File Id, File Name, File Content Type, Upload Date, Expiration Date, Program Name, Program Tag, Language, Oracle Charset, File Format ...
Generic file manager lob data, such as attachments, help files, imported and exported Blitz Report files etc.
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
Include File Data
xxen_util.blob_to_clob(fl.file_data) file_data,
LOV
Non expiring only
fl.expiration_date is null
LOV
Language
fl.language in (select fl.language_code from fnd_languages_vl flv where flv.description=:language)
LOV
File Name like
lower(fl.file_name) like lower(:file_name)
Program Name
fl.program_name=:program_name
LOV
File Format
fl.file_format=:file_format
LOV
Uploaded within x days
fl.upload_date>sysdate-:days
Number