FND Lobs
Description
Categories: Enginatics
Repository: Github
Repository: Github
Generic file manager lob data, such as attachments, help files, imported and exported Blitz Report files etc.
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
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 Name | SQL text | Validation | |
---|---|---|---|
File Name like |
|
Char | |
File Content Type |
|
LOV | |
Program Name |
|
LOV | |
File Format |
|
LOV | |
Language |
|
LOV | |
Include File Data |
|
LOV | |
Uploaded within x days |
|
Number | |
Non expiring only |
|
LOV |