Email note text for all outbound email interactions from Case

CRM 9.0
Tools 8.50

Correspondence management

To find out the email note text for all outbound email interactions from Case:

SELECT A.INTERACTION_ID , D.MSG_TEXT
FROM PS_RI_INTERACTION A , PS_RI_SUB_INTERACT B ,PS_RBC_RECIPIENT C , PS_RBC_RECP_EMAIL D WHERE A.INTERACTION_ID=B.INTERACTION_ID AND C.CMF_ID=D.CMF_ID AND C.INTERACTION_ID=A.INTERACTION_ID AND B.SUBINT_OBJ_TYPE='CASE'
AND A.INTERACTION_MTHD='OEML'
AND B.CASE_ID='1071547'