Join JTF Notes_B to HZ Cust accounts
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