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_RATES_V

Object Details

Object Name:	XTR_REVALUATION_RATES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XTR.XTR_REVALUATION_RATES_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	Mandatory	Comments
UNIQUE_REF_NUM	NUMBER		Yes	Unique reference number for revaluation rates
COMPANY_CODE	VARCHAR2	(7)	Yes	Company code
PERIOD_FROM	DATE		Yes	Previous revaluation date
PERIOD_TO	DATE		Yes	Current revaluation date
REVAL_TYPE	VARCHAR2	(20)	Yes	Revaluation type
CURRENCYA	VARCHAR2	(15)	Yes	Base currency
ENTERED_ON	DATE		Yes	Date the revaluation details was entered
ENTERED_BY	VARCHAR2	(30)	Yes	User who entered the revaluation details
RATE_DATE	DATE		Yes	Date the rate is set
VOLATILITY_OR_RATE	VARCHAR2	(4)	Yes	Not currently used
DAY_MTH	VARCHAR2	(13)		Period frequency type (days or months)
CURRENCYB	VARCHAR2	(15)		Contra currency
PERIOD_REF1	NUMBER			Period length
PERIOD_REF2	NUMBER			Not currently used
UPDATED_BY	VARCHAR2	(30)		User who last updated this record
UPDATED_ON	DATE			Date this record was last updated
AUDIT_INDICATOR	VARCHAR2	(1)		Not currently used
NUMBER_OF_DAYS	NUMBER			Period frequency length converted to days
BATCH_ID	NUMBER	(15)	Yes	Identifier that groups events into one process flow.
BID	NUMBER			The bid rate.
BID_OVERWRITE	NUMBER			The overwrite bid rate.
ASK	NUMBER			The ask rate.
ASK_OVERWRITE	NUMBER			The overwrite ask rate.
DAY_COUNT_BASIS	VARCHAR2	(30)		The day count basis.
CREATED_BY	VARCHAR2	(30)	Yes	User who created this record
CREATED_ON	DATE		Yes	Date this record was created

Query Text

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


SELECT UNIQUE_REF_NUM
,      COMPANY_CODE
,      PERIOD_FROM
,      PERIOD_TO
,      REVAL_TYPE
,      CURRENCYA
,      ENTERED_ON
,      ENTERED_BY
,      RATE_DATE
,      VOLATILITY_OR_RATE
,      DAY_MTH
,      CURRENCYB
,      PERIOD_REF1
,      PERIOD_REF2
,      UPDATED_BY
,      UPDATED_ON
,      AUDIT_INDICATOR
,      NUMBER_OF_DAYS
,      BATCH_ID
,      BID
,      BID_OVERWRITE
,      ASK
,      ASK_OVERWRITE
,      DAY_COUNT_BASIS
,      CREATED_BY
,      CREATED_ON
FROM APPS.XTR_REVALUATION_RATES_V;

Dependencies

[top of page]

APPS.XTR_REVALUATION_RATES_V references the following:

APPS: XTR_REVALUATION_RATES

APPS.XTR_REVALUATION_RATES_V is not referenced by any database object