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_REVALUATION_DETAILS_SUM_V

Object Details

Object Name:	XTR_REVALUATION_DETAILS_SUM_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XTR.XTR_REVALUATION_DETAILS_SUM_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
ACTION_CODE	VARCHAR2	(7)
COMPANY_CODE	VARCHAR2	(7)
CONTRACT_CODE	VARCHAR2	(30)
CURRENCYA	VARCHAR2	(15)
CURRENCYB	VARCHAR2	(15)
REF_NUMBER	VARCHAR2	(40)
DEAL_SUBTYPE	VARCHAR2	(30)
DEAL_TYPE	VARCHAR2	(7)
EFFECTIVE_DATE	DATE
EFFECTIVE_DAYS	NUMBER
ENTERED_BY	VARCHAR2	(30)
ENTERED_ON	DATE
FACE_VALUE	NUMBER
FXO_SELL_REF_AMOUNT	NUMBER
PERIOD_FROM	DATE
PERIOD_TO	DATE
PORTFOLIO_CODE	VARCHAR2	(30)
PRODUCT_TYPE	VARCHAR2	(10)
REALISED_PL	NUMBER
REVAL_CCY	VARCHAR2	(15)
REVAL_RATE	NUMBER
TRANSACTION_NO	NUMBER
TRANSACTION_PERIOD	NUMBER
TRANSACTION_RATE	NUMBER
UNREALISED_PL	NUMBER
UPDATED_BY	VARCHAR2	(30)
UPDATED_ON	DATE
YEAR_BASIS	NUMBER
CREATED_BY	VARCHAR2	(30)
CREATED_ON	DATE
REVALUATION_DETAILS_ID	NUMBER
BATCH_ID	NUMBER	(15)
COMPLETE_FLAG	VARCHAR2	(1)
OVERWRITE_TYPE	VARCHAR2	(30)
OVERWRITE_VALUE	NUMBER
OVERWRITE_REASON	VARCHAR2	(240)
FAIR_VALUE	NUMBER
REALIZED_FLAG	VARCHAR2	(1)
CUMM_GAIN_LOSS_AMOUNT	NUMBER
CURR_GAIN_LOSS_AMOUNT	NUMBER
SOB_FV_GAIN_LOSS_AMOUNT	NUMBER
SOB_FAIR_VALUE_AMOUNT	NUMBER
REVAL_CURR_FV_AMOUNT	NUMBER
CTR_CURR_SOB_CURR_FWD_RATE	NUMBER
EXCHANGE_RATE_ONE	NUMBER
EXCHANGE_RATE_TWO	NUMBER
AMOUNT_TYPE	VARCHAR2	(7)
QUANTITY	NUMBER

Query Text

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


SELECT ACTION_CODE
,      COMPANY_CODE
,      CONTRACT_CODE
,      CURRENCYA
,      CURRENCYB
,      REF_NUMBER
,      DEAL_SUBTYPE
,      DEAL_TYPE
,      EFFECTIVE_DATE
,      EFFECTIVE_DAYS
,      ENTERED_BY
,      ENTERED_ON
,      FACE_VALUE
,      FXO_SELL_REF_AMOUNT
,      PERIOD_FROM
,      PERIOD_TO
,      PORTFOLIO_CODE
,      PRODUCT_TYPE
,      REALISED_PL
,      REVAL_CCY
,      REVAL_RATE
,      TRANSACTION_NO
,      TRANSACTION_PERIOD
,      TRANSACTION_RATE
,      UNREALISED_PL
,      UPDATED_BY
,      UPDATED_ON
,      YEAR_BASIS
,      CREATED_BY
,      CREATED_ON
,      REVALUATION_DETAILS_ID
,      BATCH_ID
,      COMPLETE_FLAG
,      OVERWRITE_TYPE
,      OVERWRITE_VALUE
,      OVERWRITE_REASON
,      FAIR_VALUE
,      REALIZED_FLAG
,      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
,      AMOUNT_TYPE
,      QUANTITY
FROM APPS.XTR_REVALUATION_DETAILS_SUM_V;

Dependencies

[top of page]

APPS.XTR_REVALUATION_DETAILS_SUM_V references the following:

APPS: XTR_REVALUATION_DETAILS

APPS.XTR_REVALUATION_DETAILS_SUM_V is referenced by following:

APPS: XTR_XTRCCYGL_XMLP_PKG - show dependent code; XTR_XTRREVGL_XMLP_PKG - show dependent code