--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
R12公司银行账户SQL
最新推荐文章于 2022-05-07 16:24:51 发布