SQLÓÅ»¯ÎÊÌâ

  SELECT
      DISTINCT 'I_PRD01 ' || WPRD.PLN_DAT || WPRD.PLN_SEQ || WPRD.L1_FIN_PROC_LOC_CNV AS IP_KEY

        from  W_PRD01_RECOM WPRD
                where
              not  exists (
                select TEH.efct_beg_dt
          ,TEH.efct_end_dt
          ,b02.MODEL_Y_CD AS MODEL_Y_CD
          ,b02.MODEL_CD
          ,b02.TYPE_CD
          ,b02.OPTION_CD
          ,b02.L1_FIN_PROC_LOC_CNV AS FIN_PROC
          ,b02.DC_PART_NO
          ,b02.PART_CLR_CD
          from i_bom02 b02, i_teh01 TEH , W_SHIP_PLN_RECOM ship_plan
        where b02.BASIC_PART_NO = TEH.basic_part_no
          and trim(TEH.pl_f) = trim(substr(b02.loc_cd_from, 1, 4)) ||
              trim(substr(b02.loc_l_no_from, 1, 2))
          and trim(TEH.pl_t) = trim(substr(b02.loc_cd_to, 1, 4)) ||
              trim(substr