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

VIEW: APPS.SY_UOMS_MST_V

Object Details
Object Name: SY_UOMS_MST_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMA.SY_UOMS_MST_V
Subobject Name:
Status: VALID

View Type

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


View of unit of measure master


[View Source]

Columns
Name Datatype Length Mandatory Comments
UM_CODE VARCHAR2 (25)
Unit of Measure code
UM_DESC VARCHAR2 (40)
Unit of Measure description
UM_TYPE VARCHAR2 (10) Yes Unit of Measure type
STD_FACTOR NUMBER

Standard factor
UNIT_OF_MEASURE VARCHAR2 (25) Yes Unit of Measure
UOM_CODE VARCHAR2 (3) Yes Unit of Measure code
LAST_UPDATE_LOGIN NUMBER

Standard who column
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
DELETE_MARK NUMBER

Standard delete mark
TEXT_CODE NUMBER

Text code
RND_FACTOR NUMBER

rnd factor
REF_UM VARCHAR2 (0)
Reference unit of measure
TRANS_CNT NUMBER

transaction count
Query Text

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


SELECT UM_CODE
,      UM_DESC
,      UM_TYPE
,      STD_FACTOR
,      UNIT_OF_MEASURE
,      UOM_CODE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      DELETE_MARK
,      TEXT_CODE
,      RND_FACTOR
,      REF_UM
,      TRANS_CNT
FROM APPS.SY_UOMS_MST_V;

Dependencies

[top of page]

APPS.SY_UOMS_MST_V references the following:

SchemaAPPS
SynonymMTL_UNITS_OF_MEASURE
SynonymMTL_UOM_CONVERSIONS
APPS.SY_UOMS_MST_V is referenced by following:

SchemaAPPS
ViewPMITS_ITEM_LOT_UOM_CONV_V
SynonymSY_UOMS_MST