Technology Stack - EBS (MOSC)

MOSC Banner

Linking Attached Documents Back To Customers

edited Aug 20, 2021 11:01AM in Technology Stack - EBS (MOSC) 1 commentAnswered

Hello:

Our A/R department attaches notes to new customers using the document attachment feature.  We only use long text.

I have a query that shows all the long text documents attached to A/R Customers shown below.

It shows the notes the A/R specialist enters for a customer.

However, I need to know the customer number for the note.

How can I link the note to a specific customer number?

Here's the query that produces the data sample shown below:

select fad.pk1_value  -- cust_account_id

      ,fad.seq_num

      ,fad.category_id

      ,fad.document_id

      ,fd.datatype_id

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center