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

TABLE: OPI.OPI_EDW_LOCAL_UOM_CONV_F

Object Details
Object Name: OPI_EDW_LOCAL_UOM_CONV_F
Object Type: TABLE
Owner: OPI
FND Design Data: TableOPI.OPI_EDW_LOCAL_UOM_CONV_F
Subobject Name:
Status: VALID


Local table of the Unit of Measure Conversion Fact Table within a source instance. This works as a local copy of warehouse UOM Conversion data to allow better performance for the UOM APIs.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OPI_EDW_LOCAL_UOM_CONV_F_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnUOM_CONV_PK
Columns
Name Datatype Length Mandatory Comments
UOM_CONV_PK VARCHAR2 (40)
Unique identifier
EDW_BASE_UOM_FK VARCHAR2 (20)
Foreign key to the Unit Of Measure dimension (Base Unit Of Measure)
EDW_UOM_FK VARCHAR2 (20)
Foreign key to the Unit Of Measure dimension (Unit Of Measure)
EDW_CONVERSION_RATE NUMBER

Conversion rate between the Instance Unit Of Measure and the Warehouse Unit Of Measure
CLASS_CONVERSION_FLAG VARCHAR2 (1)
Indicates whether the row is used for Inter-Class Conversion or for Intra-Class Conversion
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
Query Text

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


SELECT UOM_CONV_PK
,      EDW_BASE_UOM_FK
,      EDW_UOM_FK
,      EDW_CONVERSION_RATE
,      CLASS_CONVERSION_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM OPI.OPI_EDW_LOCAL_UOM_CONV_F;

Dependencies

[top of page]

OPI.OPI_EDW_LOCAL_UOM_CONV_F does not reference any database object

OPI.OPI_EDW_LOCAL_UOM_CONV_F is referenced by following:

SchemaAPPS
SynonymOPI_EDW_LOCAL_UOM_CONV_F