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

TABLE: MSC.MSC_CURRENCY_CONVERSIONS

Object Details
Object Name: MSC_CURRENCY_CONVERSIONS
Object Type: TABLE
Owner: MSC
Subobject Name:
Status: VALID


This table holds currency conversion data.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Unique Key: MSC_CURRENCY_CONVERSIONS_N1
  1. ColumnTO_CURRENCY
  2. ColumnCONV_TYPE
  3. ColumnFROM_CURRENCY
  4. ColumnCONV_DATE
Indexes
Index Type Uniqueness Tablespace Column
MSC_CURRENCY_CONVERSIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTO_CURRENCY
ColumnCONV_TYPE
ColumnFROM_CURRENCY
ColumnCONV_DATE
ColumnCONV_RATE
Columns
Name Datatype Length Mandatory Comments
FROM_CURRENCY VARCHAR2 (30) Yes From Currency
TO_CURRENCY VARCHAR2 (30) Yes Reporting Currency
CONV_DATE DATE
Yes Conversion Date
CONV_TYPE VARCHAR2 (30) Yes Conversion Type
CONV_RATE NUMBER
Yes This is the ratio between the to_currency and from_currency
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATED_BY NUMBER

Standard WHO column
CREATION_DATE DATE

Standard WHO column
CREATED_BY NUMBER

Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
LAST_COLL_INSTANCE_ID NUMBER
Yes Instance from which this row was collected last.
RN NUMBER

RN of last collections run that inserted/updated this row.
Query Text

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


SELECT FROM_CURRENCY
,      TO_CURRENCY
,      CONV_DATE
,      CONV_TYPE
,      CONV_RATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_COLL_INSTANCE_ID
,      RN
FROM MSC.MSC_CURRENCY_CONVERSIONS;

Dependencies

[top of page]

MSC.MSC_CURRENCY_CONVERSIONS does not reference any database object

MSC.MSC_CURRENCY_CONVERSIONS is referenced by following:

SchemaAPPS
Materialized ViewMSC_CURRENCY_CONV_MV
SchemaMSC
ViewMSC_CURRENCY_CONVERSIONS#