Product: | XTR - Treasury |
---|---|
Description: | No longer used. Intercompany account information |
Implementation/DBA Data: | APPS.XTR_IG_BANK_ACCOUNTS_V |
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'