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]

TABLE: XTR.XTR_REVALUATION_DETAILS

Object Details

Object Name:	XTR_REVALUATION_DETAILS
Object Type:	TABLE
Owner:	XTR
FND Design Data:	XTR.XTR_REVALUATION_DETAILS
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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_REVALUATION_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REVALUATION_DETAILS_ID
XTR_REVALUATION_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERIOD_FROM PERIOD_TO COMPANY_CODE
XTR_REVALUATION_DETAILS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID
XTR_REVALUATION_DETAILS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_NO DEAL_NO

Columns

Name	Datatype	Length	Mandatory	Comments
ACTION_CODE	VARCHAR2	(7)		Code for actions involved in executing deals
AUDIT_INDICATOR	VARCHAR2	(1)		Not currently used
COMPANY_CODE	VARCHAR2	(7)	Yes	Company code
CONTRACT_CODE	VARCHAR2	(30)		Issue code for Bond and Stock deal types
CROSS_REF_TO_POSTING	NUMBER			Not currently used
CURRENCYA	VARCHAR2	(15)	Yes	Base currency
CURRENCYB	VARCHAR2	(15)		Contra currency
CURRENCY_INDICATOR	VARCHAR2	(1)		Not currently used
DEAL_NO	NUMBER		Yes	Unique number assigned to each deal
DEAL_SUBTYPE	VARCHAR2	(30)	Yes	Code for deal executions permissible within a deal type
DEAL_TYPE	VARCHAR2	(7)	Yes	Code for high level deals
EFFECTIVE_DATE	DATE		Yes	Revaluation effective date
EFFECTIVE_DAYS	NUMBER			Number of days between revaluation date and transaction maturity date
ENTERED_BY	VARCHAR2	(30)	Yes	User who entered the revaluation details
ENTERED_ON	DATE		Yes	Date the revaluation details was entered
FACE_VALUE	NUMBER		Yes	Amount which revaluation calculation is based on
FXO_SELL_REF_AMOUNT	NUMBER			Amount in the contra currency of a foreign exchange option deal
FX_REVAL_PRINCIPAL_BAL	NUMBER			Not currently used
PERIOD_FROM	DATE		Yes	The starting period for which the realized or unrealized fair value gain/loss amount is calculated.
PERIOD_TO	DATE		Yes	The ending period for which the realized or unrealized fair value gain/loss amount is calculated.
PORTFOLIO_CODE	VARCHAR2	(30)		Code for grouping deals under a single portfolio
PRODUCT_TYPE	VARCHAR2	(10)	Yes	Code for products used in a deal type
RATE_ERROR	VARCHAR2	(1)		No longer used.
REALISED_PL	NUMBER			Profit or loss of transaction that has matured
REVAL_CCY	VARCHAR2	(15)		Revaluation currency
REVAL_HCE_AMOUNT	NUMBER			No longer used.
REVAL_RATE	NUMBER			Revaluation rate
REVAL_VALUE	NUMBER			No longer used.
TRANSACTION_NO	NUMBER		Yes	Unique reference number assigned to a transaction
TRANSACTION_PERIOD	NUMBER		Yes	Remaining period for this transaction
TRANSACTION_RATE	NUMBER		Yes	Transaction rate
UNIQUE_REF_NUM	NUMBER			No longer used.
UNREALISED_PL	NUMBER			Profit or loss of the transaction that has not matured before the period to date
UPDATED_BY	VARCHAR2	(30)		User who last updated this record
UPDATED_ON	DATE			Date this record was last updated
YEAR_BASIS	NUMBER			Number of days in a year used in calculations (for example, 360 and 365)
CREATED_BY	VARCHAR2	(30)	Yes	User who created this record
CREATED_ON	DATE		Yes	Date this record was created
AUTHORIZE_JOURNAL_CREATION	VARCHAR2	(1)		No longer used.
JOURNAL_CREATED	DATE			No longer used.
BATCH_ID	NUMBER	(15)	Yes	Identifier that groups events into one process flow.
REVALUATION_DETAILS_ID	NUMBER		Yes	Unique identifier for the table.
SWAP_REF	VARCHAR2	(10)		A reference for swaps.
COMPLETE_FLAG	VARCHAR2	(1)	Yes	Indicates if the deal contains components or cash flows that are not priced but necessary. For the first phase, a completion means that fair value is not null. Y=Complete. N=Incomplete.
OVERWRITE_TYPE	VARCHAR2	(30)		Indicates the form of the overwrite value.
OVERWRITE_VALUE	NUMBER			Specifies the overwrite value amount. Depending on the OVERWRITE_TYPE set, this field can mean interest rate, FX rate, fair value or the price of a deal.
OVERWRITE_REASON	VARCHAR2	(240)		Reason for overwrite.
FAIR_VALUE	NUMBER			The calculated fair value of the deal in the revaluation currency.
REALIZED_FLAG	VARCHAR2	(1)		Specifies if the amount recorded in this record is realized or unrealized. Y=Realized. N=Unrealized.
ACCOUNT_NO	VARCHAR2	(20)		Stores the CA Account Number
CUMM_GAIN_LOSS_AMOUNT	NUMBER			The cumulative unrealized gain/loss amount of the deal, in the revaluation currency.
CURR_GAIN_LOSS_AMOUNT	NUMBER			The gain/loss amount of the cash flow due to change in currency exchange rates.
SOB_FV_GAIN_LOSS_AMOUNT	NUMBER			The fair value gain/loss amount in Set of Books currency.
SOB_FAIR_VALUE_AMOUNT	NUMBER			The fair value of the deal/transaction in the Set of Books currency.
REVAL_CURR_FV_AMOUNT	NUMBER			The original calculated fair value of the deal/transaction in the revaluation currency, as calculated by the concurrent process before any overwriting. Internal use column.
CTR_CURR_SOB_CURR_FWD_RATE	NUMBER			This is the contra currency to set of books currency forward rate.
EXCHANGE_RATE_ONE	NUMBER			This exchange rate is mandatory for all single and double currency deal types. If no rates are found, the default value will be 0.
EXCHANGE_RATE_TWO	NUMBER			This exchange rate is used for double currency deal types.
NI_DISC_AMOUNT	NUMBER			Stores the pervious batch's NI discount amount
AMOUNT_TYPE	VARCHAR2	(7)		Amount type
QUANTITY	NUMBER			Not currently used
BANK_ACCT_USE_ID	NUMBER	(15)		Stores the bank account ID

Query Text

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


SELECT ACTION_CODE
,      AUDIT_INDICATOR
,      COMPANY_CODE
,      CONTRACT_CODE
,      CROSS_REF_TO_POSTING
,      CURRENCYA
,      CURRENCYB
,      CURRENCY_INDICATOR
,      DEAL_NO
,      DEAL_SUBTYPE
,      DEAL_TYPE
,      EFFECTIVE_DATE
,      EFFECTIVE_DAYS
,      ENTERED_BY
,      ENTERED_ON
,      FACE_VALUE
,      FXO_SELL_REF_AMOUNT
,      FX_REVAL_PRINCIPAL_BAL
,      PERIOD_FROM
,      PERIOD_TO
,      PORTFOLIO_CODE
,      PRODUCT_TYPE
,      RATE_ERROR
,      REALISED_PL
,      REVAL_CCY
,      REVAL_HCE_AMOUNT
,      REVAL_RATE
,      REVAL_VALUE
,      TRANSACTION_NO
,      TRANSACTION_PERIOD
,      TRANSACTION_RATE
,      UNIQUE_REF_NUM
,      UNREALISED_PL
,      UPDATED_BY
,      UPDATED_ON
,      YEAR_BASIS
,      CREATED_BY
,      CREATED_ON
,      AUTHORIZE_JOURNAL_CREATION
,      JOURNAL_CREATED
,      BATCH_ID
,      REVALUATION_DETAILS_ID
,      SWAP_REF
,      COMPLETE_FLAG
,      OVERWRITE_TYPE
,      OVERWRITE_VALUE
,      OVERWRITE_REASON
,      FAIR_VALUE
,      REALIZED_FLAG
,      ACCOUNT_NO
,      CUMM_GAIN_LOSS_AMOUNT
,      CURR_GAIN_LOSS_AMOUNT
,      SOB_FV_GAIN_LOSS_AMOUNT
,      SOB_FAIR_VALUE_AMOUNT
,      REVAL_CURR_FV_AMOUNT
,      CTR_CURR_SOB_CURR_FWD_RATE
,      EXCHANGE_RATE_ONE
,      EXCHANGE_RATE_TWO
,      NI_DISC_AMOUNT
,      AMOUNT_TYPE
,      QUANTITY
,      BANK_ACCT_USE_ID
FROM XTR.XTR_REVALUATION_DETAILS;

Dependencies

[top of page]

XTR.XTR_REVALUATION_DETAILS does not reference any database object

XTR.XTR_REVALUATION_DETAILS is referenced by following:

XTR: XTR_REVALUATION_DETAILS#