[Home] [Help] [Dependency Information]

VIEW: EGO.EGO_ITEM_GTN_ATTRS_B#

Object Details

[View Source]

Columns

Query Text

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#;

Dependencies

[top of page]

EGO

EGO_ITEM_GTN_ATTRS_B

APPS

EGO_ITEM_GTN_ATTRS_B