VIEW: APPS.XTR_A_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, PARTY_PRIN_CCID, PARTY_INT_CCID, INTERNAL_PTY, SETOFF_COMPANY, SETOFF_ACCOUNT_YN, INTEREST_CALCULATION_BASIS, 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, AUDIT_INDICATOR, AUDIT_DATE_STORED, DOMICILED_CURRENCY, LIMIT_CODE, YEAR_CALC_TYPE from XTR_A_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
, PARTY_PRIN_CCID
, PARTY_INT_CCID
, INTERNAL_PTY
, SETOFF_COMPANY
, SETOFF_ACCOUNT_YN
, INTEREST_CALCULATION_BASIS
, 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
, AUDIT_INDICATOR
, AUDIT_DATE_STORED
, DOMICILED_CURRENCY
, LIMIT_CODE
, YEAR_CALC_TYPE
FROM XTR_A_BANK_ACCOUNTS