sir please check below query & correct me.
select (select RC.CUSTOMER_NUMBER from RA_CUSTOMERS RC WHERE RC.CUSTOMER_ID=ABC.CUSTOMER_ID )CUSTOMER_NUMBER,
(select RC.CUSTOMER_NAME from RA_CUSTOMERS RC WHERE RC.CUSTOMER_ID=ABC.CUSTOMER_ID )CUSTOMER_NAME,
abc.CT_REFERENCE,abc.COMMENTS,
...