SELECT *
  FROM temp.r_view
 WHERE cur IN (SELECT p_id_d
                      FROM temp.pm
                     WHERE p_id_h = 'CURRENCY' AND p_txt 
                               = 'EUR')
   AND rec_amt >= 10
   AND r_view.date_exec >
          TO_DATE ((SELECT p_txt
                      FROM temp.pm
                     WHERE p_id_h = 'MONETARY'
                       AND p_id_d = 'LAST_DATE'
                       AND p_id_t = 'S'),
                   'DD-MON-YYYY'
                  )
   AND SID NOT IN (
          SELECT gl_sid
            FROM s_wr.p_smst
           WHERE p_gst.p_idc =
                       (SELECT p_txt
                          FROM temp.pm
                         WHERE p_id_h  = 'MONETARY' 
                         AND   pm_id_d = 'MONETARY_ID'));

OPERATION	OPTIONS	    OBJECT_NAME 	POSITION
--------------------------  ------------ -------------
SELECT STATEMENT			         199600
FILTER		                	          1
HASH JOIN	RIGHT SEMI		          1
TABLE ACCESS	FULL	        PM	          1
VIEW		R_VIEW	                          2
UNION-ALL			                  1
TABLE ACCESS	FULL	        IN_CUST_TEMP	  1
TABLE ACCESS	FULL	        RC_REG_WORK	  2
HASH            JOIN		                  3
VIEW		                V_SQ_1	          1
HASH	        GROUP BY		                  1
TABLE ACCESS	FULL	        TP_MAIN_WORK	  1
TABLE ACCESS	FULL	        TP_MAIN_WORK	  2
TABLE ACCESS	FULL	        IN_SS_RELOAD	  4
TABLE ACCESS	FULL	        CTF_AORD_WORK	  5
TABLE ACCESS	FULL	        MANXA_RELOAD	  6
TABLE ACCESS	FULL	        STX_FR_PURSE	  7
TABLE ACCESS	BY INDEX ROWID	PM	          2
INDEX	        RANGE SCAN	K_PRM             1
TABLE ACCESS	BY INDEX ROWID	P_GST	          2
INDEX	        RANGE SCAN	ID1_P_GST         1
TABLE ACCESS	BY INDEX ROWID	PM	          1
INDEX	        RANGE SCAN	K_PM	          1