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

VIEW: APPS.EGO_ITEM_GTIN_V

Object Details
Object Name: EGO_ITEM_GTIN_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewEGO.EGO_ITEM_GTIN_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
ITEM_NUMBER VARCHAR2 (40)
Item Number
MASTER_ORGANIZATION_ID NUMBER
Yes Foreign key to MTL_SYSTEM_ITEMS_B
GTIN VARCHAR2 (255) Yes Global Trade Item Number
DESCRIPTION VARCHAR2 (240)
GTIN Description
ORG_INDEPENDENT_FLAG VARCHAR2 (1) Yes Is independent of organization
UOM_CODE VARCHAR2 (3)
Unit of measure code
UNIT_OF_MEASURE VARCHAR2 (25) Yes Unit of measure
TRADE_ITEM_DESCRIPTOR VARCHAR2 (35)
Trade item unit descriptor
PUBLICATION_STATUS NUMBER (15)
Publication status
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      ITEM_NUMBER
,      MASTER_ORGANIZATION_ID
,      GTIN
,      DESCRIPTION
,      ORG_INDEPENDENT_FLAG
,      UOM_CODE
,      UNIT_OF_MEASURE
,      TRADE_ITEM_DESCRIPTOR
,      PUBLICATION_STATUS
FROM APPS.EGO_ITEM_GTIN_V;

Dependencies

[top of page]

APPS.EGO_ITEM_GTIN_V references the following:

SchemaAPPS
ViewEGO_ITEM_GTN_ATTRS_VL
SynonymMTL_CROSS_REFERENCES
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymMTL_UNITS_OF_MEASURE

APPS.EGO_ITEM_GTIN_V is not referenced by any database object