[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | EGO_ITEM_GTN_ATTRS_B |
|---|---|
| Object Type: | TABLE |
| Owner: | EGO |
| FND Design Data: |  EGO.EGO_ITEM_GTN_ATTRS_B
|
| Subobject Name: | |
| Status: | VALID |
Table EGO_ITEM_GTN_ATTRS_B stores the single row, untranslated GDSN atttributes. Each row of the table stores the GDSN attribute values for a given item and organization.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| EGO_ITEM_GTN_ATTRS_B_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 INVENTORY_ITEM_ID
ORGANIZATION_ID
|
| EGO_ITEM_GTN_ATTRS_B_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
EXTENSION_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| EXTENSION_ID | NUMBER | (15) | Yes | Unique identifier for the attribute row |
| INVENTORY_ITEM_ID | NUMBER | (15) | Yes | Inventory item identifier.Foreign key to MTL_SYSTEM_ITEMS_B |
| ORGANIZATION_ID | NUMBER | (15) | Yes | Organization identifier.Foreign key to MTL_SYSTEM_ITEMS_B |
| CREATED_BY | NUMBER | (15) | Yes | User id of Person who created record |
| CREATION_DATE | DATE | Yes | Date record was created | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | User id of last person modifying the record |
| LAST_UPDATE_DATE | DATE | Yes | Date record was last modified | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Login of last person who updated record | |
| ITEM_CATALOG_GROUP_ID | NUMBER | (15) | Item catalog group identifier.Foreign key to MTL_ITEM_CATALOG_GROUPS_B - used for search | |
| REVISION_ID | NUMBER | (15) | Item Revision Id. Foreign key to MTL_ITEM_REVISIONS_B | |
| IS_TRADE_ITEM_A_CONSUMER_UNIT | VARCHAR2 | (1) | Is Product consumable | |
| IS_TRADE_ITEM_INFO_PRIVATE | VARCHAR2 | (1) | Is Item information public to only subscribers | |
| GROSS_WEIGHT | NUMBER | Weight of item including packaging | ||
| UOM_GROSS_WEIGHT | VARCHAR2 | (3) | Weight Unit of Measure | |
| EFFECTIVE_DATE | DATE | Effective date for item attributes | ||
| CANCELED_DATE | DATE | RCIR cancelled date | ||
| DISCONTINUED_DATE | DATE | RCIR discontinued date | ||
| END_AVAILABILITY_DATE_TIME | DATE | Date when item is no longer available | ||
| START_AVAILABILITY_DATE_TIME | DATE | Date when item is available | ||
| BRAND_NAME | VARCHAR2 | (50) | RCIR - Brand Name for item | |
| IS_TRADE_ITEM_A_BASE_UNIT | VARCHAR2 | (1) | RCIR - Is this the base unit | |
| IS_TRADE_ITEM_A_VARIABLE_UNIT | VARCHAR2 | (1) | Is item transacted in variable quantities | |
| 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 | |
| STACKING_FACTOR | NUMBER | (6) | Maximum number of items stacked together | |
| STACKING_WEIGHT_MAXIMUM | NUMBER | Maximum weight for items stacked together | ||
| UOM_STACKING_WEIGHT_MAXIMUM | VARCHAR2 | (3) | Unit Of Measure of Maximum Stacking Weight | |
| ORDERING_LEAD_TIME | NUMBER | 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_QUANTITY_MULTIPLE | NUMBER | (9) | Multiples in which the item can be ordered | |
| ORDER_SIZING_FACTOR | NUMBER | (9) | Item specification other than weight, vol used for order sizing | |
| EFFECTIVE_START_DATE | DATE | Date when price is effective | ||
| CATALOG_PRICE | NUMBER | Catalog Price | ||
| EFFECTIVE_END_DATE | DATE | Date when price is no longer effective | ||
| SUGGESTED_RETAIL_PRICE | NUMBER | MSRP | ||
| MATERIAL_SAFETY_DATA_SHEET_NO | VARCHAR2 | (20) | Material Satety Data Number | |
| 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 | |
| DIAMETER | NUMBER | Item diameter | ||
| UOM_DIAMETER | VARCHAR2 | (3) | Item diameter Unit Of Measure | |
| DRAINED_WEIGHT | NUMBER | Weight when item is drained | ||
| UOM_DRAINED_WEIGHT | VARCHAR2 | (3) | Unit Of Measure for drained weight | |
| GENERIC_INGREDIENT | VARCHAR2 | (35) | Generic | |
| GENERIC_INGREDIENT_STRGTH | NUMBER | Strength of generic ingridient | ||
| UOM_GENERIC_INGREDIENT_STRGTH | 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 | NUMBER | Horizontal item peg | ||
| UOM_PEG_HORIZONTAL | VARCHAR2 | (3) | Unit of Measure for horizontal peg | |
| PEG_VERTICAL | NUMBER | Vertical Peg | ||
| UOM_PEG_VERTICAL | VARCHAR2 | (3) | Unit Of Measure for vertical peg | |
| CONSUMER_AVAIL_DATE_TIME | DATE | Date of availability to consumer | ||
| DEL_TO_DIST_CNTR_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_CNTR_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_MRKT_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_MRKT_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 | |
| SUB_BRAND | VARCHAR2 | (35) | Items sub brand | |
| TRADE_ITEM_DESCRIPTOR | VARCHAR2 | (35) | Product hierarchy level | |
| EANUCC_CODE | VARCHAR2 | (20) | EAN UCC code | |
| EANUCC_TYPE | VARCHAR2 | (30) | EAN UCC code type | |
| RETAIL_PRICE_ON_TRADE_ITEM | NUMBER | (17) | Is retail price on the item | |
| 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 | |
| TARGET_MARKET_DESC | VARCHAR2 | (35) | Description of Target Market | |
| QUANTITY_OF_INNER_PACK | NUMBER | (3) | Number of inner packs | |
| BRAND_OWNER_GLN | VARCHAR2 | (35) | Global Locator Number of brand owner | |
| BRAND_OWNER_NAME | VARCHAR2 | (35) | Name of Brand Owner | |
| STORAGE_HANDLING_TEMP_MAX | NUMBER | (3) | Maximum Storage Temperature | |
| UOM_STORAGE_HANDLING_TEMP_MAX | VARCHAR2 | (3) | Unit Of measure for maximum handling temperature | |
| STORAGE_HANDLING_TEMP_MIN | NUMBER | (3) | Minimum Storage temperature | |
| UOM_STORAGE_HANDLING_TEMP_MIN | VARCHAR2 | (3) | Unit of measure for minimum handling temperature | |
| TRADE_ITEM_COUPON | NUMBER | (3) | Coupon Family Code | |
| 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 | |
| ISBN_NUMBER | VARCHAR2 | (10) | ISBN Number | |
| ISSN_NUMBER | VARCHAR2 | (10) | ISSN Number | |
| 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 | |
| PUBLICATION_STATUS | NUMBER | (15) | Publication status | |
| TOP_GTIN | VARCHAR2 | (15) | Does the hierarchy contain 1 consumeable 1 orderable unit | |
| SECURITY_TAG_LOCATION | VARCHAR2 | (35) | Security tag location on item | |
| URL_FOR_WARRANTY | VARCHAR2 | (80) | Warranty URL | |
| NESTING_INCREMENT | NUMBER | 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 | |
| PIECES_PER_TRADE_ITEM | NUMBER | Number of pieces used to make the item | ||
| UOM_PIECES_PER_TRADE_ITEM | VARCHAR2 | (3) | Unit of Measure for pieces for trade item | |
| 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 | |
| REGISTRATION_UPDATE_DATE | DATE | Date when registration attrs last updated | ||
| TP_NEUTRAL_UPDATE_DATE | DATE | Date when TP neutral attrs last updated | ||
| IS_BARCODE_SYMBOLOGY_DERIVABLE | VARCHAR2 | (1) | Flag to indicate whether bar code symbology is derivable from GTIN or not | |
| REQUEST_ID | NUMBER | Request Id |
Cut, paste (and edit) the following text to query this object:
SELECT EXTENSION_ID
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ITEM_CATALOG_GROUP_ID
, REVISION_ID
, IS_TRADE_ITEM_A_CONSUMER_UNIT
, IS_TRADE_ITEM_INFO_PRIVATE
, GROSS_WEIGHT
, UOM_GROSS_WEIGHT
, EFFECTIVE_DATE
, CANCELED_DATE
, DISCONTINUED_DATE
, END_AVAILABILITY_DATE_TIME
, START_AVAILABILITY_DATE_TIME
, BRAND_NAME
, IS_TRADE_ITEM_A_BASE_UNIT
, IS_TRADE_ITEM_A_VARIABLE_UNIT
, 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
, STACKING_FACTOR
, STACKING_WEIGHT_MAXIMUM
, UOM_STACKING_WEIGHT_MAXIMUM
, ORDERING_LEAD_TIME
, UOM_ORDERING_LEAD_TIME
, ORDER_QUANTITY_MAX
, ORDER_QUANTITY_MIN
, ORDER_QUANTITY_MULTIPLE
, ORDER_SIZING_FACTOR
, EFFECTIVE_START_DATE
, CATALOG_PRICE
, EFFECTIVE_END_DATE
, SUGGESTED_RETAIL_PRICE
, MATERIAL_SAFETY_DATA_SHEET_NO
, HAS_BATCH_NUMBER
, IS_NON_SOLD_TRADE_RET_FLAG
, IS_TRADE_ITEM_MAR_REC_FLAG
, DIAMETER
, UOM_DIAMETER
, DRAINED_WEIGHT
, UOM_DRAINED_WEIGHT
, GENERIC_INGREDIENT
, GENERIC_INGREDIENT_STRGTH
, UOM_GENERIC_INGREDIENT_STRGTH
, INGREDIENT_STRENGTH
, IS_NET_CONTENT_DEC_FLAG
, NET_CONTENT
, UOM_NET_CONTENT
, PEG_HORIZONTAL
, UOM_PEG_HORIZONTAL
, PEG_VERTICAL
, UOM_PEG_VERTICAL
, CONSUMER_AVAIL_DATE_TIME
, DEL_TO_DIST_CNTR_TEMP_MAX
, UOM_DEL_TO_DIST_CNTR_TEMP_MAX
, DEL_TO_DIST_CNTR_TEMP_MIN
, UOM_DEL_TO_DIST_CNTR_TEMP_MIN
, DELIVERY_TO_MRKT_TEMP_MAX
, UOM_DELIVERY_TO_MRKT_TEMP_MAX
, DELIVERY_TO_MRKT_TEMP_MIN
, UOM_DELIVERY_TO_MRKT_TEMP_MIN
, SUB_BRAND
, TRADE_ITEM_DESCRIPTOR
, EANUCC_CODE
, EANUCC_TYPE
, RETAIL_PRICE_ON_TRADE_ITEM
, QUANTITY_OF_COMP_LAY_ITEM
, QUANITY_OF_ITEM_IN_LAYER
, QUANTITY_OF_ITEM_INNER_PACK
, TARGET_MARKET_DESC
, QUANTITY_OF_INNER_PACK
, 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
, DEGREE_OF_ORIGINAL_WORT
, FAT_PERCENT_IN_DRY_MATTER
, PERCENT_OF_ALCOHOL_BY_VOL
, ISBN_NUMBER
, ISSN_NUMBER
, IS_INGREDIENT_IRRADIATED
, IS_RAW_MATERIAL_IRRADIATED
, IS_TRADE_ITEM_GENETICALLY_MOD
, IS_TRADE_ITEM_IRRADIATED
, PUBLICATION_STATUS
, TOP_GTIN
, SECURITY_TAG_LOCATION
, URL_FOR_WARRANTY
, NESTING_INCREMENT
, UOM_NESTING_INCREMENT
, IS_TRADE_ITEM_RECALLED
, MODEL_NUMBER
, PIECES_PER_TRADE_ITEM
, UOM_PIECES_PER_TRADE_ITEM
, DEPT_OF_TRNSPRT_DANG_GOODS_NUM
, RETURN_GOODS_POLICY
, IS_OUT_OF_BOX_PROVIDED
, REGISTRATION_UPDATE_DATE
, TP_NEUTRAL_UPDATE_DATE
, IS_BARCODE_SYMBOLOGY_DERIVABLE
, REQUEST_ID
FROM EGO.EGO_ITEM_GTN_ATTRS_B;
EGO.EGO_ITEM_GTN_ATTRS_B does not reference any database object
EGO.EGO_ITEM_GTN_ATTRS_B is referenced by following:
APPS
EGO_ITEM_GTN_ATTRS_B
|
|
|
|