FND Attached Documents

Description

Categories
Enginatics
Repository
GitHub
FND attachments stored in the fnd_lobs table and their corresponding application entity e.g. sales orders that they are attached to.

SQL 148 lines

Parameters 12

ParameterTypeList of values SQL
CategoryLOV
fdcv.user_name=:category
DatatypeLOV
fddv.user_name=:datatype
File Name containsChar
lower(fl.file_name) like '%'||:file_name||'%'
Short Text containsChar
fd.media_id in (select fdst.media_id from fnd_documents_short_text fdst where lower(fdst.short_text) like lower('%'||:short_text||'%'))
Text containsChar
lower(x.text) like lower('%'||:text||'%')
Creation Date fromDate
fd.creation_date>=:date_from
Creation Date toDate
fd.creation_date<:date_to+1
Created within daysNumber
fd.creation_date>=sysdate-:days
Created ByLOV
fd.created_by=xxen_util.user_id(:created_by)
Show Attachment ObjectsLOV
Y
Attached to ApplicationLOV
fd.document_id in (
select
fad.document_id
from
fnd_document_entities_vl fdev,
fnd_attached_documents fad
where
fdev.application_name=:application and
fdev.data_object_code=fad.entity_name)
Document EntityLOV
fd.document_id in (select fad.document_id from fnd_attached_documents fad where fad.entity_name=:data_object_code)