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: GML.OP_TRAN_TMP

Object Details

Object Name:	OP_TRAN_TMP
Object Type:	TABLE
Owner:	GML
FND Design Data:	GML.OP_TRAN_TMP
Subobject Name:
Status:	VALID

This is a "temporary" table used by automatic inventory allocation in Shipping. Information retrieved during the automatic inventory allocation process is stored in this table and either displayed to the user or processed by the system to allocate lot controlled inventory automatically. The information is stored by session_id so that it can be deleted when processing is completed.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OP_TRAN_TMP_I1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	SESSION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SESSION_ID	NUMBER		Yes	Users session id
LINE_ID	NUMBER	(10)	Yes	Order line id
DOC_ID	NUMBER	(10)	Yes	Document id - either order_id or bol_id
ITEM_ID	NUMBER	(10)	Yes	Item id on the order line
LOT_NO	VARCHAR2	(32)		Lot number with available inventory
SUBLOT_NO	VARCHAR2	(32)		Sublot Number with available inventory
LOT_ID	NUMBER	(10)		Lot id for the Lot/Sublot combination
LOT_CREATED	DATE			Lot creation date
EXPIRE_DATE	DATE			Lot expiration date
QC_GRADE	VARCHAR2	(4)		QC grade of lot/sublot
WHSE_CODE	VARCHAR2	(4)	Yes	Warehouse code where inventory exists
LOCATION	VARCHAR2	(16)		Location within the warehouse where inventory exists
LOCT_ONHAND	NUMBER			Quantity of inventory onhand, in item_um1
LOCT_ONHAND2	NUMBER			Quantity of inventory onhand, in item_um2
COMMIT_QTY	NUMBER			Committed quantity of inventory, in item_um1
COMMIT_QTY2	NUMBER			Committed quantity of inventory, in item_um2
TRANS_ID	NUMBER	(10)		Id which uniquely identifies an inventory transaction record
ID_COUNT	NUMBER	(5)		Number of inventory transactions found
ALLOC_QTY	NUMBER			Quantity of inventory allocated for this lot/sublot, in item_um1
ALLOC_QTY2	NUMBER			Quantity of inventory allocated for this lot/sublot, in item_um2

Query Text

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


SELECT SESSION_ID
,      LINE_ID
,      DOC_ID
,      ITEM_ID
,      LOT_NO
,      SUBLOT_NO
,      LOT_ID
,      LOT_CREATED
,      EXPIRE_DATE
,      QC_GRADE
,      WHSE_CODE
,      LOCATION
,      LOCT_ONHAND
,      LOCT_ONHAND2
,      COMMIT_QTY
,      COMMIT_QTY2
,      TRANS_ID
,      ID_COUNT
,      ALLOC_QTY
,      ALLOC_QTY2
FROM GML.OP_TRAN_TMP;

Dependencies

[top of page]

GML.OP_TRAN_TMP does not reference any database object

GML.OP_TRAN_TMP is referenced by following:

APPS: OP_TRAN_TMP