[Oracle]Query Receipt Methods收款方式三層

SELECT ARC.NAME                      收款類別,
       ARM.NAME                      收款方式,
       ARM.START_DATE,
       ARM.END_DATE,
       ARMA.ORG_ID                   營運單位ID,
       CBBV.BANK_NAME                銀行名稱,
       CBBV.BANK_BRANCH_NAME         分行名稱,
       CBA.BANK_ACCOUNT_NAME         銀行帳戶名稱,
       CBA.BANK_ACCOUNT_NUM          銀行帳號,
       CBA.CURRENCY_CODE             帳戶幣別,
       ARMA.START_DATE,
       ARMA.END_DATE,
       ARMA.CASH_CCID,
       GCC1.SEGMENT1 ||'.'||GCC1.SEGMENT2||'.'||GCC1.SEGMENT3||'.'||GCC1.SEGMENT4||'.'||GCC1.SEGMENT5||'.'||GCC1.SEGMENT6 現金,
       ARMA.RECEIPT_CLEARING_CCID,
       GCC2.SEGMENT1 ||'.'||GCC2.SEGMENT2||'.'||GCC2.SEGMENT3||'.'||GCC2.SEGMENT4||'.'||GCC2.SEGMENT5||'.'||GCC2.SEGMENT6 收款確認,
       ARMA.REMITTANCE_CCID,
       ARMA.BANK_CHARGES_CCID,
       ARMA.UNAPPLIED_CCID,
       ARMA.UNIDENTIFIED_CCID,
       ARMA.ON_ACCOUNT_CCID
  FROM APPS.AR_RECEIPT_CLASSES             ARC,
       APPS.AR_RECEIPT_METHODS             ARM,
       APPS.AR_RECEIPT_METHOD_ACCOUNTS_ALL ARMA, -- 關聯中間表
       APPS.CE_BANK_ACCT_USES_ALL          CBAU, -- 帳戶使用表
       APPS.CE_BANK_ACCOUNTS               CBA, -- 銀行帳戶表
       APPS.CE_BANK_BRANCHES_V             CBBV, -- 銀行分行檢視表 (包含銀行名稱)
       APPS.GL_CODE_COMBINATIONS            GCC1,
       APPS.GL_CODE_COMBINATIONS            GCC2
 WHERE ARC.RECEIPT_CLASS_ID = ARM.RECEIPT_CLASS_ID
   AND ARM.RECEIPT_METHOD_ID = ARMA.RECEIPT_METHOD_ID
   AND ARMA.REMIT_BANK_ACCT_USE_ID = CBAU.BANK_ACCT_USE_ID
   AND CBAU.BANK_ACCOUNT_ID = CBA.BANK_ACCOUNT_ID
   AND CBA.BANK_BRANCH_ID = CBBV.BRANCH_PARTY_ID
   AND ARMA.CASH_CCID = GCC1.CODE_COMBINATION_ID
   AND ARMA.RECEIPT_CLEARING_CCID = GCC2.CODE_COMBINATION_ID
   AND ARC.NAME = 'ACETW_收票'
   AND ARM.NAME = 'TW_票據-中信#6146'
   AND TRUNC(NVL(ARMA.END_DATE, SYSDATE + 1)) > TRUNC(SYSDATE)
 ORDER BY ARM.NAME, ARMA.ORG_ID;