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_GTIN_ATTRS_V

Object Details

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

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER		Yes	Organization identifier.Foreign key to MTL_SYSTEM_ITEMS_B
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier.Foreign key to MTL_SYSTEM_ITEMS_B
GLOBAL_TRADE_ITEM_NUMBER	VARCHAR2	(255)	Yes	GTIN value
BRAND_OWNER_GLN	VARCHAR2	(35)		Brand owners Global Location Number
BRAND_OWNER_NAME	VARCHAR2	(35)		Brand owners name
STORAGE_HANDLING_TEMP_MAX	NUMBER	(3)		Maximum temperature for storage of item
UOM_STORAGE_HANDLING_TEMP_MAX	VARCHAR2	(3)		Unit of Measure for mazimum temperature
STORAGE_HANDLING_TEMP_MIN	NUMBER	(3)		Minimum temperature for storage of Item
UOM_STORAGE_HANDLING_TEMP_MIN	VARCHAR2	(3)		Unit of Measure for Minimum temperature
TRADE_ITEM_COUPON	NUMBER	(3)		Coupon Family Code
GLN_INFORMATION_PROVIDER	VARCHAR2	(80)		Identifier of global information provider
NAME_OF_INFORMATION_PROVIDER	VARCHAR2	(80)		Global information provider name
ADDRESS_OF_INFO_PROVIDER	CHAR	(0)		Address of the information provider
TARGET_MARKET_COUNTRY_CODE	CHAR	(3)		Country code of Target Market
IS_TRADE_ITEM_A_CONSUMER_UNIT	VARCHAR2	(1)		Is Product consumable
IS_TRADE_ITEM_AN_ORD_UNIT	VARCHAR2	(1)	Yes	is Item a orderable Unit (Y or N)
IS_TRADE_ITEM_A_BASE_UNIT	VARCHAR2	(1)		Is this the base unit
IS_TRADE_ITEM_A_DESPATCH_UNIT	VARCHAR2	(1)	Yes	Is this a dispatchable item
IS_TRADE_ITEM_AN_INVOICE_UNIT	VARCHAR2	(1)	Yes	An indicator identifying that the information provider will include this trade item on their billing or invoice.
IS_TRADE_ITEM_A_VARIABLE_UNIT	VARCHAR2	(1)		Is item transacted in variable quantities
DEPTH	NUMBER			Trade Item Description : Depth
UOM_DEPTH	VARCHAR2	(3)		Trade Item Description : Unit of Measure of Depth
HEIGHT	NUMBER			Trade Item Description : Height
UOM_HEIGHT	VARCHAR2	(3)		Trade Item Description : Unit of Measure of height
WIDTH	NUMBER			Trade Item Description : Width
UOM_WIDTH	VARCHAR2	(3)		Trade Item Description : Unit of Measure of Width
NET_WEIGHT	NUMBER			Net weight of the Item
UOM_WEIGHT	VARCHAR2	(3)		Unit of measure of Net Weight
DIAMATER	VARCHAR2	(40)		Diameter of Item
UOM_DIAMETER	VARCHAR2	(3)		Unit of measure of Diameter of item
GROSS_WEIGHT	VARCHAR2	(40)		Gross weight of unit
UOM_GROSS_WEIGHT	VARCHAR2	(3)		Unit of Measure of Gross Weight
DRAINED_WEIGHT	VARCHAR2	(40)		Drained Weight of Item
UOM_DRAINED_WEIGHT	VARCHAR2	(3)		Unit of Measure of Drained weight
GENERIC_INGREDIENT	VARCHAR2	(35)		Generic
GENERIC_INGREDIENT_STRENGTH	VARCHAR2	(40)		Strength of generic ingridient
UOM_GENERIC_INGREDIENT_STRTH	VARCHAR2	(3)		Unit Of Measure of ingredient strength
INGREDIENT_STRENGTH	VARCHAR2	(18)		Ingridient strength
IS_NET_CONTENT_DEC_FLAG	VARCHAR2	(1)		Is net content declared
NET_CONTENT	NUMBER			Net content of item
UOM_NET_CONTENT	VARCHAR2	(3)		Unit Of measure for net content
PEG_HORIZONTAL	VARCHAR2	(40)		Horizontal item peg
UOM_PEG_HORIZONTAL	VARCHAR2	(3)		Unit of Measure for horizontal peg
PEG_VERTICAL	VARCHAR2	(40)		Vertical Peg
UOM_PEG_VERTICAL	VARCHAR2	(3)		Unit Of Measure for vertical peg
VOLUME	NUMBER			Volume of the item
UOM_DIMENSION	VARCHAR2	(3)		Unit of measure for dimensions
UOM_VOLUME	VARCHAR2	(3)		Unit of measure for volume
ISBN_NUMBER	VARCHAR2	(10)		ISBN Number
ISSN_NUMBER	VARCHAR2	(10)		ISSN number
DEGREE_OF_ORIGINAL_WORT	VARCHAR2	(3)		Degree of Original wort
FAT_PERCENT_IN_DRY_MATTER	NUMBER	(4)		Percentage of fat in item
PERCENT_OF_ALCOHOL_BY_VOL	NUMBER	(4)		Percentage of alcohol by volume
IS_PACK_MARKED_WITH_EXP_DATE	VARCHAR2	(1)		Is Packaging marked with expiration date
IS_PACK_MARKED_WITH_GREEN_DOT	VARCHAR2	(1)		Is Packaging marked with green dot
IS_PACK_MARKED_WITH_INGRED	VARCHAR2	(1)		Is Packaging marked with ingredients
IS_PACKAGE_MARKED_AS_REC	VARCHAR2	(1)		Is package marked as recyclable
IS_PACKAGE_MARKED_RET	VARCHAR2	(1)		Is package marked as returnable
IS_INGREDIENT_IRRADIATED	VARCHAR2	(1)		Has ingredients been irradiated
IS_RAW_MATERIAL_IRRADIATED	VARCHAR2	(1)		Has raw materials been irradiated
IS_TRADE_ITEM_GENETICALLY_MOD	VARCHAR2	(1)		Has the item been genetically modified
IS_TRADE_ITEM_IRRADIATED	VARCHAR2	(1)		Has the item been irradiated
MATERIAL_SAFETY_DATA_SHEET_NO	VARCHAR2	(20)		Material Satety Data Number
RETAIL_PRICE_ON_TRADE_ITEM	NUMBER	(17)		Is retail price on the item
UOM_RETAIL_PRICE_ON_TRADE_ITEM	CHAR	(3)		Unit of Measure of price on trade item
ORDERING_LEAD_TIME	VARCHAR2	(40)		Normal delivery time from order receipt
UOM_ORDERING_LEAD_TIME	VARCHAR2	(3)		Unit of Measure for ordering lead time
ORDER_QUANTITY_MAX	NUMBER	(9)		Maximum Order Quantity
ORDER_QUANTITY_MIN	NUMBER	(9)		Minimum Order Quantity
ORDER_SIZING_FACTOR	NUMBER	(9)		Item specification other than weight, vol used for order sizing
ORDER_QUANTITY_MULTIPLE	NUMBER	(9)		Multiples in which the item can be ordered
STACKING_FACTOR	NUMBER	(6)		Maximum number of items stacked together
STACKING_WEIGHT_MAXIMUM	VARCHAR2	(40)		Maximum weight for items stacked together
UOM_STACKING_WEIGHT_MAXIMUM	VARCHAR2	(3)		Unit Of Measure of Maximum Stacking Weight
BRAND_NAME	VARCHAR2	(50)		Name of the Brand
SUB_BRAND	VARCHAR2	(35)		Items sub brand
DESCRIPTION_SHORT	VARCHAR2	(45)		Short Description
ADDITIONAL_TRADE_ITEM_DESC	VARCHAR2	(240)		Additional trade item description
TRADE_ITEM_UNIT_DESCRIPTOR	VARCHAR2	(35)		Product hierarchy level
EANUCC_CODE	VARCHAR2	(20)		EAN UCC code
EANUCC_TYPE	VARCHAR2	(30)		EAN UCC code type
IS_TRADE_ITEM_INFO_PRIVATE	VARCHAR2	(1)		Is Item information public to only subscribers
DEL_TO_DIST_CENTER_TEMP_MAX	NUMBER	(3)		Maximum delivery temperature to distribution center
UOM_DEL_TO_DIST_CNTR_TEMP_MAX	VARCHAR2	(3)		Unit of Measure for max distribution center delivery temp
DEL_TO_DIST_CENTER_TEMP_MIN	NUMBER	(3)		Minimum delivery temperature to distribution center
UOM_DEL_TO_DIST_CNTR_TEMP_MIN	VARCHAR2	(3)		Unit of Measure for min distribution center delivery temp
DELIVERY_TO_MARKET_TEMP_MAX	NUMBER	(3)		Maximum delivery temperature to market
UOM_DELIVERY_TO_MRKT_TEMP_MAX	VARCHAR2	(3)		Unit Of Measure max temp for delivery to market
DELIVERY_TO_MARKET_TEMP_MIN	NUMBER	(3)		Minimum temperature for delivery to market
UOM_DELIVERY_TO_MRKT_TEMP_MIN	VARCHAR2	(3)		Unit of measure min temperature for delivery to market
CATALOG_PRICE	NUMBER			Catalog price
UOM_CATALOG_PRICE	CHAR	(3)		Unit of measure for catalog price
SUGGESTED_RETAIL_PRICE	NUMBER			MSRP
UOM_SUGGESTED_RETAIL_PRICE	CHAR	(3)		Unit of measure for MSRP
EFFECTIVE_START_DATE	DATE			Date when price is effective
EFFECTIVE_END_DATE	DATE			Date when price is no longer effective
EFFECTIVE_DATE	DATE			Effective Date
PUBLICATION_DATE	DATE			Date when the item is published for the last time
DELETION_DATE	DATE			Date when the item is deleted
CANCELED_DATE	DATE			Date when the item is canceled
DISCONTINUED_DATE	DATE			Date when the item is discontinued
END_AVAILABILITY_DATE_TIME	DATE			Date when item is no longer available
START_AVAILABILITY_DATE_TIME	DATE			Date when item is available
CONSUMER_AVAIL_DATE_TIME	DATE			Date of availability to consumer
HAS_BATCH_NUMBER	VARCHAR2	(1)		Does item have a batch number
IS_NON_SOLD_TRADE_RET_FLAG	VARCHAR2	(1)		Is non sold items returnable
IS_TRADE_ITEM_MAR_REC_FLAG	VARCHAR2	(1)		Is Item recycleable
QUANTITY_OF_COMP_LAY_ITEM	NUMBER	(6)		Quantity of complete layers in package
QUANITY_OF_ITEM_IN_LAYER	NUMBER	(6)		Quanity of items in one layer
QUANTITY_OF_ITEM_INNER_PACK	NUMBER	(3)		Quantity of items in inner pack
QUANTITY_OF_INNER_PACK	NUMBER	(3)		Number of inner packs
SECURITY_TAG_LOCATION	VARCHAR2	(35)		Security tag location on item
URL_FOR_WARRANTY	VARCHAR2	(80)		Warranty URL
WARRANTY_DESCRIPTION	VARCHAR2	(70)		Warranty Description
NESTING_INCREMENT	VARCHAR2	(40)		Incremental height of trade items stacked together
UOM_NESTING_INCREMENT	VARCHAR2	(3)		Unit Of Measure for nesting increment
IS_TRADE_ITEM_RECALLED	VARCHAR2	(1)		Is there a recall for this item
MODEL_NUMBER	VARCHAR2	(50)		Vendor model number
UOM_TRADE_ITEM	VARCHAR2	(3)		Unit of measure of trade item
UOM_ALTERNATE_TRADE_ITEM	VARCHAR2	(3)		Alternate unit of measure of trade item
PIECES_PER_TRADE_ITEM	VARCHAR2	(40)		Number of pieces used to make the item
UOM_PIECES_PER_TRADE_ITEM	VARCHAR2	(3)		Unit of Measure for pieces for trade item
TRADE_ITEM_FINISH_DESCRIPTION	VARCHAR2	(70)		Finish Description
DEPT_OF_TRNSPRT_DANG_GOODS_NUM	VARCHAR2	(4)		Department of Transportation dangerous goods number
RETURN_GOODS_POLICY	VARCHAR2	(30)		Return goods policy
IS_OUT_OF_BOX_PROVIDED	VARCHAR2	(1)		Is out of box measurements provided
CATALOG_ITEM_CLASSIFICIATION	VARCHAR2	(163)		Item Category Code
CLASSIFICATION_CATEGORY_CODE	VARCHAR2	(163)		Item Category Code
CLASSIFICATION_CATEGORY_DES	VARCHAR2	(240)		Item Category Description
CLASSIFICATION_CATEGORY_NAME	VARCHAR2	(163)		Item Category Code
ADD_CLASS_CATALOG_NAME	VARCHAR2	(163)		Item Category Code
ADD_CLASS_CATALOG_CODE	VARCHAR2	(163)		Item Category Code
ADD_CLASS_CATALOG_DES	VARCHAR2	(240)		Item Category Code Description

Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      GLOBAL_TRADE_ITEM_NUMBER
,      BRAND_OWNER_GLN
,      BRAND_OWNER_NAME
,      STORAGE_HANDLING_TEMP_MAX
,      UOM_STORAGE_HANDLING_TEMP_MAX
,      STORAGE_HANDLING_TEMP_MIN
,      UOM_STORAGE_HANDLING_TEMP_MIN
,      TRADE_ITEM_COUPON
,      GLN_INFORMATION_PROVIDER
,      NAME_OF_INFORMATION_PROVIDER
,      ADDRESS_OF_INFO_PROVIDER
,      TARGET_MARKET_COUNTRY_CODE
,      IS_TRADE_ITEM_A_CONSUMER_UNIT
,      IS_TRADE_ITEM_AN_ORD_UNIT
,      IS_TRADE_ITEM_A_BASE_UNIT
,      IS_TRADE_ITEM_A_DESPATCH_UNIT
,      IS_TRADE_ITEM_AN_INVOICE_UNIT
,      IS_TRADE_ITEM_A_VARIABLE_UNIT
,      DEPTH
,      UOM_DEPTH
,      HEIGHT
,      UOM_HEIGHT
,      WIDTH
,      UOM_WIDTH
,      NET_WEIGHT
,      UOM_WEIGHT
,      DIAMATER
,      UOM_DIAMETER
,      GROSS_WEIGHT
,      UOM_GROSS_WEIGHT
,      DRAINED_WEIGHT
,      UOM_DRAINED_WEIGHT
,      GENERIC_INGREDIENT
,      GENERIC_INGREDIENT_STRENGTH
,      UOM_GENERIC_INGREDIENT_STRTH
,      INGREDIENT_STRENGTH
,      IS_NET_CONTENT_DEC_FLAG
,      NET_CONTENT
,      UOM_NET_CONTENT
,      PEG_HORIZONTAL
,      UOM_PEG_HORIZONTAL
,      PEG_VERTICAL
,      UOM_PEG_VERTICAL
,      VOLUME
,      UOM_DIMENSION
,      UOM_VOLUME
,      ISBN_NUMBER
,      ISSN_NUMBER
,      DEGREE_OF_ORIGINAL_WORT
,      FAT_PERCENT_IN_DRY_MATTER
,      PERCENT_OF_ALCOHOL_BY_VOL
,      IS_PACK_MARKED_WITH_EXP_DATE
,      IS_PACK_MARKED_WITH_GREEN_DOT
,      IS_PACK_MARKED_WITH_INGRED
,      IS_PACKAGE_MARKED_AS_REC
,      IS_PACKAGE_MARKED_RET
,      IS_INGREDIENT_IRRADIATED
,      IS_RAW_MATERIAL_IRRADIATED
,      IS_TRADE_ITEM_GENETICALLY_MOD
,      IS_TRADE_ITEM_IRRADIATED
,      MATERIAL_SAFETY_DATA_SHEET_NO
,      RETAIL_PRICE_ON_TRADE_ITEM
,      UOM_RETAIL_PRICE_ON_TRADE_ITEM
,      ORDERING_LEAD_TIME
,      UOM_ORDERING_LEAD_TIME
,      ORDER_QUANTITY_MAX
,      ORDER_QUANTITY_MIN
,      ORDER_SIZING_FACTOR
,      ORDER_QUANTITY_MULTIPLE
,      STACKING_FACTOR
,      STACKING_WEIGHT_MAXIMUM
,      UOM_STACKING_WEIGHT_MAXIMUM
,      BRAND_NAME
,      SUB_BRAND
,      DESCRIPTION_SHORT
,      ADDITIONAL_TRADE_ITEM_DESC
,      TRADE_ITEM_UNIT_DESCRIPTOR
,      EANUCC_CODE
,      EANUCC_TYPE
,      IS_TRADE_ITEM_INFO_PRIVATE
,      DEL_TO_DIST_CENTER_TEMP_MAX
,      UOM_DEL_TO_DIST_CNTR_TEMP_MAX
,      DEL_TO_DIST_CENTER_TEMP_MIN
,      UOM_DEL_TO_DIST_CNTR_TEMP_MIN
,      DELIVERY_TO_MARKET_TEMP_MAX
,      UOM_DELIVERY_TO_MRKT_TEMP_MAX
,      DELIVERY_TO_MARKET_TEMP_MIN
,      UOM_DELIVERY_TO_MRKT_TEMP_MIN
,      CATALOG_PRICE
,      UOM_CATALOG_PRICE
,      SUGGESTED_RETAIL_PRICE
,      UOM_SUGGESTED_RETAIL_PRICE
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      EFFECTIVE_DATE
,      PUBLICATION_DATE
,      DELETION_DATE
,      CANCELED_DATE
,      DISCONTINUED_DATE
,      END_AVAILABILITY_DATE_TIME
,      START_AVAILABILITY_DATE_TIME
,      CONSUMER_AVAIL_DATE_TIME
,      HAS_BATCH_NUMBER
,      IS_NON_SOLD_TRADE_RET_FLAG
,      IS_TRADE_ITEM_MAR_REC_FLAG
,      QUANTITY_OF_COMP_LAY_ITEM
,      QUANITY_OF_ITEM_IN_LAYER
,      QUANTITY_OF_ITEM_INNER_PACK
,      QUANTITY_OF_INNER_PACK
,      SECURITY_TAG_LOCATION
,      URL_FOR_WARRANTY
,      WARRANTY_DESCRIPTION
,      NESTING_INCREMENT
,      UOM_NESTING_INCREMENT
,      IS_TRADE_ITEM_RECALLED
,      MODEL_NUMBER
,      UOM_TRADE_ITEM
,      UOM_ALTERNATE_TRADE_ITEM
,      PIECES_PER_TRADE_ITEM
,      UOM_PIECES_PER_TRADE_ITEM
,      TRADE_ITEM_FINISH_DESCRIPTION
,      DEPT_OF_TRNSPRT_DANG_GOODS_NUM
,      RETURN_GOODS_POLICY
,      IS_OUT_OF_BOX_PROVIDED
,      CATALOG_ITEM_CLASSIFICIATION
,      CLASSIFICATION_CATEGORY_CODE
,      CLASSIFICATION_CATEGORY_DES
,      CLASSIFICATION_CATEGORY_NAME
,      ADD_CLASS_CATALOG_NAME
,      ADD_CLASS_CATALOG_CODE
,      ADD_CLASS_CATALOG_DES
FROM APPS.EGO_GTIN_ATTRS_V;

Dependencies

[top of page]

APPS.EGO_GTIN_ATTRS_V references the following:

APPS: EGO_ATTRS_V; EGO_ITEM_GTN_ATTRS_B; EGO_ITEM_GTN_ATTRS_TL; FND_GLOBAL - show dependent code; FND_LOOKUPS; INV_CONVERT - show dependent code; MTL_CATEGORIES_B_KFV; MTL_CATEGORIES_TL; MTL_CROSS_REFERENCES; MTL_DEFAULT_CATEGORY_SETS; MTL_ITEM_CATEGORIES; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_B; MTL_SYSTEM_ITEMS_TL; MTL_UNITS_OF_MEASURE_TL

APPS.EGO_GTIN_ATTRS_V is not referenced by any database object