How to build a BI Publisher data model query with receivables transactions information and notes text.
In other words, how to link the tables RA_CUSTOMER_TRX_ALL with ZMM_NOTES.
--------------------------
SOLUTION: Following sample query can be used to join RA_CUSTOMER_TRX_ALL with ZMM_NOTES.
SELECT *
FROM ra_customer_trx_all trx,
zmm_notes note
WHERE note.source_object_code = 'AR_TRANSACTION'
AND trx.customer_trx_id = note.source_object_uid
No comments:
Post a Comment