You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

URLs found in fnd_attached_documents but not displayed on Purchase Agreement UI

Summary: I'm trying to extract all current attachments (specifically URLs) for Purchase Agreements but I'm getting more records from the tables than what are actually displayed on the UI.


Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):



Code Snippet (add any code snippets that support your topic, if applicable):

Getting URLs from these tables:

from fnd_attached_documents fad
inner join fnd_documents_tl fdt on fad.document_id = fdt.document_id
inner join fnd_documents fd on fad.document_id = fd.document_id
where fad.entity_name in ('PO_PA_HEADERS')

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!