  variable v1    NUMBER;
  variable v2    VARCHAR2(128);
  variable v3    NUMBER;
  variable v4    VARCHAR2(128);

  execute :v1 := 170;
  execute :v2 := '_ADeWgMKGEembR6u9VAN_tw';
  execute :v3 := 170;
  execute :v4 := '_ye5P0BFaEeybd5Btn3fajw';

set PAGESIZE 0
set linesize 999

SELECT /*+ gather_plan_statistics */ t1.item_id, t1.state_id, t1.jz_discriminator
FROM   (SELECT t1q.*,
               T1V.item_type_dbid
        FROM   qa_qm.execution_execution_task_reslt t1q
               INNER JOIN qa_qm.repository_version T1V
                       ON T1V.state_id = t1q.state_id
        WHERE  T1V.item_type_dbid = :v1
               AND T1V.config_id = :v2
               AND T1V.is_current = 1
               AND t1q.jz_discriminator = :v3) t1
       LEFT OUTER JOIN qa_qm.process_process_area t3
                    ON ( t1.project_area_item_id = t3.item_id )
WHERE  ( EXISTS (SELECT 1
                 FROM   qa_qm.execution_exctn_rslt_stp_rslts x1
                 WHERE  t1.execution_result_step_results = x1.jz_parent_id
                        AND x1.item_id = :v4)
         AND ( t3.project_area_item_id = '_0yZ0cL1WEei-d-PmOaCn5A' ) )  
		 ;
		 
SELECT * FROM table(DBMS_XPLAN.DISPLAY_CURSOR(FORMAT=>'ALLSTATS LAST ALL +OUTLINE'));