Query to get the Receipt Methods in 11i with Bank account details including GL Code Combinations

SELECT arma.org_id,ARC.NAME RECEIPT_CLASS,ARC.receipt_class_ID,ARC.CREATION_METHOD_CODE,
ARC.REMIT_FLAG,ARC.CREATION_STATUS,
ARM.NAME RECEIPT_M,
ARM.END_DATE as receipt_method_end_date,
ARM.RECEIPT_METHOD_ID,
ARMA.ORG_ID,
arma.earned_ccid,
arma.end_date as recipt_bankacc_end_date,
arma.primary_flag,
( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  ARMA.earned_ccid) as earned_disc,
arma.edisc_receivables_trx_id,
(SELECT NAME FROM AR_RECEIVABLES_TRX_ALL WHERE receivables_trx_id=ARMA.edisc_receivables_trx_id) as edisc_receivables_activ,
arma.unedisc_receivables_trx_id,
(SELECT NAME FROM AR_RECEIVABLES_TRX_ALL WHERE receivables_trx_id=ARMA.unedisc_receivables_trx_id) as unedisc_receivables_activ,
arma.unearned_ccid,
( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  ARMA.unearned_ccid) as unearned_disc,
arma.on_account_ccid,
( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  ARMA.on_account_ccid) as on_account,
arma.unapplied_ccid,
( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  ARMA.unapplied_ccid) as unapplied,
arma.unidentified_ccid,
( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  ARMA.unidentified_ccid) as Unidentified,
 arma.bank_charges_ccid,
 ( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  ARMA.bank_charges_ccid) as bank_charges,
 arma.receipt_clearing_ccid,
 ( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  ARMA.receipt_clearing_ccid) as receipt_clearing,
 arma.remittance_ccid,
  ( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  ARMA.remittance_ccid) as remittance,
 ARMA.CASH_CCID,
 ( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  ARMA.CASH_CCID) as cash,
 br.BANK_NAME,
br.BANK_BRANCH_NAME,APB.BANK_ACCOUNT_NAME,apb.BANK_ACCOUNT_NUM,
apb.CURRENCY_CODE
FROM AR_RECEIPT_METHODS ARM,AR_RECEIPT_CLASSES ARC,AR_RECEIPT_METHOD_ACCOUNTS_ALL ARMA,
AP_BANK_ACCOUNTS_ALL APB,ap_bank_branches br
WHERE  ARM.RECEIPT_METHOD_ID=ARMA.RECEIPT_METHOD_ID
AND ARC.receipt_class_ID=ARM.receipt_class_ID
AND APB.BANK_ACCOUNT_ID=ARMA.BANK_ACCOUNT_ID
and br.bank_branch_id=apb.bank_branch_id