[Home] [Help] [Dependency Information]
Object Name: | ENI_ITEM_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view lists the itrms belonging to the master organizations
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | VARCHAR2 | (25) | Unique identifier for master organization inventory item | |
VALUE | VARCHAR2 | (240) | Name of inventory item | |
DESCRIPTION | VARCHAR2 | (240) | Item description | |
INVENTORY_ITEM_ID | NUMBER | Unique identifier for inventory item | ||
ORGANIZATION_ID | VARCHAR2 | (40) | Unique identifier for organization the item exists in | |
VBH_CATEGORY_ID | NUMBER | Unique identifier for product category item is associated to | ||
VBH_CATEGORY_DESC | VARCHAR2 | (240) | Description of product category item is associated to | |
PRIMARY_UOM_CODE | VARCHAR2 | (5) | Primary unit of measurement code | |
CREATION_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
UNIT_WEIGHT | NUMBER | Unit weight | ||
UNIT_VOLUME | NUMBER | Unit volume | ||
WEIGHT_UOM_CODE | VARCHAR2 | (3) | Unit of measurement code for weight | |
VOLUME_UOM_CODE | VARCHAR2 | (3) | Unit of measurement code for volume | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Description as provided in MSIB TL table |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, VALUE
, DESCRIPTION
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, VBH_CATEGORY_ID
, VBH_CATEGORY_DESC
, PRIMARY_UOM_CODE
, CREATION_DATE
, LAST_UPDATE_DATE
, UNIT_WEIGHT
, UNIT_VOLUME
, WEIGHT_UOM_CODE
, VOLUME_UOM_CODE
, ITEM_DESCRIPTION
FROM APPS.ENI_ITEM_V;
APPS.ENI_ITEM_V is not referenced by any database object
|
|
|