Many thanks for this Nathan, my sql is pretty much a beat for beat reflection of yours, so I am feeling like the issue is on the business process side, so again, a massive thank you for the functional details on how you are attaching the notes from the functional perspective, I am going to use this with the functional lead…

Hi Scott, trying to tackle the same probem via BI Publisher and finding that the standard MOS advice that the ZMM_NOTES.ource_object_uid joins to ra_customer_trx_all.customer_trx_id is wrong, so I am hoping you discovered a means to join these tables and are willing to share, did you succeed on this? Appreciate your time,…