Oracle-EBS-SQL/FND Lobs/FND Lobs.sql at master · Enginatics/Oracle-EBS-SQL · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
/*************************************************************************/
/*                                                                       */
/*                       (c) 2010-2024 Enginatics GmbH                   */
/*                              www.enginatics.com                       */
/*                                                                       */
/*************************************************************************/
-- Report Name: FND Lobs
-- Description: Generic file manager lob data, such as attachments, help files, imported and exported Blitz Report files etc.
-- Excel Examle Output: https://www.enginatics.com/example/fnd-lobs/
-- Library Link: https://www.enginatics.com/reports/fnd-lobs/
-- Run Report: https://demo.enginatics.com/

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