View: XTR_BANK_ACCOUNTS_V

Product:	XTR - Treasury
Description:
Implementation/DBA Data:	APPS.XTR_BANK_ACCOUNTS_V

View Text

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

Columns