How to get AR billing transaction note plain text without html tag ?

Hi All,

I'd like to build a customer report about AR billing which contains note. While I found the note in backend table contains html tags.

Note in the UI:

SQL result：

SQL I use：

select DBMS_LOB.SUBSTR( NOTE_TXT,4000,1) NOTE_TXT, SOURCE_OBJECT_UID from FUSION.ZMM_NOTES
where 1=1
and SOURCE_OBJECT_UID =:customer_trx_id

May I know is there a way to get the plain text note?

Thanks in Advance!

Weitao