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_LOTS_CONV_XML_INTERFACE

Object Details

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

This table contains the Item/lot conversion xml api request.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMI_LOTS_CONV_XML_INTERFACE_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	CONV_INTERFACE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CONV_INTERFACE_ID	NUMBER		Yes	Surrogate key for this table.
EXT_CONV_ID	NUMBER		Yes	Uniquely identifies the api request at the user site. Need not be unique in opm.
ITEM_NUMBER	VARCHAR2	(32)	Yes	Item for which a conversion is defined.
LOT_NUMBER	VARCHAR2	(32)		Lot Number for which a conversion is defined.
SUBLOT_NUMBER	VARCHAR2	(32)		Sub Lot Number for which a conversion is defined.
FROM_UOM	VARCHAR2	(25)		From Unit of measure.
TO_UOM	VARCHAR2	(25)		To Unit of measure.
TYPE_FACTOR	NUMBER		Yes	Conversion factor. One unit of the conversion type (um_type) equals this many units of the items UOM type.
USER_NAME	VARCHAR2	(100)		User who entered the transaction .
LAST_UPDATE_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column
CREATION_DATE	DATE		Yes	Standard WHO Column
ERROR_TEXT	VARCHAR2	(2000)		Stores result of applying this api request
PROCESSED_IND	NUMBER	(5)		XML Lot Conversion Processing Status

Query Text

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


SELECT CONV_INTERFACE_ID
,      EXT_CONV_ID
,      ITEM_NUMBER
,      LOT_NUMBER
,      SUBLOT_NUMBER
,      FROM_UOM
,      TO_UOM
,      TYPE_FACTOR
,      USER_NAME
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      ERROR_TEXT
,      PROCESSED_IND
FROM GMI.GMI_LOTS_CONV_XML_INTERFACE;

Dependencies

[top of page]

GMI.GMI_LOTS_CONV_XML_INTERFACE does not reference any database object

GMI.GMI_LOTS_CONV_XML_INTERFACE is referenced by following:

APPS: GMI_LOTS_CONV_XML_INTERFACE