2023.05.25(누락된 우괄호)

...
AND ORDR_NO IN (
	        SELECT   
                   ORDR.ORDR_NO   
            FROM   GXEXRGEXM  GEXM
                 , GZCDCODCD  ODCD
                 , GRODMORDR  ORDR
                 , V_WPPIMINFO INFO
                 , (
                        SELECT ORDR_CD
                             , USE_SEX_CD
                             , MAX(EXM_RFVL_LOW_VAL)    AS EXM_RFVL_LOW_VAL
                             , MAX(EXM_RFVL_UPLMT_VAL)  AS EXM_RFVL_UPLMT_VAL
                         FROM GXEXDRFVL 
                        WHERE RSLT_JUDG_CD  = 'A'
                          AND APPLY_END_DT  ='99991231'
                        GROUP BY ORDR_CD , USE_SEX_CD
                   ) RFVL   
                 , (
                     SELECT ENG_NM AS ORDR_CD, DTL_CD, KOR_NM 
                       FROM GZCDCORCD
                      WHERE SYNTH_CD = 'RESULT-ITEM'
                        AND END_DT   = '99991231'
                        AND ATRI_VAL4 = 'Y'
                  ) ORCD  
                 , (
                        SELECT 
                                 PATNO
                               , VIST_SN
                               , HE_DT
                               , HE_CUSTM_SET_CD
                        FROM GRRVRMTCH 
                        WHERE HE_BASIS_PKG_CD LIKE 'geJ%'
                    ) MTCH
            WHERE GEXM.PATNO           = '14864481'
              AND GEXM.PATNO           = INFO.PATNO
              AND GEXM.VIST_SN         = 50
              AND GEXM.HE_DT           = '20230516'
              AND GEXM.PATNO           = MTCH.PATNO
              AND GEXM.VIST_SN         = MTCH.VIST_SN
              AND GEXM.HE_DT           = MTCH.HE_DT
              AND GEXM.PATNO           = ORDR.PATNO
              AND GEXM.VIST_SN         = ORDR.VIST_SN
              AND GEXM.HE_DT           = ORDR.HE_DT
              AND MTCH.HE_CUSTM_SET_CD = ORDR.HE_PKG_CD
              AND GEXM.ORDR_CD         = ODCD.ORDR_CD
              AND GEXM.ORDR_CD         = RFVL.ORDR_CD(+)
              AND GEXM.ORDR_CD         = ORCD.ORDR_CD
              AND GEXM.ORDR_CD         = ORDR.ORDR_CD
              AND GEXM.ORDR_DTL_CD     = ORCD.DTL_CD
              AND (INFO.SEX_CD         = RFVL.USE_SEX_CD 
                    OR 'B'             = RFVL.USE_SEX_CD )   
              AND INFO.VALD_YN         = 'Y'
            ORDER BY EXAM_ITEM_CLSF_CD 	
	)	

IN 절에 오더바이절이 있어서 자꾸 누락된 우괄호가 발생
오더바이절만 지우니까 조회됨