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_A_REVALUATION_DETAILS

Object Details

Object Name:	XTR_A_REVALUATION_DETAILS
Object Type:	TABLE
Owner:	XTR
FND Design Data:	XTR.XTR_A_REVALUATION_DETAILS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_A_REVALUATION_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UPDATED_ON
XTR_A_REVALUATION_DETAILS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERIOD_FROM PERIOD_TO DEAL_TYPE COMPANY_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
ACTION_CODE	VARCHAR2	(7)
AUDIT_DATE_STORED	DATE			Date on which this record is audited.
AUDIT_INDICATOR	VARCHAR2	(1)
COMPANY_CODE	VARCHAR2	(7)	Yes	Company identifier. Foreign key to XTR_PARTIES_V.
CONTRACT_CODE	VARCHAR2	(7)
CROSS_REF_TO_POSTING	NUMBER
CURRENCYA	VARCHAR2	(15)	Yes
CURRENCYB	VARCHAR2	(15)
CURRENCY_INDICATOR	VARCHAR2	(1)
DEAL_NO	NUMBER		Yes	Deal identifier. Foreign key to XTR_DEALS.
DEAL_SUBTYPE	VARCHAR2	(7)	Yes	Deal subtype identifier. Composite key to XTR_DEAL_SUBTYPES.
DEAL_TYPE	VARCHAR2	(7)	Yes	Deal type identifier. Foreign key to XTR_DEAL_TYPES. Valid values are: BOND, CA, CMF, DEB, EQ, EXP, FRA, FUT, FX, FXO, IG, IRO, IRS, NI, ONC, SWPTN, TMM.
EFFECTIVE_DATE	DATE		Yes
EFFECTIVE_DAYS	NUMBER
ENTERED_BY	VARCHAR2	(30)	Yes
ENTERED_ON	DATE		Yes
FACE_VALUE	NUMBER		Yes
FXO_SELL_REF_AMOUNT	NUMBER
FX_REVAL_PRINCIPAL_BAL	NUMBER
PERIOD_FROM	DATE		Yes
PERIOD_TO	DATE		Yes
PORTFOLIO_CODE	VARCHAR2	(7)
PRODUCT_TYPE	VARCHAR2	(10)	Yes	Deal product type identifier. Composite key to XTR_PRODUCT_TYPES.
RATE_ERROR	VARCHAR2	(1)
REALISED_PL	NUMBER
REVAL_CCY	VARCHAR2	(15)
REVAL_HCE_AMOUNT	NUMBER
REVAL_RATE	NUMBER
REVAL_VALUE	NUMBER
TRANSACTION_NO	NUMBER		Yes
TRANSACTION_PERIOD	NUMBER		Yes
TRANSACTION_RATE	NUMBER		Yes
UNIQUE_REF_NUM	NUMBER
UNREALISED_PL	NUMBER
UPDATED_BY	VARCHAR2	(30)		Last updated user.
UPDATED_ON	DATE			Last updated date.
YEAR_BASIS	NUMBER
CREATED_BY	VARCHAR2	(30)	Yes
CREATED_ON	DATE		Yes
AUTHORIZE_JOURNAL_CREATION	VARCHAR2	(1)
JOURNAL_CREATED	DATE
BATCH_ID	NUMBER			Identifier that groups events into one process flow
REVALUATION_DETAILS_ID	NUMBER			Unique identifier for the table
SWAP_REF	VARCHAR2	(10)		A reference for swaps
COMPLETE_FLAG	VARCHAR2	(1)		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 previous batch's NI discount amount
AMOUNT_TYPE	VARCHAR2	(7)		Amount type

Query Text

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


SELECT ACTION_CODE
,      AUDIT_DATE_STORED
,      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
FROM XTR.XTR_A_REVALUATION_DETAILS;

Dependencies

[top of page]

XTR.XTR_A_REVALUATION_DETAILS does not reference any database object

XTR.XTR_A_REVALUATION_DETAILS is referenced by following:

XTR: XTR_A_REVALUATION_DETAILS#