eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: GMI.IC_ITEM_MST_B

Object Details

Object Name:	IC_ITEM_MST_B
Object Type:	TABLE
Owner:	GMI
FND Design Data:	GMI.IC_ITEM_MST_B
Subobject Name:
Status:	VALID

This is the Item definition table. It contains all information relating to an item, such as lot/sublot control, unit of measure information, and all class and type designations.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IC_ITEM_MST_B_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ITEM_ID
IC_ITEM_MST_B_UNQ1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ITEM_NO

Columns

Name	Datatype	Length	Mandatory	Comments
ITEM_ID	NUMBER	(10)	Yes	Surrogate key for the item.
ITEM_NO	VARCHAR2	(32)	Yes	Name of the item.
ITEM_DESC1	VARCHAR2	(70)		Short description of the item that is displayed during the item look up.
ITEM_DESC2	VARCHAR2	(70)		Short description of the item that is not displayed during the item look up.
ALT_ITEMA	VARCHAR2	(32)		Alternate name for the item.
ALT_ITEMB	VARCHAR2	(32)		Second alternate name for the item.
ITEM_UM	VARCHAR2	(4)	Yes	Uom of the item by which the inventory balances are maintained.
DUALUM_IND	NUMBER	(5)	Yes	Dual unit of measure indicator. 0=Single UOM control, 1=Fixed relationship dual UOM control, 2=Variable relationship dual UOM control with default conversion displayed, 3= Variable relationship dual UOM control with default conversion not
ITEM_UM2	VARCHAR2	(4)		Second UOM for in which inventory balances are maintained, for dual UOM items.
DEVIATION_LO	NUMBER		Yes	Factor defining the allowable deviation below the standard conversion for dual UOM items w/ dualum_ind=2 or 3.
DEVIATION_HI	NUMBER		Yes	Factor defining the allowable deviation above the standard conversion for dual UOM items w/dualum_ind=2 or.
LEVEL_CODE	NUMBER	(5)		Not currently used.
LOT_CTL	NUMBER	(5)	Yes	Lot control indicator. 0=Not lot controlled, 1=Lot controlled.
LOT_INDIVISIBLE	NUMBER	(5)	Yes	Indivisible indicator. 0=Lots are not indivisible (can be split), 1=Lots are indivisible (cannot be split).
SUBLOT_CTL	NUMBER	(5)	Yes	Sublot control indicator. 0=Not sublot controlled, 1=Sublot controlled. Used only if lot_ctl =1.
LOCT_CTL	NUMBER	(5)	Yes	Location control indicator. 0=Not location controlled, 1=Location controlled.
NONINV_IND	NUMBER	(5)	Yes	Noninventory indicator. 0=Not a noninventory item (inventory balances NONINV_IND = 0, Inventory Item. are maintained), 1=Noninventory item (inventory balances are not = 1, Non-Inventory Item. maintained).
MATCH_TYPE	NUMBER	(5)	Yes	Type of invoice matching done. Blank=No matching, 2=Two way matching, 3=Three way matching.
INACTIVE_IND	NUMBER	(5)	Yes	Inactive indicator. 0=Active, 1=Inactive.
INV_TYPE	VARCHAR2	(4)		Inventory type. User defined.
SHELF_LIFE	NUMBER		Yes	Shelf life. This number of days is added to lots of grade controlled items to calculate the expiration date.
RETEST_INTERVAL	NUMBER		Yes	Number of days specifying how often grade controlled items should be retested.
GL_CLASS	VARCHAR2	(8)		GL class for an item.
INV_CLASS	VARCHAR2	(8)		Inventory class for an item.
SALES_CLASS	VARCHAR2	(8)		Sales class for an item.
SHIP_CLASS	VARCHAR2	(8)		Ship class for an item.
FRT_CLASS	VARCHAR2	(8)		Freight class for an item.
PRICE_CLASS	VARCHAR2	(8)		Price class for an item.
STORAGE_CLASS	VARCHAR2	(8)		Storage class for an item.
PURCH_CLASS	VARCHAR2	(8)		Purchase class for an item.
TAX_CLASS	VARCHAR2	(8)		Tax class for an item.
CUSTOMS_CLASS	VARCHAR2	(8)		Customs class for an item.
ALLOC_CLASS	VARCHAR2	(8)		Allocation class for an item. Used for auto-allocation.
PLANNING_CLASS	VARCHAR2	(8)		Planning class for an item. Used for MPS and MRP reporting.
ITEMCOST_CLASS	VARCHAR2	(8)		Cost class for an item.
COST_MTHD_CODE	VARCHAR2	(4)		Not currently used.
UPC_CODE	VARCHAR2	(16)		Not currently used.
GRADE_CTL	NUMBER	(5)	Yes	Grade control indicator. 0=Not grade controlled, 1=Grade controlled.
STATUS_CTL	NUMBER	(5)	Yes	Status control indicator. 0=Not status controlled, 1=Status controlled.
QC_GRADE	VARCHAR2	(4)		Default grade, for lots of grade controlled items.
LOT_STATUS	VARCHAR2	(4)		Default status, for lots of status controlled items.
BULK_ID	NUMBER	(10)		Not currently used.
PKG_ID	NUMBER	(10)		Not currently used.
QCITEM_ID	NUMBER	(10)		QC reference item.
QCHOLD_RES_CODE	VARCHAR2	(4)		QC hold reason code.
EXPACTION_CODE	VARCHAR2	(4)		Code for action to take when a lot expires.
FILL_QTY	NUMBER		Yes	Not currently used.
FILL_UM	VARCHAR2	(4)		Not currently used.
EXPACTION_INTERVAL	NUMBER		Yes	Interval between time lot expires and time expaction_code action should be taken.
PHANTOM_TYPE	NUMBER	(5)	Yes	Not currently used.
WHSE_ITEM_ID	NUMBER	(10)	Yes	For sharing a common ps_whse_eff row.
EXPERIMENTAL_IND	NUMBER	(5)	Yes	Experimental indicator. 0=Unrestricted use item (not experimental); 1=Experimental item (cannot be used in FM or PM).
EXPORTED_DATE	DATE		Yes	Date the item was exported to Oracle Financials.
TRANS_CNT	NUMBER	(10)		Not currently used
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
SEQ_DPND_CLASS	VARCHAR2	(8)		Sequence dependent class.
COMMODITY_CODE	VARCHAR2	(9)		reference code associated with a product class. Used for export/ importing among European countries.
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent who column
PROGRAM_ID	NUMBER	(15)		Concurrent who column
PROGRAM_UPDATE_DATE	DATE			Concurrent who column
REQUEST_ID	NUMBER	(15)		Concurrent who column
ATTRIBUTE1	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE16	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE17	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE18	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE19	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE20	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE21	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE22	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE23	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE24	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE25	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE26	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE27	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE28	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE29	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE30	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield segment
ITEM_ABCCODE	VARCHAR2	(4)		ABC Code for the item.
ONT_PRICING_QTY_SOURCE	NUMBER	(5)		OM/OPM integration pricing by quantity 2 indicator - 0 indicates pricing by order quantity; 1 indicates pricing by secondary quantity
ALLOC_CATEGORY_ID	NUMBER			Category Id for ALLOC_CLASS
CUSTOMS_CATEGORY_ID	NUMBER			Category Id for CUSTOMS_CLASS
FRT_CATEGORY_ID	NUMBER			Category Id for FRT_CLASS
GL_CATEGORY_ID	NUMBER			Category Id for GL_CLASS
INV_CATEGORY_ID	NUMBER			Category Id for INV_CLASS
COST_CATEGORY_ID	NUMBER			Category Id for COST_CLASS
PLANNING_CATEGORY_ID	NUMBER			Category Id for PLANNING_CLASS
PRICE_CATEGORY_ID	NUMBER			Category Id for PRICE_CLASS
PURCH_CATEGORY_ID	NUMBER			Category Id for PURCH_CLASS
SALES_CATEGORY_ID	NUMBER			Category Id for SALES_CLASS
SEQ_CATEGORY_ID	NUMBER			Category Id for SEQ_CLASS
SHIP_CATEGORY_ID	NUMBER			Category Id for SHIP_CLASS
STORAGE_CATEGORY_ID	NUMBER			Category Id for STORAGE_CLASS
TAX_CATEGORY_ID	NUMBER			Category Id for TAX_CLASS
AUTOLOT_ACTIVE_INDICATOR	NUMBER	(1)		Indicates if Autolot Numbering is active for this Item
LOT_PREFIX	VARCHAR2	(32)		Lot Prefix for Autolot Numbering
LOT_SUFFIX	NUMBER	(32)		Lot Suffix for Autolot Numbering
SUBLOT_PREFIX	VARCHAR2	(32)		Sublot Prefix for Autolot Numbering
SUBLOT_SUFFIX	NUMBER	(32)		Sublot Suffix for Autolot Numbering

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ITEM_ID
,      ITEM_NO
,      ITEM_DESC1
,      ITEM_DESC2
,      ALT_ITEMA
,      ALT_ITEMB
,      ITEM_UM
,      DUALUM_IND
,      ITEM_UM2
,      DEVIATION_LO
,      DEVIATION_HI
,      LEVEL_CODE
,      LOT_CTL
,      LOT_INDIVISIBLE
,      SUBLOT_CTL
,      LOCT_CTL
,      NONINV_IND
,      MATCH_TYPE
,      INACTIVE_IND
,      INV_TYPE
,      SHELF_LIFE
,      RETEST_INTERVAL
,      GL_CLASS
,      INV_CLASS
,      SALES_CLASS
,      SHIP_CLASS
,      FRT_CLASS
,      PRICE_CLASS
,      STORAGE_CLASS
,      PURCH_CLASS
,      TAX_CLASS
,      CUSTOMS_CLASS
,      ALLOC_CLASS
,      PLANNING_CLASS
,      ITEMCOST_CLASS
,      COST_MTHD_CODE
,      UPC_CODE
,      GRADE_CTL
,      STATUS_CTL
,      QC_GRADE
,      LOT_STATUS
,      BULK_ID
,      PKG_ID
,      QCITEM_ID
,      QCHOLD_RES_CODE
,      EXPACTION_CODE
,      FILL_QTY
,      FILL_UM
,      EXPACTION_INTERVAL
,      PHANTOM_TYPE
,      WHSE_ITEM_ID
,      EXPERIMENTAL_IND
,      EXPORTED_DATE
,      TRANS_CNT
,      DELETE_MARK
,      TEXT_CODE
,      SEQ_DPND_CLASS
,      COMMODITY_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE_CATEGORY
,      ITEM_ABCCODE
,      ONT_PRICING_QTY_SOURCE
,      ALLOC_CATEGORY_ID
,      CUSTOMS_CATEGORY_ID
,      FRT_CATEGORY_ID
,      GL_CATEGORY_ID
,      INV_CATEGORY_ID
,      COST_CATEGORY_ID
,      PLANNING_CATEGORY_ID
,      PRICE_CATEGORY_ID
,      PURCH_CATEGORY_ID
,      SALES_CATEGORY_ID
,      SEQ_CATEGORY_ID
,      SHIP_CATEGORY_ID
,      STORAGE_CATEGORY_ID
,      TAX_CATEGORY_ID
,      AUTOLOT_ACTIVE_INDICATOR
,      LOT_PREFIX
,      LOT_SUFFIX
,      SUBLOT_PREFIX
,      SUBLOT_SUFFIX
FROM GMI.IC_ITEM_MST_B;

Dependencies

[top of page]

GMI.IC_ITEM_MST_B does not reference any database object

GMI.IC_ITEM_MST_B is referenced by following:

GMI: IC_ITEM_MST_B#