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

TABLE: MSD.MSD_UOM_CONVERSIONS

Object Details
Object Name: MSD_UOM_CONVERSIONS
Object Type: TABLE
Owner: MSD
FND Design Data: TableMSD.MSD_UOM_CONVERSIONS
Subobject Name:
Status: VALID


This is the fact table that stores the UOM conversions information.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
FROM_UOM_CLASS VARCHAR2 (40) Yes UOM class from which the UOM conversion takes place.
TO_UOM_CLASS VARCHAR2 (40) Yes UOM class to which the UOM conversion takes place.
FROM_UOM_CODE VARCHAR2 (40) Yes UOM class code from which the UOM conversion takes place.
TO_UOM_CODE VARCHAR2 (40) Yes UOM class code to which the UOM conversion takes place.
BASE_UOM_FLAG VARCHAR2 (1) Yes 'Y' -Yes/'N' -No values. 'Yes', if the 'to UOM class' is the base UOM class.
CONVERSION_RATE NUMBER
Yes Conversion factor for 'from' - 'to' UOM class conversion.
CREATION_DATE DATE
Yes Standard who column.
CREATED_BY NUMBER (15) Yes Standard who column.
LAST_UPDATE_DATE DATE
Yes Standard who column.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column.
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard who column.
REQUEST_ID NUMBER

Extended who column.
PROGRAM_APPLICATION_ID NUMBER

Extended who column.
PROGRAM_ID NUMBER

Extended who column.
PROGRAM_UPDATE_DATE DATE

Extended who column.
INSTANCE NUMBER

Source instance id
SR_ITEM_PK VARCHAR2 (240)
Item Id
ITEM VARCHAR2 (240)
Item Name
LAST_REFRESH_NUM NUMBER

Last refresh number
CREATED_BY_REFRESH_NUM NUMBER

created by refresh number
ACTION_CODE VARCHAR2 (30)
DML action code
Query Text

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


SELECT FROM_UOM_CLASS
,      TO_UOM_CLASS
,      FROM_UOM_CODE
,      TO_UOM_CODE
,      BASE_UOM_FLAG
,      CONVERSION_RATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      INSTANCE
,      SR_ITEM_PK
,      ITEM
,      LAST_REFRESH_NUM
,      CREATED_BY_REFRESH_NUM
,      ACTION_CODE
FROM MSD.MSD_UOM_CONVERSIONS;

Dependencies

[top of page]

MSD.MSD_UOM_CONVERSIONS does not reference any database object

MSD.MSD_UOM_CONVERSIONS is referenced by following:

SchemaMSD
ViewMSD_UOM_CONVERSIONS#