DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.XTR_A_REVALUATION_RATES_V

Object Details
Object Name: XTR_A_REVALUATION_RATES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_A_REVALUATION_RATES_V
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.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
UNIQUE_REF_NUM NUMBER
Yes
COMPANY_CODE VARCHAR2 (7) Yes
PERIOD_FROM DATE
Yes
PERIOD_TO DATE
Yes
REVAL_TYPE VARCHAR2 (20) Yes
REVAL_SUBTYPE VARCHAR2 (7)
REVAL_PRODUCT_TYPE VARCHAR2 (10)
CURRENCYA VARCHAR2 (15) Yes
REVAL_RATE NUMBER

ENTERED_ON DATE
Yes
ENTERED_BY VARCHAR2 (30) Yes
RATE_DATE DATE
Yes
VOLATILITY_OR_RATE VARCHAR2 (4) Yes
DAY_MTH VARCHAR2 (13)
CURRENCYB VARCHAR2 (15)
PERIOD_REF1 NUMBER

PERIOD_REF2 NUMBER

UPDATED_BY VARCHAR2 (30)
UPDATED_ON DATE

NUMBER_OF_DAYS NUMBER

AUDIT_INDICATOR VARCHAR2 (1)
AUDIT_DATE_STORED DATE

CREATED_BY VARCHAR2 (30) Yes
CREATED_ON DATE
Yes
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
,      REVAL_SUBTYPE
,      REVAL_PRODUCT_TYPE
,      CURRENCYA
,      REVAL_RATE
,      ENTERED_ON
,      ENTERED_BY
,      RATE_DATE
,      VOLATILITY_OR_RATE
,      DAY_MTH
,      CURRENCYB
,      PERIOD_REF1
,      PERIOD_REF2
,      UPDATED_BY
,      UPDATED_ON
,      NUMBER_OF_DAYS
,      AUDIT_INDICATOR
,      AUDIT_DATE_STORED
,      CREATED_BY
,      CREATED_ON
FROM APPS.XTR_A_REVALUATION_RATES_V;

Dependencies

[top of page]

APPS.XTR_A_REVALUATION_RATES_V references the following:

SchemaAPPS
SynonymXTR_A_REVALUATION_RATES

APPS.XTR_A_REVALUATION_RATES_V is not referenced by any database object