Maintenance Asset Notes table query

We need to extract all the Asset Notes associated with the Maintenance Assets (CSE_ASSETS). Can someone provide the table name from which the Maintenance Asset Notes is stored, and what is reference ID in order to join with the CSE_ASSETS_B to capture the associated Asset number.

Thanks. Appreciate the help.