AR- Receipt Class, Method and Remittance Bank Account Query

AR- Receipt Method and Remittance Bank Account Query
--------------------------------------------------------------------

select rc.name Receipt_Class, rm.name Receipt_Method, rma.REMIT_BANK_ACCT_USE_ID, bb.BANK_NAME, bb.BANK_BRANCH_NAME,
cba.BANK_ACCOUNT_NAME, cba.BANK_ACCOUNT_NUM, cba.account_owner_org_id ACCT_OWNER_LE_ID ,cba.CURRENCY_CODE,
rma.CASH_CCID, rma.ON_ACCOUNT_CCID, rma.UNAPPLIED_CCID, rma.UNIDENTIFIED_CCID, rma.BANK_CHARGES_CCID , rma.RECEIPT_CLEARING_CCID, rma.REMITTANCE_CCID
, c(rma.CASH_CCID)
from ar_receipt_methods rm, ar_receipt_classes rc, ar_receipt_method_accounts_all rma,
ce_bank_accounts cba, ce_bank_acct_uses_all ba, ce_bank_branches_v bb, gl_code_combinations_kfv c
where rc.RECEIPT_CLASS_ID = rm.RECEIPT_CLASS_ID
and rm.RECEIPT_METHOD_ID = rma.RECEIPT_METHOD_ID
and rma.REMIT_BANK_ACCT_USE_ID = ba.BANK_ACCT_USE_ID
and rma.ORG_ID = ba.ORG_ID
and ba.BANK_ACCOUNT_ID = cba.BANK_ACCOUNT_ID
and cba.BANK_ID = bb.BANK_PARTY_ID
and cba.BANK_BRANCH_ID = bb.BRANCH_PARTY_ID
and rma.CASH_CCID=c.CODE_COMBINATION_ID and c.segment6='220034'