[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | EGO_ITEM_GTN_ATTRS_B# |
|---|---|
| Object Type: | VIEW |
| Owner: | EGO |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| EXTENSION_ID | NUMBER | (15) | Yes | |
| INVENTORY_ITEM_ID | NUMBER | (15) | Yes | |
| ORGANIZATION_ID | NUMBER | (15) | Yes | |
| CREATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| ITEM_CATALOG_GROUP_ID | NUMBER | (15) | ||
| REVISION_ID | NUMBER | (15) | ||
| IS_TRADE_ITEM_A_CONSUMER_UNIT | VARCHAR2 | (1) | ||
| IS_TRADE_ITEM_INFO_PRIVATE | VARCHAR2 | (1) | ||
| GROSS_WEIGHT | NUMBER | |||
| UOM_GROSS_WEIGHT | VARCHAR2 | (3) | ||
| EFFECTIVE_DATE | DATE | |||
| CANCELED_DATE | DATE | |||
| DISCONTINUED_DATE | DATE | |||
| END_AVAILABILITY_DATE_TIME | DATE | |||
| START_AVAILABILITY_DATE_TIME | DATE | |||
| BRAND_NAME | VARCHAR2 | (50) | ||
| IS_TRADE_ITEM_A_BASE_UNIT | VARCHAR2 | (1) | ||
| IS_TRADE_ITEM_A_VARIABLE_UNIT | VARCHAR2 | (1) | ||
| IS_PACK_MARKED_WITH_EXP_DATE | VARCHAR2 | (1) | ||
| IS_PACK_MARKED_WITH_GREEN_DOT | VARCHAR2 | (1) | ||
| IS_PACK_MARKED_WITH_INGRED | VARCHAR2 | (1) | ||
| IS_PACKAGE_MARKED_AS_REC | VARCHAR2 | (1) | ||
| IS_PACKAGE_MARKED_RET | VARCHAR2 | (1) | ||
| STACKING_FACTOR | NUMBER | (6) | ||
| STACKING_WEIGHT_MAXIMUM | NUMBER | |||
| UOM_STACKING_WEIGHT_MAXIMUM | VARCHAR2 | (3) | ||
| ORDERING_LEAD_TIME | NUMBER | |||
| UOM_ORDERING_LEAD_TIME | VARCHAR2 | (3) | ||
| ORDER_QUANTITY_MAX | NUMBER | (9) | ||
| ORDER_QUANTITY_MIN | NUMBER | (9) | ||
| ORDER_QUANTITY_MULTIPLE | NUMBER | (9) | ||
| ORDER_SIZING_FACTOR | NUMBER | (9) | ||
| EFFECTIVE_START_DATE | DATE | |||
| CATALOG_PRICE | NUMBER | |||
| EFFECTIVE_END_DATE | DATE | |||
| SUGGESTED_RETAIL_PRICE | NUMBER | |||
| MATERIAL_SAFETY_DATA_SHEET_NO | VARCHAR2 | (20) | ||
| HAS_BATCH_NUMBER | VARCHAR2 | (1) | ||
| IS_NON_SOLD_TRADE_RET_FLAG | VARCHAR2 | (1) | ||
| IS_TRADE_ITEM_MAR_REC_FLAG | VARCHAR2 | (1) | ||
| DIAMETER | NUMBER | |||
| UOM_DIAMETER | VARCHAR2 | (3) | ||
| DRAINED_WEIGHT | NUMBER | |||
| UOM_DRAINED_WEIGHT | VARCHAR2 | (3) | ||
| GENERIC_INGREDIENT | VARCHAR2 | (35) | ||
| GENERIC_INGREDIENT_STRGTH | NUMBER | |||
| UOM_GENERIC_INGREDIENT_STRGTH | VARCHAR2 | (3) | ||
| INGREDIENT_STRENGTH | VARCHAR2 | (18) | ||
| IS_NET_CONTENT_DEC_FLAG | VARCHAR2 | (1) | ||
| NET_CONTENT | NUMBER | |||
| UOM_NET_CONTENT | VARCHAR2 | (3) | ||
| PEG_HORIZONTAL | NUMBER | |||
| UOM_PEG_HORIZONTAL | VARCHAR2 | (3) | ||
| PEG_VERTICAL | NUMBER | |||
| UOM_PEG_VERTICAL | VARCHAR2 | (3) | ||
| CONSUMER_AVAIL_DATE_TIME | DATE | |||
| DEL_TO_DIST_CNTR_TEMP_MAX | NUMBER | (3) | ||
| UOM_DEL_TO_DIST_CNTR_TEMP_MAX | VARCHAR2 | (3) | ||
| DEL_TO_DIST_CNTR_TEMP_MIN | NUMBER | (3) | ||
| UOM_DEL_TO_DIST_CNTR_TEMP_MIN | VARCHAR2 | (3) | ||
| DELIVERY_TO_MRKT_TEMP_MAX | NUMBER | (3) | ||
| UOM_DELIVERY_TO_MRKT_TEMP_MAX | VARCHAR2 | (3) | ||
| DELIVERY_TO_MRKT_TEMP_MIN | NUMBER | (3) | ||
| UOM_DELIVERY_TO_MRKT_TEMP_MIN | VARCHAR2 | (3) | ||
| SUB_BRAND | VARCHAR2 | (35) | ||
| TRADE_ITEM_DESCRIPTOR | VARCHAR2 | (35) | ||
| EANUCC_CODE | VARCHAR2 | (20) | ||
| EANUCC_TYPE | VARCHAR2 | (30) | ||
| RETAIL_PRICE_ON_TRADE_ITEM | NUMBER | (17) | ||
| QUANTITY_OF_COMP_LAY_ITEM | NUMBER | (6) | ||
| QUANITY_OF_ITEM_IN_LAYER | NUMBER | (6) | ||
| QUANTITY_OF_ITEM_INNER_PACK | NUMBER | (3) | ||
| TARGET_MARKET_DESC | VARCHAR2 | (35) | ||
| QUANTITY_OF_INNER_PACK | NUMBER | (3) | ||
| BRAND_OWNER_GLN | VARCHAR2 | (35) | ||
| BRAND_OWNER_NAME | VARCHAR2 | (35) | ||
| STORAGE_HANDLING_TEMP_MAX | NUMBER | (3) | ||
| UOM_STORAGE_HANDLING_TEMP_MAX | VARCHAR2 | (3) | ||
| STORAGE_HANDLING_TEMP_MIN | NUMBER | (3) | ||
| UOM_STORAGE_HANDLING_TEMP_MIN | VARCHAR2 | (3) | ||
| TRADE_ITEM_COUPON | NUMBER | (3) | ||
| DEGREE_OF_ORIGINAL_WORT | VARCHAR2 | (3) | ||
| FAT_PERCENT_IN_DRY_MATTER | NUMBER | (4) | ||
| PERCENT_OF_ALCOHOL_BY_VOL | NUMBER | (4) | ||
| ISBN_NUMBER | VARCHAR2 | (10) | ||
| ISSN_NUMBER | VARCHAR2 | (10) | ||
| IS_INGREDIENT_IRRADIATED | VARCHAR2 | (1) | ||
| IS_RAW_MATERIAL_IRRADIATED | VARCHAR2 | (1) | ||
| IS_TRADE_ITEM_GENETICALLY_MOD | VARCHAR2 | (1) | ||
| IS_TRADE_ITEM_IRRADIATED | VARCHAR2 | (1) | ||
| PUBLICATION_STATUS | NUMBER | (15) | ||
| TOP_GTIN | VARCHAR2 | (15) | ||
| SECURITY_TAG_LOCATION | VARCHAR2 | (35) | ||
| URL_FOR_WARRANTY | VARCHAR2 | (80) | ||
| NESTING_INCREMENT | NUMBER | |||
| UOM_NESTING_INCREMENT | VARCHAR2 | (3) | ||
| IS_TRADE_ITEM_RECALLED | VARCHAR2 | (1) | ||
| MODEL_NUMBER | VARCHAR2 | (50) | ||
| PIECES_PER_TRADE_ITEM | NUMBER | |||
| UOM_PIECES_PER_TRADE_ITEM | VARCHAR2 | (3) | ||
| DEPT_OF_TRNSPRT_DANG_GOODS_NUM | VARCHAR2 | (4) | ||
| RETURN_GOODS_POLICY | VARCHAR2 | (30) | ||
| IS_OUT_OF_BOX_PROVIDED | VARCHAR2 | (1) | ||
| REGISTRATION_UPDATE_DATE | DATE | |||
| TP_NEUTRAL_UPDATE_DATE | DATE | |||
| IS_BARCODE_SYMBOLOGY_DERIVABLE | VARCHAR2 | (1) | ||
| REQUEST_ID | NUMBER |
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
APPS
EGO_ITEM_GTN_ATTRS_B
|
|
|
|