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: XTR.XTR_REVALUATION_DETAILS#

Object Details

Object Name:	XTR_REVALUATION_DETAILS#
Object Type:	VIEW
Owner:	XTR
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
ACTION_CODE	VARCHAR2	(7)
AUDIT_INDICATOR	VARCHAR2	(1)
COMPANY_CODE	VARCHAR2	(7)	Yes
CONTRACT_CODE	VARCHAR2	(30)
CROSS_REF_TO_POSTING	NUMBER
CURRENCYA	VARCHAR2	(15)	Yes
CURRENCYB	VARCHAR2	(15)
CURRENCY_INDICATOR	VARCHAR2	(1)
DEAL_NO	NUMBER		Yes
DEAL_SUBTYPE	VARCHAR2	(30)	Yes
DEAL_TYPE	VARCHAR2	(7)	Yes
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	(30)
PRODUCT_TYPE	VARCHAR2	(10)	Yes
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)
UPDATED_ON	DATE
YEAR_BASIS	NUMBER
CREATED_BY	VARCHAR2	(30)	Yes
CREATED_ON	DATE		Yes
AUTHORIZE_JOURNAL_CREATION	VARCHAR2	(1)
JOURNAL_CREATED	DATE
BATCH_ID	NUMBER	(15)	Yes
REVALUATION_DETAILS_ID	NUMBER		Yes
SWAP_REF	VARCHAR2	(10)
COMPLETE_FLAG	VARCHAR2	(1)	Yes
OVERWRITE_TYPE	VARCHAR2	(30)
OVERWRITE_VALUE	NUMBER
OVERWRITE_REASON	VARCHAR2	(240)
FAIR_VALUE	NUMBER
REALIZED_FLAG	VARCHAR2	(1)
ACCOUNT_NO	VARCHAR2	(20)
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
NI_DISC_AMOUNT	NUMBER
AMOUNT_TYPE	VARCHAR2	(7)
QUANTITY	NUMBER
BANK_ACCT_USE_ID	NUMBER	(15)

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# references the following:

XTR: XTR_REVALUATION_DETAILS

XTR.XTR_REVALUATION_DETAILS# is referenced by following:

APPS: XTR_AU_REVALUATION_DETAILS_T; XTR_REVALUATION_DETAILS