VIEW: GMI.GMI_ITEMS_XML_INTERFACE#

Source

View Text - Preformatted

select ITEM_INTERFACE_ID ITEM_INTERFACE_ID, EXT_ITEM_ID EXT_ITEM_ID, ITEM_NUMBER ITEM_NUMBER, ITEM_DESC1 ITEM_DESC1, ITEM_DESC2 ITEM_DESC2, ALT_ITEMA ALT_ITEMA, ALT_ITEMB ALT_ITEMB, ITEM_UOM ITEM_UOM, DUALUM_IND DUALUM_IND, ITEM_UOM2 ITEM_UOM2, DEVIATION_LO DEVIATION_LO, DEVIATION_HI DEVIATION_HI, LEVEL_CODE LEVEL_CODE, LOT_CTL LOT_CTL, LOT_INDIVISIBLE LOT_INDIVISIBLE, SUBLOT_CTL SUBLOT_CTL, LOCT_CTL LOCT_CTL, NONINV_IND NONINV_IND, MATCH_TYPE MATCH_TYPE, INACTIVE_IND INACTIVE_IND, INV_TYPE INV_TYPE, SHELF_LIFE SHELF_LIFE, RETEST_INTERVAL RETEST_INTERVAL, ITEM_ABCCODE ITEM_ABCCODE, GL_CLASS GL_CLASS, INV_CLASS INV_CLASS, SALES_CLASS SALES_CLASS, SHIP_CLASS SHIP_CLASS, FRT_CLASS FRT_CLASS, PRICE_CLASS PRICE_CLASS, STORAGE_CLASS STORAGE_CLASS, PURCH_CLASS PURCH_CLASS, TAX_CLASS TAX_CLASS, CUSTOMS_CLASS CUSTOMS_CLASS, ALLOC_CLASS ALLOC_CLASS, PLANNING_CLASS PLANNING_CLASS, ITEMCOST_CLASS ITEMCOST_CLASS, COST_MTHD_CODE COST_MTHD_CODE, UPC_CODE UPC_CODE, GRADE_CTL GRADE_CTL, STATUS_CTL STATUS_CTL, QC_GRADE QC_GRADE, LOT_STATUS LOT_STATUS, BULK_ID BULK_ID, PKG_ID PKG_ID, QCITEM_NUMBER QCITEM_NUMBER, QCHOLD_RES_CODE QCHOLD_RES_CODE, EXPACTION_CODE EXPACTION_CODE, FILL_QTY FILL_QTY, FILL_UM FILL_UM, EXPACTION_INTERVAL EXPACTION_INTERVAL, PHANTOM_TYPE PHANTOM_TYPE, WHSE_ITEM_NUMBER WHSE_ITEM_NUMBER, EXPERIMENTAL_IND EXPERIMENTAL_IND, EXPORTED_DATE EXPORTED_DATE, SEQ_DPND_CLASS SEQ_DPND_CLASS, COMMODITY_CODE COMMODITY_CODE, IC_MATR_DAYS IC_MATR_DAYS, IC_HOLD_DAYS IC_HOLD_DAYS, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, ATTRIBUTE21 ATTRIBUTE21, ATTRIBUTE22 ATTRIBUTE22, ATTRIBUTE23 ATTRIBUTE23, ATTRIBUTE24 ATTRIBUTE24, ATTRIBUTE25 ATTRIBUTE25, ATTRIBUTE26 ATTRIBUTE26, ATTRIBUTE27 ATTRIBUTE27, ATTRIBUTE28 ATTRIBUTE28, ATTRIBUTE29 ATTRIBUTE29, ATTRIBUTE30 ATTRIBUTE30, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, USER_NAME USER_NAME, ONT_PRICING_QTY_SOURCE ONT_PRICING_QTY_SOURCE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ERROR_TEXT ERROR_TEXT, PROCESSED_IND PROCESSED_IND from "GMI"."GMI_ITEMS_XML_INTERFACE"

View Text - HTML Formatted

SELECT ITEM_INTERFACE_ID ITEM_INTERFACE_ID
, EXT_ITEM_ID EXT_ITEM_ID
, ITEM_NUMBER ITEM_NUMBER
, ITEM_DESC1 ITEM_DESC1
, ITEM_DESC2 ITEM_DESC2
, ALT_ITEMA ALT_ITEMA
, ALT_ITEMB ALT_ITEMB
, ITEM_UOM ITEM_UOM
, DUALUM_IND DUALUM_IND
, ITEM_UOM2 ITEM_UOM2
, DEVIATION_LO DEVIATION_LO
, DEVIATION_HI DEVIATION_HI
, LEVEL_CODE LEVEL_CODE
, LOT_CTL LOT_CTL
, LOT_INDIVISIBLE LOT_INDIVISIBLE
, SUBLOT_CTL SUBLOT_CTL
, LOCT_CTL LOCT_CTL
, NONINV_IND NONINV_IND
, MATCH_TYPE MATCH_TYPE
, INACTIVE_IND INACTIVE_IND
, INV_TYPE INV_TYPE
, SHELF_LIFE SHELF_LIFE
, RETEST_INTERVAL RETEST_INTERVAL
, ITEM_ABCCODE ITEM_ABCCODE
, GL_CLASS GL_CLASS
, INV_CLASS INV_CLASS
, SALES_CLASS SALES_CLASS
, SHIP_CLASS SHIP_CLASS
, FRT_CLASS FRT_CLASS
, PRICE_CLASS PRICE_CLASS
, STORAGE_CLASS STORAGE_CLASS
, PURCH_CLASS PURCH_CLASS
, TAX_CLASS TAX_CLASS
, CUSTOMS_CLASS CUSTOMS_CLASS
, ALLOC_CLASS ALLOC_CLASS
, PLANNING_CLASS PLANNING_CLASS
, ITEMCOST_CLASS ITEMCOST_CLASS
, COST_MTHD_CODE COST_MTHD_CODE
, UPC_CODE UPC_CODE
, GRADE_CTL GRADE_CTL
, STATUS_CTL STATUS_CTL
, QC_GRADE QC_GRADE
, LOT_STATUS LOT_STATUS
, BULK_ID BULK_ID
, PKG_ID PKG_ID
, QCITEM_NUMBER QCITEM_NUMBER
, QCHOLD_RES_CODE QCHOLD_RES_CODE
, EXPACTION_CODE EXPACTION_CODE
, FILL_QTY FILL_QTY
, FILL_UM FILL_UM
, EXPACTION_INTERVAL EXPACTION_INTERVAL
, PHANTOM_TYPE PHANTOM_TYPE
, WHSE_ITEM_NUMBER WHSE_ITEM_NUMBER
, EXPERIMENTAL_IND EXPERIMENTAL_IND
, EXPORTED_DATE EXPORTED_DATE
, SEQ_DPND_CLASS SEQ_DPND_CLASS
, COMMODITY_CODE COMMODITY_CODE
, IC_MATR_DAYS IC_MATR_DAYS
, IC_HOLD_DAYS IC_HOLD_DAYS
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, ATTRIBUTE21 ATTRIBUTE21
, ATTRIBUTE22 ATTRIBUTE22
, ATTRIBUTE23 ATTRIBUTE23
, ATTRIBUTE24 ATTRIBUTE24
, ATTRIBUTE25 ATTRIBUTE25
, ATTRIBUTE26 ATTRIBUTE26
, ATTRIBUTE27 ATTRIBUTE27
, ATTRIBUTE28 ATTRIBUTE28
, ATTRIBUTE29 ATTRIBUTE29
, ATTRIBUTE30 ATTRIBUTE30
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, USER_NAME USER_NAME
, ONT_PRICING_QTY_SOURCE ONT_PRICING_QTY_SOURCE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ERROR_TEXT ERROR_TEXT
, PROCESSED_IND PROCESSED_IND
FROM "GMI"."GMI_ITEMS_XML_INTERFACE"