Query to get the Transaction type Setup information from 11i system with GL code combinations

select a.set_of_books_id,org_id,
a.cust_trx_type_id,a.name, description,type,
a.credit_memo_type_id ,
a.post_to_gl,a.accounting_affect_flag,
a.credit_memo_type_id as Open_receivables,
status,default_printing_option,default_status,
(select distinct name from ra_cust_trx_types_all where cust_trx_type_id = a.credit_memo_type_id) as credit_memo_type,
( select name from ra_terms where term_id = a.default_term),
 a.gl_id_rev,
( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  a.gl_id_rev) as revenue,
gl_id_freight,
( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  a.gl_id_freight) as freight,
gl_id_rec,
( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  a.gl_id_rec) as receivables,
gl_id_clearing,
( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  a.gl_id_clearing) as clearing,
gl_id_unbilled,
( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  a.gl_id_unbilled) as Unbilled,
gl_id_tax,
( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  a.gl_id_tax) as tax,
gl_id_unearned,
( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  a.gl_id_unearned) as unearned,
allow_freight_flag,allow_overapplication_flag,creation_sign,tax_calculation_flag,natural_application_only_flag
---,exclude_from_late_charges,
---adj_post_to_gl
from ra_cust_trx_types_all a;

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