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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

not finding a link between the tables RCV_SHIPMENT_LINES and FND_DOCUMENTS_TL

in Purchasing 3 comments

Summary:

We are not finding a link between the tables RCV_SHIPMENT_LINES and FND_DOCUMENTS_TL

ASN detail is stored in RCV_SHIPMENT_HEADERS and RCV_SHIPMENT_LINES. We have a link between these two tables i.e. SHIPMENT_HEADER_ID.

ASN attachments details are stored in FND_ATTACHED_DOCUMENTS and FND_DOCUMENTS_TL . We have a link between these two tables i.e. DOCUMENT_ID.

But there is no link between the tables RCV_SHIPMENT_LINES and FND_DOCUMENTS_TL.

Because of this reason, we are not able to fetch the data from tables about attachments at ASN line level for a given ASN.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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