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


TABLE: APPS.MSC_CURRENCY_CONV_MV

Object Details
Object Name: MSC_CURRENCY_CONV_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.MSC_CURRENCY_CONV_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_CURRENCY_CONV_MV_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnFROM_CURRENCY
ColumnTO_CURRENCY
ColumnCALENDAR_DATE
Columns
Name Datatype Length Mandatory Comments
FROM_CURRENCY VARCHAR2 (30) Yes
TO_CURRENCY VARCHAR2 (30) Yes
CALENDAR_DATE DATE
Yes
CONV_RATE NUMBER

Query Text

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


SELECT FROM_CURRENCY
,      TO_CURRENCY
,      CALENDAR_DATE
,      CONV_RATE
FROM APPS.MSC_CURRENCY_CONV_MV;

Dependencies

[top of page]

APPS.MSC_CURRENCY_CONV_MV does not reference any database object

APPS.MSC_CURRENCY_CONV_MV is referenced by following:

SchemaAPPS
Materialized ViewMSC_CURRENCY_CONV_MV
Package BodyMSC_DEMAND_PKG - show dependent code
Package BodyMSC_DEMANTRA_PKG - show dependent code
Package BodyMSC_EXCEPTION_PKG - show dependent code
Package BodyMSC_ITEM_PKG - show dependent code
Package BodyMSC_RESOURCE_PKG - show dependent code
Package BodyMSC_SNO_PKG - show dependent code
Package BodyMSC_SUPPLIER_PKG - show dependent code