DECLARE
  	 CURSOR C_TXT1 IS SELECT mprdh_no|| chr(9) ||ACNT_NAME|| chr(9) ||to_char(mprd_amount,'999999,990')
			FROM MPR_FORMD,ACCOUNTS_MASTER									
			WHERE  ACNT_CODE = MPRD_ITEM_CODE
			AND    MPRDH_NO = 384;

  	VAL VARCHAR2(4000);
  	ed_ok   BOOLEAN;
  BEGIN
	OPEN  C_TXT1;
  	FETCH C_TXT1 INTO VAL;  
  	CLOSE C_TXT1;
  	
Show_Editor( 'REMARKS_EDIT', val, 250,150, val, ed_ok); 

  END; 

the below query resutl is expected as seen from running at the sql prompt;

SQL> SELECT mprdh_no|| chr(9) ||ACNT_NAME|| chr(9) ||to_char(mprd_amount,'999999,990')
  2     FROM MPR_FORMD,ACCOUNTS_MASTER
  3  WHERE  ACNT_CODE = MPRD_ITEM_CODE           
  4  AND    MPRDH_NO = 384;

MPRDH_NO||CHR(9)||ACNT_NAME||CHR(9)||TO_CHAR(MPRD_AMOUNT,'999999,990')
----------------------------------------------------------------------------------------------------
384     R&M DOOR ACCESS CONTROL SYSTEM          143
384     R&M DOOR ACCESS CONTROL SYSTEM          143
384     R&M CEILING FAN          45
384     R&M CEILING FAN          15

declare
  val     varchar2(4000);
  ed_ok   BOOLEAN;
begin
  for cur_r in 
    (select mprdh_no|| chr(9) ||ACNT_NAME|| chr(9) ||to_char(mprd_amount,'999999,990') val
     FROM MPR_FORMD,ACCOUNTS_MASTER									
     WHERE  ACNT_CODE = MPRD_ITEM_CODE
	   AND  MPRDH_NO = 384
    )
  loop
    val := val || chr(10) || cur_r.val;
  end loop;

  Show_Editor( 'REMARKS_EDIT', val, 250,150, val, ed_ok); 
END;