FND Lobs

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
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,
length(fl.file_data) file_size,
'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 NameSQL textValidation
File Name like
lower(fl.file_name) like lower(:file_name)
Char
File Content Type
fl.file_content_type=:file_content_type
LOV
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
Download
Related Blitz Reports
GL Journals (Drilldown) APL: AP Invoices and Lines LSE: AP Invoices and Lines(Test) WIP MES Job Traveler Data Template AP Invoices and Lines GL Journals (Drilldown) (TB) AR Customer Upload TB GL Journals (Drilldown) AT: GL Journals (Drilldown) XDO Publisher Data Definitions
Blitz Report™