Following are the tables involved in the Contract Attachments in Oracle Fusion.
1. FND_ATTACHED_DOCUMENTS
2. FND_DOCUMENTS_VL
Here is some more additional details for the WHERE clause which needed for the Contract Attachments.
a. FND_ATTACHED_DOCUMENTS.ENTITY_NAME = 'OKC_SUPPORTING_DOCS'
b. FND_ATTACHED_DOCUMENTS.PK1_VALUE = OKC_K_HEADERS_VL.ID
c. FND_ATTACHED_DOCUMETNS.DOCUMENT_ID =
FND_DOCUMENTS_VL.DOCUMENT_ID
No comments:
Post a Comment