eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.EGO_ITEMS_V

Object Details

Object Name:	EGO_ITEMS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EGO.EGO_ITEMS_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

[View Source]

Columns

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

Query Text

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;

Dependencies

[top of page]

APPS.EGO_ITEMS_V references the following:

APPS: EGO_ITEM_GTN_ATTRS_B; EGO_UCCNET_EVENTS; FND_FLEX_VALUES_VL; FND_FLEX_VALUE_SETS; MTL_CROSS_REFERENCES_B; MTL_CROSS_REFERENCES_TL; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_B; MTL_SYSTEM_ITEMS_B_KFV; MTL_UNITS_OF_MEASURE_TL

APPS.EGO_ITEMS_V is referenced by following:

APPS: BOM_COMPUTE_FUNCTIONS - show dependent code; BOM_EXPLODER_PUB - show dependent code; BOM_GTIN_RULES - show dependent code; BOM_IMPLOSIONS_V; BOM_ROLLUP_PUB - show dependent code