VIEW: APPS.XTR_BANK_ACCOUNTS_V

Source

View Text - Preformatted

SELECT account_number, party_code, currency, bank_name, bank_short_code, location, street, created_by, created_on, code_combination_id, gl_company_code, updated_by, updated_on, opening_balance, opening_bal_hce, statement_date, default_acct, party_type, authorised, setoff, bank_code, setoff_account_yn, interest_calculation_basis, audit_indicator, portfolio_code, primary_settlement_method, direct_debit_authority, eft_script_name, eft_script_output_path, sub_account_at, sub_account_number, cashflows_to_current_date, current_cashflow_date, projected_balance, projected_balance_date, projected_balance_updated_on, interest_rate, domiciled_currency, limit_code, year_calc_type, internal_pty, party_prin_ccid, party_int_ccid, setoff_company, swift_id, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ap_bank_account_id, rounding_type, day_count_type, pricing_model, legal_account_name, dummy_bank_account_id, target_balance, cashflow_display_order, max_target_balance, cashpool_min_receipt_amt, cashpool_min_payment_amt, cashpool_round_factor, cashpool_round_rule, cashpool_id, ce_bank_account_id, bank_branch_id, bank_acct_use_id ,iban FROM XTR_BANK_ACCOUNTS

View Text - HTML Formatted

SELECT ACCOUNT_NUMBER
, PARTY_CODE
, CURRENCY
, BANK_NAME
, BANK_SHORT_CODE
, LOCATION
, STREET
, CREATED_BY
, CREATED_ON
, CODE_COMBINATION_ID
, GL_COMPANY_CODE
, UPDATED_BY
, UPDATED_ON
, OPENING_BALANCE
, OPENING_BAL_HCE
, STATEMENT_DATE
, DEFAULT_ACCT
, PARTY_TYPE
, AUTHORISED
, SETOFF
, BANK_CODE
, SETOFF_ACCOUNT_YN
, INTEREST_CALCULATION_BASIS
, AUDIT_INDICATOR
, PORTFOLIO_CODE
, PRIMARY_SETTLEMENT_METHOD
, DIRECT_DEBIT_AUTHORITY
, EFT_SCRIPT_NAME
, EFT_SCRIPT_OUTPUT_PATH
, SUB_ACCOUNT_AT
, SUB_ACCOUNT_NUMBER
, CASHFLOWS_TO_CURRENT_DATE
, CURRENT_CASHFLOW_DATE
, PROJECTED_BALANCE
, PROJECTED_BALANCE_DATE
, PROJECTED_BALANCE_UPDATED_ON
, INTEREST_RATE
, DOMICILED_CURRENCY
, LIMIT_CODE
, YEAR_CALC_TYPE
, INTERNAL_PTY
, PARTY_PRIN_CCID
, PARTY_INT_CCID
, SETOFF_COMPANY
, SWIFT_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, AP_BANK_ACCOUNT_ID
, ROUNDING_TYPE
, DAY_COUNT_TYPE
, PRICING_MODEL
, LEGAL_ACCOUNT_NAME
, DUMMY_BANK_ACCOUNT_ID
, TARGET_BALANCE
, CASHFLOW_DISPLAY_ORDER
, MAX_TARGET_BALANCE
, CASHPOOL_MIN_RECEIPT_AMT
, CASHPOOL_MIN_PAYMENT_AMT
, CASHPOOL_ROUND_FACTOR
, CASHPOOL_ROUND_RULE
, CASHPOOL_ID
, CE_BANK_ACCOUNT_ID
, BANK_BRANCH_ID
, BANK_ACCT_USE_ID
, IBAN
FROM XTR_BANK_ACCOUNTS