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

TABLE: MSD.MSD_ST_UOM_CONVERSIONS

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


This staging table stores the UOM conversions information.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
INSTANCE NUMBER
Yes Source instance ID.
FROM_UOM_CLASS VARCHAR2 (40)
UOM class from which the UOM conversion takes place.
TO_UOM_CLASS VARCHAR2 (40)
UOM class to which the UOM conversion takes place.
FROM_UOM_CODE VARCHAR2 (40)
UOM class code from which the UOM conversion takes place.
TO_UOM_CODE VARCHAR2 (40)
UOM class code to which the UOM conversion takes place.
BASE_UOM_FLAG VARCHAR2 (1)
Yes/No values. 'Yes', if the 'to UOM class' is the base UOM class.
CONVERSION_RATE NUMBER

Conversion factor for 'from' - 'to' UOM class conversion.
CREATION_DATE DATE

Standard who column.
CREATED_BY NUMBER (15)
Standard who column.
LAST_UPDATE_DATE DATE

Standard who column.
LAST_UPDATED_BY NUMBER (15)
Standard who column.
LAST_UPDATE_LOGIN NUMBER (15)
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.
SR_ITEM_PK VARCHAR2 (240)
Item inventory id
ITEM VARCHAR2 (240)
Item name
SR_INSTANCE_CODE VARCHAR2 (3)
Source Instance Code
PROCESS_FLAG NUMBER

This is an internal column. It is populated and used by Legacy Collection Process
DATA_SOURCE_TYPE VARCHAR2 (15)
This is an internal column. It is populated and used by Legacy Collection Process
ST_TRANSACTION_ID NUMBER

This is an internal column. It is populated and used by Legacy Collection Process
BATCH_ID NUMBER

This is an internal column. It is populated and used by Legacy Collection Process
ERROR_TEXT VARCHAR2 (2000)
This is an internal column. It is populated and used by Legacy Collection Process
MESSAGE_ID NUMBER

This is an internal column. It is populated and used by Legacy Collection Process
Query Text

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


SELECT INSTANCE
,      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
,      SR_ITEM_PK
,      ITEM
,      SR_INSTANCE_CODE
,      PROCESS_FLAG
,      DATA_SOURCE_TYPE
,      ST_TRANSACTION_ID
,      BATCH_ID
,      ERROR_TEXT
,      MESSAGE_ID
FROM MSD.MSD_ST_UOM_CONVERSIONS;

Dependencies

[top of page]

MSD.MSD_ST_UOM_CONVERSIONS does not reference any database object

MSD.MSD_ST_UOM_CONVERSIONS is referenced by following:

SchemaAPPS
SynonymMSD_ST_UOM_CONVERSIONS