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_QUANTITY_XML_INTERFACE

Object Details

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

This table entries for the XML Gateway Inventory Quantity API requests.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMI_QUANTITY_XML_INTERFACE_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	QUANTITY_INTERFACE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
QUANTITY_INTERFACE_ID	NUMBER		Yes	Surrogate key for this table.
EXT_TRANSACTION_ID	NUMBER		Yes	External Surrogate key for this api request, need not be unique in opm.
TRANSACTION_TYPE	VARCHAR2	(8)	Yes	Indicates which of the Quantity apis to be executed.
JOURNAL_NUMBER	VARCHAR2	(32)		Journal Number.
FROM_WAREHOUSE	VARCHAR2	(4)		From Warehouse.
TO_WAREHOUSE	VARCHAR2	(4)		To Warehouse.
PRIMARY_UOM	VARCHAR2	(4)		Primary Unit of Measure.
SECONDARY_UOM	VARCHAR2	(4)		Secondary Unit of Measure.
LOT_NUMBER	VARCHAR2	(32)		Lot Number
SUBLOT_NUMBER	VARCHAR2	(32)		Sublot Number
FROM_LOCATION	VARCHAR2	(16)		From Location.
TO_LOCATION	VARCHAR2	(16)		To Location
PRIMARY_TRANS_QTY	NUMBER			Primary Transaction Quantity
SECONDARY_TRANS_QTY	NUMBER			Secondary Transaction Quantity
QC_GRADE	VARCHAR2	(4)		Quality Control Grade
LOT_STATUS	VARCHAR2	(4)		Lot Status
CO_CODE	VARCHAR2	(4)		Company Code
ORGN_CODE	VARCHAR2	(4)	Yes	Organization Code
TRANSACTION_DATE	VARCHAR2	(26)		Transaction Date in canonical format
REASON_CODE	VARCHAR2	(4)	Yes	Reason Code
USER_NAME	VARCHAR2	(100)		User who submitted the API request
JOURNAL_COMMENT	VARCHAR2	(70)		Journal Comment
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
ERROR_TEXT	VARCHAR2	(2000)		Message area indicating results of applying this api request to the database.
ITEM_NUMBER	VARCHAR2	(32)	Yes	Item Number
PROCESSED_IND	NUMBER	(5)		XML Quantity Processing Status
ACCTG_UNIT_NO	VARCHAR2	(240)		Accounting unit number
ACCT_NO	VARCHAR2	(240)		Account number
ATTRIBUTE1	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
ATTRIBUTE2	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
ATTRIBUTE3	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE30	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
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield segment

Query Text

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


SELECT QUANTITY_INTERFACE_ID
,      EXT_TRANSACTION_ID
,      TRANSACTION_TYPE
,      JOURNAL_NUMBER
,      FROM_WAREHOUSE
,      TO_WAREHOUSE
,      PRIMARY_UOM
,      SECONDARY_UOM
,      LOT_NUMBER
,      SUBLOT_NUMBER
,      FROM_LOCATION
,      TO_LOCATION
,      PRIMARY_TRANS_QTY
,      SECONDARY_TRANS_QTY
,      QC_GRADE
,      LOT_STATUS
,      CO_CODE
,      ORGN_CODE
,      TRANSACTION_DATE
,      REASON_CODE
,      USER_NAME
,      JOURNAL_COMMENT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ERROR_TEXT
,      ITEM_NUMBER
,      PROCESSED_IND
,      ACCTG_UNIT_NO
,      ACCT_NO
,      ATTRIBUTE1
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE2
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE3
,      ATTRIBUTE30
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE_CATEGORY
FROM GMI.GMI_QUANTITY_XML_INTERFACE;

Dependencies

[top of page]

GMI.GMI_QUANTITY_XML_INTERFACE does not reference any database object

GMI.GMI_QUANTITY_XML_INTERFACE is referenced by following:

GMI: GMI_QUANTITY_XML_INTERFACE#