VIEW: APPS.XTR_IG_BANK_ACCOUNTS_V

Source

View Text - Preformatted

SELECT ba.rowid, ba.account_number, ba.party_code, ba.currency, ba.bank_name, ba.bank_short_code, ba.location, ba.street, ba.created_by, ba.created_on, ba.code_combination_id, ba.gl_company_code, ba.updated_by, ba.updated_on, ba.opening_balance, ba.opening_bal_hce, ba.statement_date, ba.default_acct, ba.party_type, ba.authorised, ba.setoff, ba.bank_code, ba.party_prin_ccid, ba.party_int_ccid, ba.internal_pty, ba.setoff_company, ba.setoff_account_yn, ba.interest_calculation_basis, ba.audit_indicator, ba.portfolio_code, ba.primary_settlement_method, ba.direct_debit_authority, ba.eft_script_name, ba.eft_script_output_path, ba.sub_account_at, ba.sub_account_number, ba.cashflows_to_current_date, ba.current_cashflow_date, ba.projected_balance, ba.projected_balance_date, ba.projected_balance_updated_on, ba.interest_rate, pt.cross_ref_to_other_party, pt.full_name from xtr_bank_accounts ba, xtr_party_info pt where pt.cross_ref_to_other_party is not null and pt.party_code = ba.party_code and pt.PARTY_TYPE = 'CP'

View Text - HTML Formatted

SELECT BA.ROWID
, BA.ACCOUNT_NUMBER
, BA.PARTY_CODE
, BA.CURRENCY
, BA.BANK_NAME
, BA.BANK_SHORT_CODE
, BA.LOCATION
, BA.STREET
, BA.CREATED_BY
, BA.CREATED_ON
, BA.CODE_COMBINATION_ID
, BA.GL_COMPANY_CODE
, BA.UPDATED_BY
, BA.UPDATED_ON
, BA.OPENING_BALANCE
, BA.OPENING_BAL_HCE
, BA.STATEMENT_DATE
, BA.DEFAULT_ACCT
, BA.PARTY_TYPE
, BA.AUTHORISED
, BA.SETOFF
, BA.BANK_CODE
, BA.PARTY_PRIN_CCID
, BA.PARTY_INT_CCID
, BA.INTERNAL_PTY
, BA.SETOFF_COMPANY
, BA.SETOFF_ACCOUNT_YN
, BA.INTEREST_CALCULATION_BASIS
, BA.AUDIT_INDICATOR
, BA.PORTFOLIO_CODE
, BA.PRIMARY_SETTLEMENT_METHOD
, BA.DIRECT_DEBIT_AUTHORITY
, BA.EFT_SCRIPT_NAME
, BA.EFT_SCRIPT_OUTPUT_PATH
, BA.SUB_ACCOUNT_AT
, BA.SUB_ACCOUNT_NUMBER
, BA.CASHFLOWS_TO_CURRENT_DATE
, BA.CURRENT_CASHFLOW_DATE
, BA.PROJECTED_BALANCE
, BA.PROJECTED_BALANCE_DATE
, BA.PROJECTED_BALANCE_UPDATED_ON
, BA.INTEREST_RATE
, PT.CROSS_REF_TO_OTHER_PARTY
, PT.FULL_NAME
FROM XTR_BANK_ACCOUNTS BA
, XTR_PARTY_INFO PT
WHERE PT.CROSS_REF_TO_OTHER_PARTY IS NOT NULL
AND PT.PARTY_CODE = BA.PARTY_CODE
AND PT.PARTY_TYPE = 'CP'