VIEW: EGO.EGO_ITEM_GTN_ATTRS_B#

Source

View Text - Preformatted

select EXTENSION_ID EXTENSION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ITEM_CATALOG_GROUP_ID ITEM_CATALOG_GROUP_ID, REVISION_ID REVISION_ID, IS_TRADE_ITEM_A_CONSUMER_UNIT IS_TRADE_ITEM_A_CONSUMER_UNIT, IS_TRADE_ITEM_INFO_PRIVATE IS_TRADE_ITEM_INFO_PRIVATE, GROSS_WEIGHT GROSS_WEIGHT, UOM_GROSS_WEIGHT UOM_GROSS_WEIGHT, EFFECTIVE_DATE EFFECTIVE_DATE, CANCELED_DATE CANCELED_DATE, DISCONTINUED_DATE DISCONTINUED_DATE, END_AVAILABILITY_DATE_TIME END_AVAILABILITY_DATE_TIME, START_AVAILABILITY_DATE_TIME START_AVAILABILITY_DATE_TIME, BRAND_NAME BRAND_NAME, IS_TRADE_ITEM_A_BASE_UNIT IS_TRADE_ITEM_A_BASE_UNIT, IS_TRADE_ITEM_A_VARIABLE_UNIT IS_TRADE_ITEM_A_VARIABLE_UNIT, IS_PACK_MARKED_WITH_EXP_DATE IS_PACK_MARKED_WITH_EXP_DATE, IS_PACK_MARKED_WITH_GREEN_DOT IS_PACK_MARKED_WITH_GREEN_DOT, IS_PACK_MARKED_WITH_INGRED IS_PACK_MARKED_WITH_INGRED, IS_PACKAGE_MARKED_AS_REC IS_PACKAGE_MARKED_AS_REC, IS_PACKAGE_MARKED_RET IS_PACKAGE_MARKED_RET, STACKING_FACTOR STACKING_FACTOR, STACKING_WEIGHT_MAXIMUM STACKING_WEIGHT_MAXIMUM, UOM_STACKING_WEIGHT_MAXIMUM UOM_STACKING_WEIGHT_MAXIMUM, ORDERING_LEAD_TIME ORDERING_LEAD_TIME, UOM_ORDERING_LEAD_TIME UOM_ORDERING_LEAD_TIME, ORDER_QUANTITY_MAX ORDER_QUANTITY_MAX, ORDER_QUANTITY_MIN ORDER_QUANTITY_MIN, ORDER_QUANTITY_MULTIPLE ORDER_QUANTITY_MULTIPLE, ORDER_SIZING_FACTOR ORDER_SIZING_FACTOR, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, CATALOG_PRICE CATALOG_PRICE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, SUGGESTED_RETAIL_PRICE SUGGESTED_RETAIL_PRICE, MATERIAL_SAFETY_DATA_SHEET_NO MATERIAL_SAFETY_DATA_SHEET_NO, HAS_BATCH_NUMBER HAS_BATCH_NUMBER, IS_NON_SOLD_TRADE_RET_FLAG IS_NON_SOLD_TRADE_RET_FLAG, IS_TRADE_ITEM_MAR_REC_FLAG IS_TRADE_ITEM_MAR_REC_FLAG, DIAMETER DIAMETER, UOM_DIAMETER UOM_DIAMETER, DRAINED_WEIGHT DRAINED_WEIGHT, UOM_DRAINED_WEIGHT UOM_DRAINED_WEIGHT, GENERIC_INGREDIENT GENERIC_INGREDIENT, GENERIC_INGREDIENT_STRGTH GENERIC_INGREDIENT_STRGTH, UOM_GENERIC_INGREDIENT_STRGTH UOM_GENERIC_INGREDIENT_STRGTH, INGREDIENT_STRENGTH INGREDIENT_STRENGTH, IS_NET_CONTENT_DEC_FLAG IS_NET_CONTENT_DEC_FLAG, NET_CONTENT NET_CONTENT, UOM_NET_CONTENT UOM_NET_CONTENT, PEG_HORIZONTAL PEG_HORIZONTAL, UOM_PEG_HORIZONTAL UOM_PEG_HORIZONTAL, PEG_VERTICAL PEG_VERTICAL, UOM_PEG_VERTICAL UOM_PEG_VERTICAL, CONSUMER_AVAIL_DATE_TIME CONSUMER_AVAIL_DATE_TIME, DEL_TO_DIST_CNTR_TEMP_MAX DEL_TO_DIST_CNTR_TEMP_MAX, UOM_DEL_TO_DIST_CNTR_TEMP_MAX UOM_DEL_TO_DIST_CNTR_TEMP_MAX, DEL_TO_DIST_CNTR_TEMP_MIN DEL_TO_DIST_CNTR_TEMP_MIN, UOM_DEL_TO_DIST_CNTR_TEMP_MIN UOM_DEL_TO_DIST_CNTR_TEMP_MIN, DELIVERY_TO_MRKT_TEMP_MAX DELIVERY_TO_MRKT_TEMP_MAX, UOM_DELIVERY_TO_MRKT_TEMP_MAX UOM_DELIVERY_TO_MRKT_TEMP_MAX, DELIVERY_TO_MRKT_TEMP_MIN DELIVERY_TO_MRKT_TEMP_MIN, UOM_DELIVERY_TO_MRKT_TEMP_MIN UOM_DELIVERY_TO_MRKT_TEMP_MIN, SUB_BRAND SUB_BRAND, TRADE_ITEM_DESCRIPTOR TRADE_ITEM_DESCRIPTOR, EANUCC_CODE EANUCC_CODE, EANUCC_TYPE EANUCC_TYPE, RETAIL_PRICE_ON_TRADE_ITEM RETAIL_PRICE_ON_TRADE_ITEM, QUANTITY_OF_COMP_LAY_ITEM QUANTITY_OF_COMP_LAY_ITEM, QUANITY_OF_ITEM_IN_LAYER QUANITY_OF_ITEM_IN_LAYER, QUANTITY_OF_ITEM_INNER_PACK QUANTITY_OF_ITEM_INNER_PACK, TARGET_MARKET_DESC TARGET_MARKET_DESC, QUANTITY_OF_INNER_PACK QUANTITY_OF_INNER_PACK, BRAND_OWNER_GLN BRAND_OWNER_GLN, BRAND_OWNER_NAME BRAND_OWNER_NAME, STORAGE_HANDLING_TEMP_MAX STORAGE_HANDLING_TEMP_MAX, UOM_STORAGE_HANDLING_TEMP_MAX UOM_STORAGE_HANDLING_TEMP_MAX, STORAGE_HANDLING_TEMP_MIN STORAGE_HANDLING_TEMP_MIN, UOM_STORAGE_HANDLING_TEMP_MIN UOM_STORAGE_HANDLING_TEMP_MIN, TRADE_ITEM_COUPON TRADE_ITEM_COUPON, DEGREE_OF_ORIGINAL_WORT DEGREE_OF_ORIGINAL_WORT, FAT_PERCENT_IN_DRY_MATTER FAT_PERCENT_IN_DRY_MATTER, PERCENT_OF_ALCOHOL_BY_VOL PERCENT_OF_ALCOHOL_BY_VOL, ISBN_NUMBER ISBN_NUMBER, ISSN_NUMBER ISSN_NUMBER, IS_INGREDIENT_IRRADIATED IS_INGREDIENT_IRRADIATED, IS_RAW_MATERIAL_IRRADIATED IS_RAW_MATERIAL_IRRADIATED, IS_TRADE_ITEM_GENETICALLY_MOD IS_TRADE_ITEM_GENETICALLY_MOD, IS_TRADE_ITEM_IRRADIATED IS_TRADE_ITEM_IRRADIATED, PUBLICATION_STATUS PUBLICATION_STATUS, TOP_GTIN TOP_GTIN, SECURITY_TAG_LOCATION SECURITY_TAG_LOCATION, URL_FOR_WARRANTY URL_FOR_WARRANTY, NESTING_INCREMENT NESTING_INCREMENT, UOM_NESTING_INCREMENT UOM_NESTING_INCREMENT, IS_TRADE_ITEM_RECALLED IS_TRADE_ITEM_RECALLED, MODEL_NUMBER MODEL_NUMBER, PIECES_PER_TRADE_ITEM PIECES_PER_TRADE_ITEM, UOM_PIECES_PER_TRADE_ITEM UOM_PIECES_PER_TRADE_ITEM, DEPT_OF_TRNSPRT_DANG_GOODS_NUM DEPT_OF_TRNSPRT_DANG_GOODS_NUM, RETURN_GOODS_POLICY RETURN_GOODS_POLICY, IS_OUT_OF_BOX_PROVIDED IS_OUT_OF_BOX_PROVIDED, REGISTRATION_UPDATE_DATE REGISTRATION_UPDATE_DATE, TP_NEUTRAL_UPDATE_DATE TP_NEUTRAL_UPDATE_DATE, IS_BARCODE_SYMBOLOGY_DERIVABLE IS_BARCODE_SYMBOLOGY_DERIVABLE, REQUEST_ID REQUEST_ID from "EGO"."EGO_ITEM_GTN_ATTRS_B"

View Text - HTML Formatted

SELECT EXTENSION_ID EXTENSION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ITEM_CATALOG_GROUP_ID ITEM_CATALOG_GROUP_ID
, REVISION_ID REVISION_ID
, IS_TRADE_ITEM_A_CONSUMER_UNIT IS_TRADE_ITEM_A_CONSUMER_UNIT
, IS_TRADE_ITEM_INFO_PRIVATE IS_TRADE_ITEM_INFO_PRIVATE
, GROSS_WEIGHT GROSS_WEIGHT
, UOM_GROSS_WEIGHT UOM_GROSS_WEIGHT
, EFFECTIVE_DATE EFFECTIVE_DATE
, CANCELED_DATE CANCELED_DATE
, DISCONTINUED_DATE DISCONTINUED_DATE
, END_AVAILABILITY_DATE_TIME END_AVAILABILITY_DATE_TIME
, START_AVAILABILITY_DATE_TIME START_AVAILABILITY_DATE_TIME
, BRAND_NAME BRAND_NAME
, IS_TRADE_ITEM_A_BASE_UNIT IS_TRADE_ITEM_A_BASE_UNIT
, IS_TRADE_ITEM_A_VARIABLE_UNIT IS_TRADE_ITEM_A_VARIABLE_UNIT
, IS_PACK_MARKED_WITH_EXP_DATE IS_PACK_MARKED_WITH_EXP_DATE
, IS_PACK_MARKED_WITH_GREEN_DOT IS_PACK_MARKED_WITH_GREEN_DOT
, IS_PACK_MARKED_WITH_INGRED IS_PACK_MARKED_WITH_INGRED
, IS_PACKAGE_MARKED_AS_REC IS_PACKAGE_MARKED_AS_REC
, IS_PACKAGE_MARKED_RET IS_PACKAGE_MARKED_RET
, STACKING_FACTOR STACKING_FACTOR
, STACKING_WEIGHT_MAXIMUM STACKING_WEIGHT_MAXIMUM
, UOM_STACKING_WEIGHT_MAXIMUM UOM_STACKING_WEIGHT_MAXIMUM
, ORDERING_LEAD_TIME ORDERING_LEAD_TIME
, UOM_ORDERING_LEAD_TIME UOM_ORDERING_LEAD_TIME
, ORDER_QUANTITY_MAX ORDER_QUANTITY_MAX
, ORDER_QUANTITY_MIN ORDER_QUANTITY_MIN
, ORDER_QUANTITY_MULTIPLE ORDER_QUANTITY_MULTIPLE
, ORDER_SIZING_FACTOR ORDER_SIZING_FACTOR
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, CATALOG_PRICE CATALOG_PRICE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, SUGGESTED_RETAIL_PRICE SUGGESTED_RETAIL_PRICE
, MATERIAL_SAFETY_DATA_SHEET_NO MATERIAL_SAFETY_DATA_SHEET_NO
, HAS_BATCH_NUMBER HAS_BATCH_NUMBER
, IS_NON_SOLD_TRADE_RET_FLAG IS_NON_SOLD_TRADE_RET_FLAG
, IS_TRADE_ITEM_MAR_REC_FLAG IS_TRADE_ITEM_MAR_REC_FLAG
, DIAMETER DIAMETER
, UOM_DIAMETER UOM_DIAMETER
, DRAINED_WEIGHT DRAINED_WEIGHT
, UOM_DRAINED_WEIGHT UOM_DRAINED_WEIGHT
, GENERIC_INGREDIENT GENERIC_INGREDIENT
, GENERIC_INGREDIENT_STRGTH GENERIC_INGREDIENT_STRGTH
, UOM_GENERIC_INGREDIENT_STRGTH UOM_GENERIC_INGREDIENT_STRGTH
, INGREDIENT_STRENGTH INGREDIENT_STRENGTH
, IS_NET_CONTENT_DEC_FLAG IS_NET_CONTENT_DEC_FLAG
, NET_CONTENT NET_CONTENT
, UOM_NET_CONTENT UOM_NET_CONTENT
, PEG_HORIZONTAL PEG_HORIZONTAL
, UOM_PEG_HORIZONTAL UOM_PEG_HORIZONTAL
, PEG_VERTICAL PEG_VERTICAL
, UOM_PEG_VERTICAL UOM_PEG_VERTICAL
, CONSUMER_AVAIL_DATE_TIME CONSUMER_AVAIL_DATE_TIME
, DEL_TO_DIST_CNTR_TEMP_MAX DEL_TO_DIST_CNTR_TEMP_MAX
, UOM_DEL_TO_DIST_CNTR_TEMP_MAX UOM_DEL_TO_DIST_CNTR_TEMP_MAX
, DEL_TO_DIST_CNTR_TEMP_MIN DEL_TO_DIST_CNTR_TEMP_MIN
, UOM_DEL_TO_DIST_CNTR_TEMP_MIN UOM_DEL_TO_DIST_CNTR_TEMP_MIN
, DELIVERY_TO_MRKT_TEMP_MAX DELIVERY_TO_MRKT_TEMP_MAX
, UOM_DELIVERY_TO_MRKT_TEMP_MAX UOM_DELIVERY_TO_MRKT_TEMP_MAX
, DELIVERY_TO_MRKT_TEMP_MIN DELIVERY_TO_MRKT_TEMP_MIN
, UOM_DELIVERY_TO_MRKT_TEMP_MIN UOM_DELIVERY_TO_MRKT_TEMP_MIN
, SUB_BRAND SUB_BRAND
, TRADE_ITEM_DESCRIPTOR TRADE_ITEM_DESCRIPTOR
, EANUCC_CODE EANUCC_CODE
, EANUCC_TYPE EANUCC_TYPE
, RETAIL_PRICE_ON_TRADE_ITEM RETAIL_PRICE_ON_TRADE_ITEM
, QUANTITY_OF_COMP_LAY_ITEM QUANTITY_OF_COMP_LAY_ITEM
, QUANITY_OF_ITEM_IN_LAYER QUANITY_OF_ITEM_IN_LAYER
, QUANTITY_OF_ITEM_INNER_PACK QUANTITY_OF_ITEM_INNER_PACK
, TARGET_MARKET_DESC TARGET_MARKET_DESC
, QUANTITY_OF_INNER_PACK QUANTITY_OF_INNER_PACK
, BRAND_OWNER_GLN BRAND_OWNER_GLN
, BRAND_OWNER_NAME BRAND_OWNER_NAME
, STORAGE_HANDLING_TEMP_MAX STORAGE_HANDLING_TEMP_MAX
, UOM_STORAGE_HANDLING_TEMP_MAX UOM_STORAGE_HANDLING_TEMP_MAX
, STORAGE_HANDLING_TEMP_MIN STORAGE_HANDLING_TEMP_MIN
, UOM_STORAGE_HANDLING_TEMP_MIN UOM_STORAGE_HANDLING_TEMP_MIN
, TRADE_ITEM_COUPON TRADE_ITEM_COUPON
, DEGREE_OF_ORIGINAL_WORT DEGREE_OF_ORIGINAL_WORT
, FAT_PERCENT_IN_DRY_MATTER FAT_PERCENT_IN_DRY_MATTER
, PERCENT_OF_ALCOHOL_BY_VOL PERCENT_OF_ALCOHOL_BY_VOL
, ISBN_NUMBER ISBN_NUMBER
, ISSN_NUMBER ISSN_NUMBER
, IS_INGREDIENT_IRRADIATED IS_INGREDIENT_IRRADIATED
, IS_RAW_MATERIAL_IRRADIATED IS_RAW_MATERIAL_IRRADIATED
, IS_TRADE_ITEM_GENETICALLY_MOD IS_TRADE_ITEM_GENETICALLY_MOD
, IS_TRADE_ITEM_IRRADIATED IS_TRADE_ITEM_IRRADIATED
, PUBLICATION_STATUS PUBLICATION_STATUS
, TOP_GTIN TOP_GTIN
, SECURITY_TAG_LOCATION SECURITY_TAG_LOCATION
, URL_FOR_WARRANTY URL_FOR_WARRANTY
, NESTING_INCREMENT NESTING_INCREMENT
, UOM_NESTING_INCREMENT UOM_NESTING_INCREMENT
, IS_TRADE_ITEM_RECALLED IS_TRADE_ITEM_RECALLED
, MODEL_NUMBER MODEL_NUMBER
, PIECES_PER_TRADE_ITEM PIECES_PER_TRADE_ITEM
, UOM_PIECES_PER_TRADE_ITEM UOM_PIECES_PER_TRADE_ITEM
, DEPT_OF_TRNSPRT_DANG_GOODS_NUM DEPT_OF_TRNSPRT_DANG_GOODS_NUM
, RETURN_GOODS_POLICY RETURN_GOODS_POLICY
, IS_OUT_OF_BOX_PROVIDED IS_OUT_OF_BOX_PROVIDED
, REGISTRATION_UPDATE_DATE REGISTRATION_UPDATE_DATE
, TP_NEUTRAL_UPDATE_DATE TP_NEUTRAL_UPDATE_DATE
, IS_BARCODE_SYMBOLOGY_DERIVABLE IS_BARCODE_SYMBOLOGY_DERIVABLE
, REQUEST_ID REQUEST_ID
FROM "EGO"."EGO_ITEM_GTN_ATTRS_B"