SELECT s.sit_id,-- identifiant du site 
       s.sit_numg2r,-- LPAD removed due to G2R code extension 
       s.sit_zpid,--ZP SITE CODE  -- Ran Sharing Lot 1 
       s.sit_nom,-- NOMSITE 
       s.sit_cooxsim,-- X_SIMU_SITE 
       s.sit_cooysim,-- Y_SIMU_SITE 
       s.sit_coozsim,-- Z_SIMU_SITE 
       s.reg_num,-- REGION 
       s.dep_num,-- DEPART 
       Nvl(z.zge_lib, '') -- ZONE_MKG 
FROM   site s, 
       zonegeo z, 
       region reg 
WHERE  s.sit_numg2r IS NOT NULL -- Le numero du site n'est pas vide 
       AND s.zge_id = z.zge_id (+) 
       AND s.reg_num = reg.reg_num 
       AND reg.reg_virt = 0 
        OR ( s.sit_zpid IS NOT NULL 
             AND s.sit_zpid NOT LIKE 'ZP%' ); 

SELECT e.lname
  FROM employee e,
       (SELECT dept_id
          FROM department
         WHERE NAME = 'ACCOUNTING') v
 WHERE e.dept_id(+) = v.dept_id;

AND s.zge_id = z.zge_id (+)  -->This One
       AND s.reg_num = reg.reg_num 
       AND reg.reg_virt = 0 
        OR ( s.sit_zpid IS NOT NULL -->This One
             AND s.sit_zpid NOT LIKE 'ZP%' ); 

SELECT * 
FROM   dept a, 
       emp b 
WHERE  a.deptno IS NOT NULL 
       AND a.deptno = b.deptno(+) 
        OR ( a.deptno IS NOT NULL 
             AND a.dname NOT LIKE 'AC%' ); 

SELECT DISTINCT ename 
FROM   emp a 
WHERE  EXISTS(SELECT 1 
              FROM   dept d 
              WHERE  a.deptno = d.deptno 
                      OR ( d.deptno IS NOT NULL 
                           AND d.dname NOT LIKE 'AC%' )) 

SELECT * 
FROM   emp b, 
       (SELECT * 
        FROM   dept a 
        WHERE  a.deptno IS NOT NULL 
               AND a.dname NOT LIKE 'AC%') a 
WHERE  b.deptno = a.deptno(+); 

WHERE (s.sit_numg2r IS NOT NULL -- Le numero du site n'est pas vide 
       AND s.zge_id = z.zge_id (+) 
       AND s.reg_num = reg.reg_num 
       AND reg.reg_virt = 0 
      )
      OR (s.sit_zpid IS NOT NULL 
          AND s.sit_zpid NOT LIKE 'ZP%' ); 

WHERE s.sit_numg2r IS NOT NULL -- Le numero du site n'est pas vide 
AND s.zge_id = z.zge_id (+) 
AND s.reg_num = reg.reg_num 
AND (reg.reg_virt = 0 
     OR (s.sit_zpid IS NOT NULL 
         AND s.sit_zpid NOT LIKE 'ZP%' 
        )
    );