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_DISC_REVALUATION_DETAILS_V

Object Details

Object Name:	XTR_DISC_REVALUATION_DETAILS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XTR.XTR_DISC_REVALUATION_DETAILS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

The XTR_DISC_REVALUATION_DETAILS_V view is used for the Discoverer report and is based on the XTR_REVALUATION_DETAILS view. User access to company information is enforced in the XTR_DISC_REVALUATION_DETAILS_V view. Please refer to the full description of XTR_REVALUATION_DETAILS_V for more details.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ACTION_CODE	VARCHAR2	(7)		Refer to base table.
COMPANY_CODE	VARCHAR2	(7)		Refer to base table.
CONTRACT_CODE	VARCHAR2	(30)		Refer to base table.
TRANS_CURR	VARCHAR2	(15)		Refer to base table.
CONTRA_CURR	VARCHAR2	(15)		Refer to base table.
REF_NUMBER	VARCHAR2	(40)		Refer to base table.
USER_DEAL_SUBTYPE	VARCHAR2	(7)		Refer to base table.
USER_DEAL_TYPE	VARCHAR2	(7)	Yes	Refer to base table.
EFFECTIVE_DATE	DATE			Refer to base table.
EFFECTIVE_DAYS	NUMBER			Refer to base table.
ENTERED_BY	VARCHAR2	(10)	Yes	Refer to base table.
ENTERED_ON	DATE			Refer to base table.
FACE_VALUE	NUMBER			Refer to base table.
FXO_SELL_REF_AMOUNT	NUMBER			Refer to base table.
PERIOD_FROM	DATE			Refer to base table.
PERIOD_TO	DATE			Refer to base table.
PORTFOLIO_CODE	VARCHAR2	(30)		Refer to base table.
PRODUCT_TYPE	VARCHAR2	(10)		Refer to base table.
REALISED_PL	NUMBER			Refer to base table.
REVAL_CCY	VARCHAR2	(15)		Refer to base table.
REVAL_RATE	NUMBER			Refer to base table.
TRANSACTION_NO	NUMBER			Refer to base table.
TRANSACTION_PERIOD	NUMBER			Refer to base table.
TRANSACTION_RATE	NUMBER			Refer to base table.
UNREALISED_PL	NUMBER			Refer to base table.
UPDATED_BY	VARCHAR2	(10)	Yes	Refer to base table.
UPDATED_ON	DATE			Refer to base table.
YEAR_BASIS	NUMBER			Refer to base table.
CREATED_BY	VARCHAR2	(10)	Yes	Refer to base table.
CREATED_ON	DATE			Refer to base table.
REVALUATION_DETAILS_ID	NUMBER			Refer to base table.
BATCH_ID	NUMBER	(15)		Refer to base table.
COMPLETE_FLAG	VARCHAR2	(1)		Refer to base table.
OVERWRITE_TYPE	VARCHAR2	(30)		Refer to base table.
OVERWRITE_VALUE	NUMBER			Refer to base table.
OVERWRITE_REASON	VARCHAR2	(240)		Refer to base table.
FAIR_VALUE	NUMBER			Refer to base table.
REALIZED_FLAG	VARCHAR2	(1)		Refer to base table.
CUMM_GAIN_LOSS_AMOUNT	NUMBER			Refer to base table.
CURR_GAIN_LOSS_AMOUNT	NUMBER			Refer to base table.
SOB_FV_GAIN_LOSS_AMOUNT	NUMBER			Refer to base table.
SOB_FAIR_VALUE_AMOUNT	NUMBER			Refer to base table.
REVAL_CURR_FV_AMOUNT	NUMBER			Refer to base table.
CTR_CURR_SOB_CURR_FWD_RATE	NUMBER			Refer to base table.
EXCHANGE_RATE_ONE	NUMBER			Refer to base table.
EXCHANGE_RATE_TWO	NUMBER			Refer to base table.
AMOUNT_TYPE	VARCHAR2	(7)		Refer to base table.
QUANTITY	NUMBER			Refer to base table.
COMPANY_NAME	VARCHAR2	(50)	Yes	Refer to base table.
DEAL_SUBTYPE_NAME	VARCHAR2	(80)		Refer to base table.
DEAL_TYPE_NAME	VARCHAR2	(80)	Yes	Refer to base table.
PRODUCT_TYPE_DESC	VARCHAR2	(80)		Refer to base table.

Query Text

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


SELECT ACTION_CODE
,      COMPANY_CODE
,      CONTRACT_CODE
,      TRANS_CURR
,      CONTRA_CURR
,      REF_NUMBER
,      USER_DEAL_SUBTYPE
,      USER_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
,      COMPANY_NAME
,      DEAL_SUBTYPE_NAME
,      DEAL_TYPE_NAME
,      PRODUCT_TYPE_DESC
FROM APPS.XTR_DISC_REVALUATION_DETAILS_V;

Dependencies

[top of page]

APPS.XTR_DISC_REVALUATION_DETAILS_V references the following:

APPS: FND_GLOBAL - show dependent code; XTR_COMPANY_AUTHORITIES; XTR_DEALER_CODES; XTR_DEAL_SUBTYPES; XTR_DEAL_TYPES; XTR_PARTY_INFO; XTR_PRODUCT_TYPES; XTR_REVALUATION_DETAILS_V

APPS.XTR_DISC_REVALUATION_DETAILS_V is not referenced by any database object