[Home] [Help]
View: PMIFV_UOM_V
Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
Description: | Process Manufacturing Units of Measure and their associated conversion factors. |
Implementation/DBA Data: |
APPS.PMIFV_UOM_V
|
View Text
SELECT UOMMASTER.UM_CODE
, /*REGULAR ATTRIBUTES*/ UOMMASTER.UM_DESC
, UOMMASTER.STD_FACTOR
, UOMMASTER.RND_FACTOR
, UOMMASTER.REF_UM
, UOMMASTER.UM_TYPE
, /*ID*/ UOMTYPE.TYPE_DESC
, /* RESOLVED FOREIGN KEYS */ UOMTYPE.STD_UM
, UOMMASTER.CREATED_BY
, /*WHO*/ UOMMASTER.CREATION_DATE
, UOMMASTER.LAST_UPDATE_DATE
, UOMMASTER.LAST_UPDATED_BY
FROM SY_UOMS_MST UOMMASTER
, SY_UOMS_TYP UOMTYPE
WHERE UOMMASTER.UM_TYPE = UOMTYPE.UM_TYPE
AND UOMMASTER.DELETE_MARK = 0
AND UOMTYPE.DELETE_MARK = 0 WITH READ ONLY
Columns
Name |
UOM_CODE |
UOM_DESC |
STANDARD_FACTOR |
ROUNDING_FACTOR |
REFERENCE_UOM |
UOM_TYPE |
TYPE_DESCRIPTION |
STANDARD_UOM |
CREATED_BY |
CREATION_DATE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |