select fad.seq_num, fad.entity_name, fad.pk1_value, fad.pk2_value
from fnd_attached_documents fad,
fnd_documents fd
fnd_lobs fl
where fad.document_id = fd.document_id
and fd.media_id = fl.file_id
Ref:
1.Oracle Apps: Helpful Queries on FND Attachments tables and sample code to extract attachments
http://johnytips.blogspot.com/2016/01/oracle-apps-helpful-queries-on-fnd.html
2.EBS Attachements表结构
https://blog.csdn.net/cunxiyuan108/article/details/6446698
沒有留言:
張貼留言
注意：只有此網誌的成員可以留言。