Advanced Collections - EBS (MOSC)

MOSC Banner

Join JTF Notes_B to HZ Cust accounts

edited Nov 13, 2015 9:35AM in Advanced Collections - EBS (MOSC) 2 commentsAnswered ✓

Hello,

How can the JTF Notes_B be joined to HZ cust accounts. The source object code is 'IEX_INVOICES'. Basically I want to join the notes for each invoice transaction to get the customer name from HZ cust accounts and other information from  AR payment schedules. I wish to add the customer name and invoice amount and balance due to this query. Please advise.

SELECT JTF.JTF_NOTES_TL.*,

  JTF.JTF_NOTES_B.SOURCE_OBJECT_CODE AS SOURCE_OBJECT_CODE1

FROM JTF.JTF_NOTES_TL

INNER JOIN JTF.JTF_NOTES_B

ON JTF.JTF_NOTES_TL.JTF_NOTE_ID = JTF.JTF_NOTES_B.JTF_NOTE_ID

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