FND Lobs
Description
- Categories
- Enginatics
- Repository
- GitHub
Generic file manager lob data, such as attachments, help files, imported and exported Blitz Report files etc.
Template Summary by Program shows the space per program and whether the files have expired, which is what Purge Obsolete Generic File Manager Data removes.
Template Summary by Program shows the space per program and whether the files have expired, which is what Purge Obsolete Generic File Manager Data removes.
SQL 22 lines
select fl.file_id, fl.file_name, fl.file_content_type, &file_data fl.upload_date, fl.expiration_date, xxen_util.yes(case when fl.expiration_date<sysdate then 'Y' end) expired, 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 |
Parameters 8
| Parameter | Type | List of values SQL | |
|---|---|---|---|
| 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 |
|