Query to get the 11i Bank Accounts Setup Data

SELECT ABAA.SET_OF_BOOKS_ID,ABAA.ORG_ID,ABAA.CURRENCY_CODE,ABAA.MULTI_CURRENCY_FLAG,abaa.bank_account_id,abAa.bank_accounT_NAME,ABAA.BANK_ACCOUNT_NUM,
ABAA.CONTACT_FIRST_NAME AS BANKACC_CNCT_FIRST,
ABAA.CONTACT_MIDDLE_NAME  AS BANKACCT_CNCT_MID,ABAA.CONTACT_LAST_NAME AS BANKACC_CNCT_LAST,
ABAA.CONTACT_PREFIX,ABAA.CONTACT_TITLE,ABAA.INACTIVE_DATE,
ABAA.DESCRIPTION AS BANKACC_DESCRIPTION,ABAA.BANK_BRANCH_ID,ABAA.BANK_ACCOUNT_TYPE,ABAA.VALIDATION_NUMBER,ABAA.ACCOUNT_TYPE,ABAA.POOLED_FLAG,ABAA.ZERO_AMOUNTS_ALLOWED,
ABAA.RECEIPT_MULTI_CURRENCY_FLAG,ABAA.ALLOW_MULTI_ASSIGNMENTS_FLAG,ABAA.IBAN_NUMBER,
ABAA.ASSET_CODE_COMBINATION_ID,
( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  ABAA.ASSET_CODE_COMBINATION_ID) as ASSET_CODE_COMBINATION,
ABAA.GAIN_CODE_COMBINATION_ID,
( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  ABAA.GAIN_CODE_COMBINATION_ID) as GAIN_CODE_COMBINATION,
ABAA.LOSS_CODE_COMBINATION_ID,
( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  ABAA.LOSS_CODE_COMBINATION_ID) as LOSS_CODE_COMBINATION,
ABAA.CASH_CLEARING_CCID,
( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  ABAA.CASH_CLEARING_CCID) as CASH_CLEARING,
ABAA.BANK_CHARGES_CCID,
( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  ABAA.BANK_CHARGES_CCID) as BANK_CHARGES,
ABAA.BANK_ERRORS_CCID,
( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  ABAA.BANK_ERRORS_CCID) as BANK_ERRORS,
ABAA.EARNED_CCID,
( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  ABAA.EARNED_CCID) as EARNED,
ABAA.UNEARNED_CCID,
( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  ABAA.UNEARNED_CCID) as UNEARNED,
ABAA.ON_ACCOUNT_CCID,
( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  ABAA.ON_ACCOUNT_CCID) as ON_ACCOUNT,
ABAA.UNAPPLIED_CCID,
( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  ABAA.UNAPPLIED_CCID) as UNAPPLIED,
ABAA.UNIDENTIFIED_CCID,
( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  ABAA.UNIDENTIFIED_CCID) as UNIDENTIFIED,
ABAA.FACTOR_CCID,
( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  ABAA.FACTOR_CCID) as FACTOR,
ABAA.RECEIPT_CLEARING_CCID,
( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  ABAA.RECEIPT_CLEARING_CCID) as RECEIPT_CLEARING,
ABAA.REMITTANCE_CCID,
( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  ABAA.REMITTANCE_CCID) as REMITTANCE,
ABAA.EDISC_RECEIVABLES_TRX_ID,
( select name from AR_RECEIVABLES_TRX_ALL where receivables_trx_id =  ABAA.EDISC_RECEIVABLES_TRX_ID) as EDISC_RECEIVABLES_TRX,
ABAA.UNEDISC_RECEIVABLES_TRX_ID,
( select name from AR_RECEIVABLES_TRX_ALL where receivables_trx_id =  ABAA.UNEDISC_RECEIVABLES_TRX_ID) as UNEDISC_RECEIVABLES_TRX,
ABAA.FUTURE_DATED_PAYMENT_CCID,
( select concatenated_segments from gl_code_combinations_kfv where code_combination_id =  ABAA.FUTURE_DATED_PAYMENT_CCID) as FUTURE_DATED_PAYMENT,
abb.bank_name,abb.bank_name_alt,abb.bank_branch_name,abb.bank_branch_name_alt,abb.description as bank_description,
abb.address_line1,abb.address_line2,abb.city,abb.state,abb.zip,abb.country,abb.institution_type
--acsa.name as check_name,acsa.banK_account_id,acsa.disbursement_type_lookup_code,acsa.check_format_id,acsa.last_document_num,acsa.last_available_document_num,acsa.num_setup_checks,
--acsa.inactive_date,--acsa,org_id,
--acsa.bank_charges_ccid,acsa.bank_errors_ccid,acsa.clearing_days,acsa.future_dated_payments_flag,acsa.cash_clearing_ccid--,acsa,transmission_code
FROM ap_bank_accounts_all abaa, ap_bank_branches abb
--,ap_check_stocks_all acsa,
  --ap_check_formats acf
 WHERE abaa.bank_branch_id = abb.bank_branch_id
-- AND abaa.BANK_ACCOUNT_ID=acsa.BANK_ACCOUNT_ID
 --AND acsa.CHECK_FORMAT_ID=acf.CHECK_FORMAT_ID
 --AND acsa.INACTIVE_DATE is null
   AND abb.end_date IS NULL
   AND abaa.account_type = 'INTERNAL'

Query to get the Customer Profile Class setup data in 11i

select  a.customer_profile_class_id,a.PROFILE_CLASS_NAME,a.PROFILE_CLASS_DESCRIPTION,a.status,a.collector_name,a.STANDARD_TERMS_NAME Payment_terms,
a.override_terms,a.PAYMENT_GRACE_DAYS,a.GROUPING_RULE_NAME,a.DUNNING_LETTERS,a.DUNNING_LETTER_SET_NAME,a.TOLERANCE,a.CREDIT_CHECKING,
b.CURRENCY_CODE,b.OVERALL_CREDIT_LIMIT Credit_limit,b.TRX_CREDIT_LIMIT Order_limit
from AR_CUSTOMER_PROFILE_CLASSES_V a,
AR_CUST_PROF_CLASS_AMOUNTS b where a.customer_profile_class_id=b.customer_profile_class_id