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.GMI_ITEMS_XML_INTERFACE

Object Details

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

This table holds the xml gateway api request to add an Item to OPM

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMI_ITEMS_XML_INTERFACE_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	ITEM_INTERFACE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ITEM_INTERFACE_ID	NUMBER		Yes	Surrogate key for the item.
EXT_ITEM_ID	NUMBER		Yes	External surrogate key for the xml api transaction, need not be unique in opm.
ITEM_NUMBER	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_UOM	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_UOM2	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			Not currently used.
LOT_CTL	NUMBER		Yes	Lot control indicator. 0=Not lot controlled, 1=Lot controlled.
LOT_INDIVISIBLE	NUMBER		Yes	Indivisible indicator. 0=Lots are not indivisible (can be split), 1=Lots are indivisible (cannot be split).
SUBLOT_CTL	NUMBER		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.
ITEM_ABCCODE	VARCHAR2	(4)		Unused Field.
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_NUMBER	VARCHAR2	(32)		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		Yes	Not currently used.
WHSE_ITEM_NUMBER	VARCHAR2	(32)	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	VARCHAR2	(26)	Yes	Date the item was exported to Oracle Financials - in canonical format.
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.
IC_MATR_DAYS	NUMBER			Maturity Days
IC_HOLD_DAYS	NUMBER			Hold Days
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
USER_NAME	VARCHAR2	(100)		User entering the api request.
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
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
ERROR_TEXT	VARCHAR2	(2000)		Message indicating result of api execution attempt
PROCESSED_IND	NUMBER	(5)		XML Item Processing Status

Query Text

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


SELECT ITEM_INTERFACE_ID
,      EXT_ITEM_ID
,      ITEM_NUMBER
,      ITEM_DESC1
,      ITEM_DESC2
,      ALT_ITEMA
,      ALT_ITEMB
,      ITEM_UOM
,      DUALUM_IND
,      ITEM_UOM2
,      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
,      ITEM_ABCCODE
,      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_NUMBER
,      QCHOLD_RES_CODE
,      EXPACTION_CODE
,      FILL_QTY
,      FILL_UM
,      EXPACTION_INTERVAL
,      PHANTOM_TYPE
,      WHSE_ITEM_NUMBER
,      EXPERIMENTAL_IND
,      EXPORTED_DATE
,      SEQ_DPND_CLASS
,      COMMODITY_CODE
,      IC_MATR_DAYS
,      IC_HOLD_DAYS
,      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
,      USER_NAME
,      ONT_PRICING_QTY_SOURCE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ERROR_TEXT
,      PROCESSED_IND
FROM GMI.GMI_ITEMS_XML_INTERFACE;

Dependencies

[top of page]

GMI.GMI_ITEMS_XML_INTERFACE does not reference any database object

GMI.GMI_ITEMS_XML_INTERFACE is referenced by following:

APPS: GMI_ITEMS_XML_INTERFACE