[Home] [Help]
[Dependency Information]
| Object Name: | ASO_I_ITEM_UOMS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | ASO.ASO_I_ITEM_UOMS_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
| INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item identifier | |
| UOM_TYPE | NUMBER | Allowed unit of measure conversion type | ||
| UOM_CODE | VARCHAR2 | (3) | Yes | Abbreviated unit of measure code |
| UNIT_OF_MEASURE | VARCHAR2 | (25) | Yes | Unit of measure name |
| DESCRIPTION | VARCHAR2 | (50) | Unit of measure description | |
| UOM_CLASS | VARCHAR2 | (10) | Yes | Unit of measure class |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, INVENTORY_ITEM_ID
, UOM_TYPE
, UOM_CODE
, UNIT_OF_MEASURE
, DESCRIPTION
, UOM_CLASS
FROM APPS.ASO_I_ITEM_UOMS_V;
APPS
MTL_ITEM_UOMS_VIEW
APPS
CSD_REPAIRS_PVT
- show dependent code
|
|
|
|