[Home] [Help] [Dependency Information]
Object Name: | EGO_ITEMS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | EGO.EGO_ITEMS_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item identifier.Foreign key to MTL_SYSTEM_ITEMS_B | |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier.Foreign key to MTL_SYSTEM_ITEMS_B | |
CONCATENATED_SEGMENTS | VARCHAR2 | (40) | Item Number | |
MASTER_ORGANIZATION_ID | NUMBER | Yes | Unique ID for the master inventory organization to which this item belongs | |
CROSS_REFERENCE_TYPE | VARCHAR2 | (25) | Cross-reference type designating which cross-reference values are used to capture the Global Trade Item Number (a globally unique item number derived according to EAN/UCC standards) | |
GTIN | VARCHAR2 | (255) | A globally unique item number derived according to EAN/UCC standards | |
DESCRIPTION | VARCHAR2 | (240) | Item description | |
PRIMARY_UOM_CODE | VARCHAR2 | (3) | The item's primary unit of measure code | |
PRIMARY_UOM_CODE_DESC | VARCHAR2 | (50) | The description for the item's primary unit of measure code | |
TRADE_ITEM_DESCRIPTOR | VARCHAR2 | (35) | The code describing the level of this item in the packaging hierarchy--whether it is a Case, Each, Pallet, etc. | |
TRADE_ITEM_DESCRIPTOR_DESC | VARCHAR2 | (150) | The description for the trade item unit descriptor | |
PUBLICATION_STATUS | CHAR | (1) | This flag indicates whether the item has been registered or published to the global UCCNet product registry | |
TOP_GTIN | VARCHAR2 | (15) | This flag determines if this item is the top level of the packaging hierarchy | |
CUSTOMER_ORDER_ENABLED_FLAG | VARCHAR2 | (1) | Yes | This indicates if this item can be ordered by a customer |
IS_TRADE_ITEM_A_CONSUMER_UNIT | VARCHAR2 | (1) | Indicates whether this item can be consumed or whether it is simply a packaging item | |
UNIT_WEIGHT | NUMBER | Unit weight of the item | ||
GROSS_WEIGHT | NUMBER | Gross weight of the item | ||
ENG_ITEM_FLAG | VARCHAR2 | (1) | Yes | This flag indicates if the item is an engineering item |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, ORGANIZATION_ID
, CONCATENATED_SEGMENTS
, MASTER_ORGANIZATION_ID
, CROSS_REFERENCE_TYPE
, GTIN
, DESCRIPTION
, PRIMARY_UOM_CODE
, PRIMARY_UOM_CODE_DESC
, TRADE_ITEM_DESCRIPTOR
, TRADE_ITEM_DESCRIPTOR_DESC
, PUBLICATION_STATUS
, TOP_GTIN
, CUSTOMER_ORDER_ENABLED_FLAG
, IS_TRADE_ITEM_A_CONSUMER_UNIT
, UNIT_WEIGHT
, GROSS_WEIGHT
, ENG_ITEM_FLAG
FROM APPS.EGO_ITEMS_V;
|
|
|