[Home] [Help] [Dependency Information]
Object Name: | BIL_DIMV_UOM |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BIL.BIL_DIMV_UOM |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
BIL_DIMV_UOM - Dimension view used to provide descriptive in information for materials
management units of measure.
.
Source is Oracle Applications Materials Management schema.
.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UNIT_OF_MEASURE | VARCHAR2 | (25) | Unit of measure name | |
UOM_CODE | VARCHAR2 | (30) | Abbreviated unit of measure code | |
UOM_CLASS | VARCHAR2 | (10) | Unit of measure class | |
UOM_DISABLE_DATE | DATE | Date when the unit can no longer be used to define conversions | ||
UOM_DESCRIPTION | VARCHAR2 | (240) | Unit of measure description | |
BASE_UOM_FLAG | VARCHAR2 | (1) | Base unit of measure flag | |
ID | VARCHAR2 | (30) | Abbreviated unit of measure code | |
VALUE | VARCHAR2 | (25) | Unit of measure name |
Cut, paste (and edit) the following text to query this object:
SELECT UNIT_OF_MEASURE
, UOM_CODE
, UOM_CLASS
, UOM_DISABLE_DATE
, UOM_DESCRIPTION
, BASE_UOM_FLAG
, ID
, VALUE
FROM APPS.BIL_DIMV_UOM;
APPS.BIL_DIMV_UOM is not referenced by any database object
|
|
|