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]

VIEW: APPS.OP_TRAN_TMP_V

Object Details

Object Name:	OP_TRAN_TMP_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GML.OP_TRAN_TMP_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

View to populate Pick Lots screen from shipment form

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SESSION_ID	NUMBER		Yes	Users session id
ITEM_ID	NUMBER	(10)	Yes	Item id on the order line
WHSE_CODE	VARCHAR2	(4)	Yes	Warehouse code where inventory exists
LINE_ID	NUMBER			Maximum of Order line id
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
LOCATION	VARCHAR2	(16)		Location within the warehouse where inventory exists
LOT_STATUS	VARCHAR2	(4)		Code for the lot status
NETTABLE_IND	NUMBER	(5)		Indicates whether lots with this status are considered by MRP. 0=Lots
SHIPPING_IND	NUMBER	(5)		0=Not available for shipping; 1=Available for shipping if nettable and not rejected
REJECTED_IND	NUMBER	(5)		0=lot accepted; 1=lot rejected
ONHAND_QTY	NUMBER			Total Quantity of inventory onhand, in item_um1
ONHAND_QTY2	NUMBER			Total Quantity of inventory onhand, in item_um2
COMMIT_QTY	NUMBER			Total Committed quantity of inventory, in item_um1
COMMIT_QTY2	NUMBER			Total Committed quantity of inventory, in item_um2
AVAIL_QTY	NUMBER			Onhand Qty + Commit Qty in item_um1
AVAIL_QTY2	NUMBER			Onhand Qty2 + Commit Qty2 in item_um2
QTY1	NUMBER			Total Quantity of inventory allocated for this lot/sublot, in item_um1
QTY2	VARCHAR2	(40)		Total Quantity of inventory allocated for this lot/sublot, in item_um2
NUMB_TRANS_LINE	NUMBER			Total 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
,      ITEM_ID
,      WHSE_CODE
,      LINE_ID
,      LOT_NO
,      SUBLOT_NO
,      LOT_ID
,      LOT_CREATED
,      EXPIRE_DATE
,      QC_GRADE
,      LOCATION
,      LOT_STATUS
,      NETTABLE_IND
,      SHIPPING_IND
,      REJECTED_IND
,      ONHAND_QTY
,      ONHAND_QTY2
,      COMMIT_QTY
,      COMMIT_QTY2
,      AVAIL_QTY
,      AVAIL_QTY2
,      QTY1
,      QTY2
,      NUMB_TRANS_LINE
FROM APPS.OP_TRAN_TMP_V;

Dependencies

[top of page]

APPS.OP_TRAN_TMP_V references the following:

APPS: IC_LOCT_INV; IC_LOTS_STS; OP_TRAN_TMP

APPS.OP_TRAN_TMP_V is not referenced by any database object