eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.XTR_BANK_BALANCES_V

Object Details

Object Name:	XTR_BANK_BALANCES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XTR.XTR_BANK_BALANCES_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
COMPANY_CODE	VARCHAR2	(7)	Yes	Company code
FIRST_BATCH_ID	NUMBER	(15)		First batch id. Identifier that groups events into one process flow.
LAST_BATCH_ID	NUMBER	(15)		Last batch id. Identifier that groups events into one process flow.
EXCHANGE_RATE	NUMBER			Exchange rate.
ACCOUNT_NUMBER	VARCHAR2	(20)	Yes	Alpha-numeric reference to financial accounts of Treasury parties
BALANCE_DATE	DATE		Yes	Balance date
NO_OF_DAYS	NUMBER		Yes	Number of days since the last balance date
STATEMENT_BALANCE	NUMBER			Statement balance
BALANCE_ADJUSTMENT	NUMBER			Amount required to adjust the bank statement balance for bank errors (the difference between the interest calculation balance and the statement balance)
BALANCE_CFLOW	NUMBER			Cash flow balance which reflects counterparty errors and bank errors
ACCUM_INT_BFWD	NUMBER		Yes	Accumulated interest on previous balance date
INTEREST	NUMBER		Yes	Interest amount
INTEREST_RATE	NUMBER		Yes	Interest rate at which a deal or transaction is executed
INTEREST_SETTLED	NUMBER		Yes	Interest settlement
INTEREST_SETTLED_HCE	NUMBER		Yes	Interest settlement in reporting currency equivalent
ACCUM_INT_CFWD	NUMBER		Yes	Accumulated interest on current balance date
UPDATED_BY	VARCHAR2	(30)		User who last updated this record
UPDATED_ON	DATE			Date this record was last updated
SETOFF	VARCHAR2	(5)		Setoff code of the notional account to which the bank account balance belongs
AUDIT_INDICATOR	VARCHAR2	(1)		Not currently used
LIMIT_CODE	VARCHAR2	(7)		Code for user-defined limits imposed on deals and transactions
CREATED_BY	VARCHAR2	(30)	Yes	User who created this record
CREATED_ON	DATE		Yes	Date this record was created
ACCRUAL_INTEREST	NUMBER			Running accumulated interest on current balance date
AVERAGE_EXCHANGE_RATE	NUMBER			Average exchange rate.
ROUNDING_TYPE	VARCHAR2	(1)		Not currently used
DAY_COUNT_TYPE	VARCHAR2	(1)		Not currently used
ORIGINAL_AMOUNT	NUMBER			Not currently used
ONE_DAY_FLOAT	NUMBER			1-day float bank balance
TWO_DAY_FLOAT	NUMBER			2-day float bank balance

Query Text

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


SELECT COMPANY_CODE
,      FIRST_BATCH_ID
,      LAST_BATCH_ID
,      EXCHANGE_RATE
,      ACCOUNT_NUMBER
,      BALANCE_DATE
,      NO_OF_DAYS
,      STATEMENT_BALANCE
,      BALANCE_ADJUSTMENT
,      BALANCE_CFLOW
,      ACCUM_INT_BFWD
,      INTEREST
,      INTEREST_RATE
,      INTEREST_SETTLED
,      INTEREST_SETTLED_HCE
,      ACCUM_INT_CFWD
,      UPDATED_BY
,      UPDATED_ON
,      SETOFF
,      AUDIT_INDICATOR
,      LIMIT_CODE
,      CREATED_BY
,      CREATED_ON
,      ACCRUAL_INTEREST
,      AVERAGE_EXCHANGE_RATE
,      ROUNDING_TYPE
,      DAY_COUNT_TYPE
,      ORIGINAL_AMOUNT
,      ONE_DAY_FLOAT
,      TWO_DAY_FLOAT
FROM APPS.XTR_BANK_BALANCES_V;

Dependencies

[top of page]

APPS.XTR_BANK_BALANCES_V references the following:

APPS: XTR_BANK_BALANCES

APPS.XTR_BANK_BALANCES_V is referenced by following:

APPS: XTR_REPLICATE_BANK_BALANCES - show dependent code; XTR_REVAL_PROCESS_P - show dependent code