Oracle SQL例子

SELECT tobe_customer_cd,
       tobe_style_seq,
       TorihikiKozaCd
FROM   (SELECT t4.tobe_customer_cd,
               t4.tobe_style_seq,
               t3.TorihikiKozaCd
        FROM   (SELECT t12.SubSystemCd,
                       t12.HimokuCd
                FROM   (SELECT *
                        FROM   TMK_SUBKOKYAKU
                        WHERE  SubSystemCd = '01'
                        AND    DankoKbn = '2' ) t11, -- 既存顧客マスタ（２：団体）
                       TMT_KOKYAKUHIMOKU t12 -- 顧客費目マスタ
                WHERE  t12.SubSystemCd = t11.SubSystemCd
                AND    t12.KokyakuCd = t11.KokyakuCd
                GROUP  BY t12.SubSystemCd,
                          t12.HimokuCd) t1,
               ( SELECT *
                FROM   TMT_HIMOKU
                WHERE  HimokuNo <> '85' ) t2, -- 費目マスタ
               TMT_SKOZA t3, -- 請求取引口座マスタ
               MTCST_BILLING_STYLES_INDEX t4 -- 請求条件インデックス
        WHERE  t2.SubSystemCd = t1.SubSystemCd
        AND    t2.KokyakuCd = t1.HimokuCd
        AND    t3.SubSystemCd = t2.SubSystemCd
        AND    t3.KokyakuCd = t2.KokyakuCd
        AND    t3.HimokuNo = t2.HimokuNo
        AND    t4.ASIS_CUSTOMER_CD = t3.KokyakuCd
        AND    t4.ASIS_STYLE_SEQ = t3.HimokuNo)
GROUP  BY tobe_customer_cd,
          tobe_style_seq,
          TorihikiKozaCd
HAVING COUNT (*) > 1