R12公司银行账户SQL

--R12公司银行账户SQL：
/*BEGIN 
  mo_global.init('M');
END;*/
SELECT BA.BANK_ACCOUNT_NAME,
       BA.BANK_ACCOUNT_NUM,
       BA.BANK_ACCOUNT_ID,
       BA.CURRENCY_CODE BANK_CURRENCY_CODE,
       CBAU.BANK_ACCT_USE_ID,
       BA.MULTI_CURRENCY_ALLOWED_FLAG BANK_MULTI_CURRENCY_FLAG,
       BA.ZERO_AMOUNT_ALLOWED BANK_ZERO_AMOUNTS_ALLOWED,
       BA.ACCOUNT_OWNER_ORG_ID LEGAL_ENTITY_ID,
       CBB.BANK_PARTY_ID BANK_ID,
       CBB.BANK_NAME,
       CBB.BRANCH_PARTY_ID,
       CBB.BANK_BRANCH_NAME
  FROM CE_BANK_ACCOUNTS       BA,
       CE_BANK_BRANCHES_V     CBB,
       CE_BANK_ACCT_USES_OU_V CBAU
 WHERE CBAU.BANK_ACCOUNT_ID = BA.BANK_ACCOUNT_ID
   AND SYSDATE BETWEEN TRUNC(CBB.START_D