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

VIEW: XTR.XTR_A_REVALUATION_RATES#

Object Details
Object Name: XTR_A_REVALUATION_RATES#
Object Type: VIEW
Owner: XTR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
AUDIT_DATE_STORED DATE

AUDIT_INDICATOR VARCHAR2 (1)
COMPANY_CODE VARCHAR2 (7) Yes
CURRENCYA VARCHAR2 (15) Yes
CURRENCYB VARCHAR2 (15)
DAY_MTH VARCHAR2 (13)
ENTERED_BY VARCHAR2 (30) Yes
ENTERED_ON DATE
Yes
NUMBER_OF_DAYS NUMBER

PERIOD_FROM DATE
Yes
PERIOD_REF1 NUMBER

PERIOD_REF2 NUMBER

PERIOD_TO DATE
Yes
RATE_DATE DATE
Yes
REVAL_PRODUCT_TYPE VARCHAR2 (10)
REVAL_RATE NUMBER

REVAL_SUBTYPE VARCHAR2 (7)
REVAL_TYPE VARCHAR2 (20) Yes
UNIQUE_REF_NUM NUMBER
Yes
UPDATED_BY VARCHAR2 (30)
UPDATED_ON DATE

VOLATILITY_OR_RATE VARCHAR2 (4) Yes
CREATED_BY VARCHAR2 (30) Yes
CREATED_ON DATE
Yes
BATCH_ID NUMBER

BID NUMBER

BID_OVERWRITE NUMBER

ASK NUMBER

ASK_OVERWRITE NUMBER

DAY_COUNT_BASIS VARCHAR2 (30)
Query Text

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


SELECT AUDIT_DATE_STORED
,      AUDIT_INDICATOR
,      COMPANY_CODE
,      CURRENCYA
,      CURRENCYB
,      DAY_MTH
,      ENTERED_BY
,      ENTERED_ON
,      NUMBER_OF_DAYS
,      PERIOD_FROM
,      PERIOD_REF1
,      PERIOD_REF2
,      PERIOD_TO
,      RATE_DATE
,      REVAL_PRODUCT_TYPE
,      REVAL_RATE
,      REVAL_SUBTYPE
,      REVAL_TYPE
,      UNIQUE_REF_NUM
,      UPDATED_BY
,      UPDATED_ON
,      VOLATILITY_OR_RATE
,      CREATED_BY
,      CREATED_ON
,      BATCH_ID
,      BID
,      BID_OVERWRITE
,      ASK
,      ASK_OVERWRITE
,      DAY_COUNT_BASIS
FROM XTR.XTR_A_REVALUATION_RATES#;

Dependencies

[top of page]

XTR.XTR_A_REVALUATION_RATES# references the following:

SchemaXTR
TableXTR_A_REVALUATION_RATES
XTR.XTR_A_REVALUATION_RATES# is referenced by following:

SchemaAPPS
SynonymXTR_A_REVALUATION_RATES