Sunday, 16 June 2019

How to build a BI Publisher data model query with receivables transactions information and notes text.

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