VIEW: GMI.IC_ITEM_MST_B#

Source

View Text - Preformatted

select ITEM_ID ITEM_ID, ITEM_NO ITEM_NO, ITEM_DESC1 ITEM_DESC1, ITEM_DESC2 ITEM_DESC2, ALT_ITEMA ALT_ITEMA, ALT_ITEMB ALT_ITEMB, ITEM_UM ITEM_UM, DUALUM_IND DUALUM_IND, ITEM_UM2 ITEM_UM2, 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, 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_ID QCITEM_ID, 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_ID WHSE_ITEM_ID, EXPERIMENTAL_IND EXPERIMENTAL_IND, EXPORTED_DATE EXPORTED_DATE, TRANS_CNT TRANS_CNT, DELETE_MARK DELETE_MARK, TEXT_CODE TEXT_CODE, SEQ_DPND_CLASS SEQ_DPND_CLASS, COMMODITY_CODE COMMODITY_CODE, 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, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, 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, ITEM_ABCCODE ITEM_ABCCODE, ONT_PRICING_QTY_SOURCE ONT_PRICING_QTY_SOURCE, ALLOC_CATEGORY_ID ALLOC_CATEGORY_ID, CUSTOMS_CATEGORY_ID CUSTOMS_CATEGORY_ID, FRT_CATEGORY_ID FRT_CATEGORY_ID, GL_CATEGORY_ID GL_CATEGORY_ID, INV_CATEGORY_ID INV_CATEGORY_ID, COST_CATEGORY_ID COST_CATEGORY_ID, PLANNING_CATEGORY_ID PLANNING_CATEGORY_ID, PRICE_CATEGORY_ID PRICE_CATEGORY_ID, PURCH_CATEGORY_ID PURCH_CATEGORY_ID, SALES_CATEGORY_ID SALES_CATEGORY_ID, SEQ_CATEGORY_ID SEQ_CATEGORY_ID, SHIP_CATEGORY_ID SHIP_CATEGORY_ID, STORAGE_CATEGORY_ID STORAGE_CATEGORY_ID, TAX_CATEGORY_ID TAX_CATEGORY_ID, AUTOLOT_ACTIVE_INDICATOR AUTOLOT_ACTIVE_INDICATOR, LOT_PREFIX LOT_PREFIX, LOT_SUFFIX LOT_SUFFIX, SUBLOT_PREFIX SUBLOT_PREFIX, SUBLOT_SUFFIX SUBLOT_SUFFIX from "GMI"."IC_ITEM_MST_B"

View Text - HTML Formatted

SELECT ITEM_ID ITEM_ID
, ITEM_NO ITEM_NO
, ITEM_DESC1 ITEM_DESC1
, ITEM_DESC2 ITEM_DESC2
, ALT_ITEMA ALT_ITEMA
, ALT_ITEMB ALT_ITEMB
, ITEM_UM ITEM_UM
, DUALUM_IND DUALUM_IND
, ITEM_UM2 ITEM_UM2
, 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
, 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_ID QCITEM_ID
, 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_ID WHSE_ITEM_ID
, EXPERIMENTAL_IND EXPERIMENTAL_IND
, EXPORTED_DATE EXPORTED_DATE
, TRANS_CNT TRANS_CNT
, DELETE_MARK DELETE_MARK
, TEXT_CODE TEXT_CODE
, SEQ_DPND_CLASS SEQ_DPND_CLASS
, COMMODITY_CODE COMMODITY_CODE
, 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
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, 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
, ITEM_ABCCODE ITEM_ABCCODE
, ONT_PRICING_QTY_SOURCE ONT_PRICING_QTY_SOURCE
, ALLOC_CATEGORY_ID ALLOC_CATEGORY_ID
, CUSTOMS_CATEGORY_ID CUSTOMS_CATEGORY_ID
, FRT_CATEGORY_ID FRT_CATEGORY_ID
, GL_CATEGORY_ID GL_CATEGORY_ID
, INV_CATEGORY_ID INV_CATEGORY_ID
, COST_CATEGORY_ID COST_CATEGORY_ID
, PLANNING_CATEGORY_ID PLANNING_CATEGORY_ID
, PRICE_CATEGORY_ID PRICE_CATEGORY_ID
, PURCH_CATEGORY_ID PURCH_CATEGORY_ID
, SALES_CATEGORY_ID SALES_CATEGORY_ID
, SEQ_CATEGORY_ID SEQ_CATEGORY_ID
, SHIP_CATEGORY_ID SHIP_CATEGORY_ID
, STORAGE_CATEGORY_ID STORAGE_CATEGORY_ID
, TAX_CATEGORY_ID TAX_CATEGORY_ID
, AUTOLOT_ACTIVE_INDICATOR AUTOLOT_ACTIVE_INDICATOR
, LOT_PREFIX LOT_PREFIX
, LOT_SUFFIX LOT_SUFFIX
, SUBLOT_PREFIX SUBLOT_PREFIX
, SUBLOT_SUFFIX SUBLOT_SUFFIX
FROM "GMI"."IC_ITEM_MST_B"