Here’s an example of how you can join this, however, note that you can have multiple notes per oe_hdr record so you may have to make a decision on which one to use.
select p21_view_oe_hdr.order_no, note_id, topic, note from p21_view_oe_hdr
left join oe_hdr_notepad on oe_hdr_notepad.order_no = p21_view_oe_hdr.order_no
where p21_view_oe_hdr.order_no = 1000001
I get this data from my db
order_no
note_id
topic
note
1000001
4
ERP Transition Invoice
ERP Transition- Old Invoice # 01-123456
1000001
73
tax
#1000-6881
1000001
74
note
Original invoice # 01-123456A – Please use new invoice # to pay against