DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.XTR_BANK_ACCOUNTS_V

Object Details
Object Name: XTR_BANK_ACCOUNTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_BANK_ACCOUNTS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ACCOUNT_NUMBER VARCHAR2 (20) Yes Alpha-numeric reference to financial accounts of Treasury parties
PARTY_CODE VARCHAR2 (7) Yes Party code
CURRENCY VARCHAR2 (15) Yes Currency code
BANK_NAME VARCHAR2 (50)
Bank name
BANK_SHORT_CODE VARCHAR2 (80) Yes Bank short code
LOCATION VARCHAR2 (35) Yes Bank location
STREET VARCHAR2 (35) Yes Street name
CREATED_BY VARCHAR2 (30) Yes User who created this record
CREATED_ON DATE
Yes Date this record was created
CODE_COMBINATION_ID NUMBER (15)
Unique key for identifying GL account references
GL_COMPANY_CODE VARCHAR2 (7)
General Ledger company code
UPDATED_BY VARCHAR2 (30)
User who last updated this record
UPDATED_ON DATE

Date this record was last updated
OPENING_BALANCE NUMBER

Opening balance
OPENING_BAL_HCE NUMBER

Opening balance in reporting currency equivalent
STATEMENT_DATE DATE

Statement date
DEFAULT_ACCT VARCHAR2 (1)
Flag to indicate if the account is the default account (Y), or not (N)
PARTY_TYPE VARCHAR2 (2)
Flag to indicate if the party is a company (C) or counterparty (CP)
AUTHORISED VARCHAR2 (1)
Flag to indicate if the bank account is authorized for use (Y), or not (N)
SETOFF VARCHAR2 (5)
Setoff code of the nominal account
BANK_CODE VARCHAR2 (7)
Bank code
SETOFF_ACCOUNT_YN VARCHAR2 (1)
Flag to indicate if the account is a nominal account (Y), or not (null)
INTEREST_CALCULATION_BASIS VARCHAR2 (4)
Interest calculation basis (STEP or FLAT)
AUDIT_INDICATOR VARCHAR2 (1)
Not currently used
PORTFOLIO_CODE VARCHAR2 (7)
Code for grouping deals under a single portfolio
PRIMARY_SETTLEMENT_METHOD VARCHAR2 (15)
Not currently used
DIRECT_DEBIT_AUTHORITY VARCHAR2 (1)
Flag to indicate whether the company has direct debit authority to this account (Y), or not (N)
EFT_SCRIPT_NAME VARCHAR2 (50)
Settlement script
EFT_SCRIPT_OUTPUT_PATH VARCHAR2 (50)
EFT script output path
SUB_ACCOUNT_AT VARCHAR2 (100)
Not currently used
SUB_ACCOUNT_NUMBER VARCHAR2 (20)
Not currently used
CASHFLOWS_TO_CURRENT_DATE NUMBER

Not currently used
CURRENT_CASHFLOW_DATE DATE

Not currently used
PROJECTED_BALANCE NUMBER

Projected balance of bank account based on future recorded cashflows
PROJECTED_BALANCE_DATE DATE

Projected balance date
PROJECTED_BALANCE_UPDATED_ON DATE

Date the projected balance was last updated
INTEREST_RATE NUMBER

Interest rate
DOMICILED_CURRENCY VARCHAR2 (15)
National currency in which the bank can make settlements (only applies to euro currency accounts)
LIMIT_CODE VARCHAR2 (7)
Code for user-defined limits imposed on deals and transactions
YEAR_CALC_TYPE VARCHAR2 (15)
Day count basis which defines the way in which interest accrues over time
INTERNAL_PTY VARCHAR2 (1)
Flag to indicate if the party is an internal party (Y), or not (N)
PARTY_PRIN_CCID NUMBER (15)
No longer used. Code combination identifier of the general ledger account used to account for the principal cash flows of an intercompany account
PARTY_INT_CCID NUMBER (15)
No longer used. Code combination identifier of the general ledger account used to account for the interest cash flows of an intercompany account
SETOFF_COMPANY VARCHAR2 (7)
Party code of the nominal account associated with this setoff account
SWIFT_ID VARCHAR2 (50)
Bank transit identifier
ATTRIBUTE_CATEGORY VARCHAR2 (30)
For Descriptive Flexfield
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield
AP_BANK_ACCOUNT_ID NUMBER (38)
Stores the cross-reference AP bank account number.
ROUNDING_TYPE VARCHAR2 (1)
Method used to round the calculated interest amount. R or NULL - Round, T - Truncate, U - Round Up
DAY_COUNT_TYPE VARCHAR2 (1)
Method used to calculate number of days for calculating interest. NULL - Current Logic, F - First Day type, L - Last Day type, B - Both Days type
PRICING_MODEL VARCHAR2 (30)
Bank Account pricing model
LEGAL_ACCOUNT_NAME VARCHAR2 (240)
Legal account name
DUMMY_BANK_ACCOUNT_ID NUMBER

Dummy AP bank account ID
TARGET_BALANCE NUMBER

Target bank account balance
CASHFLOW_DISPLAY_ORDER NUMBER

Cashflow display order
MAX_TARGET_BALANCE NUMBER

Maximum target balance
CASHPOOL_MIN_RECEIPT_AMT NUMBER

Minimum receipt amount
CASHPOOL_MIN_PAYMENT_AMT NUMBER

Minimum payment amount
CASHPOOL_ROUND_FACTOR NUMBER

Rounding factor
CASHPOOL_ROUND_RULE VARCHAR2 (1)
Rounding rule
CASHPOOL_ID NUMBER (15)
Physical cashpool ID
CE_BANK_ACCOUNT_ID NUMBER (15)
BANK_BRANCH_ID NUMBER (15)
BANK_ACCT_USE_ID NUMBER (15)
IBAN VARCHAR2 (50)
Query Text

Cut, paste (and edit) the following text to query this object:


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 APPS.XTR_BANK_ACCOUNTS_V;

Dependencies

[top of page]

APPS.XTR_BANK_ACCOUNTS_V references the following:

SchemaAPPS
SynonymXTR_BANK_ACCOUNTS
APPS.XTR_BANK_ACCOUNTS_V is referenced by following:

SchemaAPPS
Package BodyXTR_CALC_P - show dependent code
ViewXTR_COMPANY_ACCT_LOV_V
ViewXTR_CPARTY_ACCT_LOV_V
Package BodyXTR_EXP_TRANSFERS_PKG - show dependent code
Package BodyXTR_FX_TRANSFERS_PKG - show dependent code
Package BodyXTR_IAC_TRANSFERS_PKG - show dependent code
Package BodyXTR_IG_TRANSFERS_PKG - show dependent code
Package BodyXTR_IMPORT_DEAL_DATA - show dependent code
Package BodyXTR_NI_TRANSFERS_PKG - show dependent code
Package BodyXTR_REPLICATE_BANK_BALANCES - show dependent code
Package BodyXTR_STOCK_PKG - show dependent code
Package BodyXTR_TRANS_INTERFACE - show dependent code
Package BodyXTR_XTRCFACC_XMLP_PKG - show dependent code
Package BodyXTR_XTRCFCCY_XMLP_PKG - show dependent code
Package BodyXTR_XTRLTDAP_XMLP_PKG - show dependent code