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

VIEW: APPS.MSD_UOM_CONVERSIONS_V

Object Details
Object Name: MSD_UOM_CONVERSIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMSD.MSD_UOM_CONVERSIONS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This API specifies the Conversion Rate between two UOM's.


[View Source]

Columns
Name Datatype Length Mandatory Comments
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)
'Y' -Yes/'N' -No values. 'Yes', if the 'to UOM class' is the base UOM class.
CONVERSION_RATE NUMBER

Conversion factor for 'from' - 'to' UOM class conversion.
ITEM_ID NUMBER

The source item inventory id
ITEM VARCHAR2 (240)
Item name
INSTANCE NUMBER

Source instance
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
,      ITEM_ID
,      ITEM
,      INSTANCE
,      LAST_REFRESH_NUM
,      CREATED_BY_REFRESH_NUM
,      ACTION_CODE
FROM APPS.MSD_UOM_CONVERSIONS_V;

Dependencies

[top of page]

APPS.MSD_UOM_CONVERSIONS_V references the following:

SchemaAPPS
SynonymMSD_LEVEL_VALUES
SynonymMSD_UOM_CONVERSIONS

APPS.MSD_UOM_CONVERSIONS_V is not referenced by any database object