Need query for notes created on transaction level and customer level at collections dashboard

Summary:

Need query for notes created on transaction level and customer level at collections dashboard

Content (required):

following query only return notes at transaction level at receivables>billing level

select a.trx_number,

trunc(a.trx_date),

a.paying_customer_id,

b.NOTE_TYPE_CODE,

b.NOTE_TXT,

b.SOURCE_OBJECT_CODE,

b.VISIBILITY_CODE,

b.CREATED_BY,

b.CREATION_DATE ,

b.SOURCE_OBJECT_UID

from FUSION.RA_CUSTOMER_TRX_ALL a, FUSION.ZMM_NOTES b

where 1=1

and a.CUSTOMER_TRX_ID = b.SOURCE_OBJECT_UID

and a.trx_number='10000'

Version (include the version you are using, if applicable):