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

Object Details

Object Name:	MTL_LOT_ONHAND_SUM_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	INV.MTL_LOT_ONHAND_SUM_V
Subobject Name:
Status:	VALID

The view is used to get total onhand of a lot number.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
ORGANIZATION_CODE	VARCHAR2	(3)		Organization code
SUBINVENTORY_CODE	VARCHAR2	(10)	Yes	Subinventory code
LOCATOR_ID	NUMBER			Locator identifier
LOCATOR	VARCHAR2	(1)		Locator
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
ITEM_DESCRIPTION	VARCHAR2	(240)		Item Description
ITEM	VARCHAR2	(40)		Concatenated segments based on the System Item key flexfield definition
REVISION	VARCHAR2	(3)		Item revision code
UOM	VARCHAR2	(3)		Item Primary UOM
ON_HAND	NUMBER			Primary On Hand
LPN_ID	NUMBER			LPN ID
LPN	VARCHAR2	(30)		LPN
LOT_NUMBER	VARCHAR2	(80)		Lot Number
SUBINVENTORY_STATUS_ID	NUMBER			Subinventory Status ID
LOCATOR_STATUS_ID	NUMBER			Locator Status ID
LOT_STATUS_ID	NUMBER			Lot Status ID
SECONDARY_UOM_CODE	VARCHAR2	(3)		Secondary UOM Code
SECONDARY_ONHAND	NUMBER			Secondary Onhand Quantity
GRADE_CODE	VARCHAR2	(150)		Grade Code

Query Text

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


SELECT ORGANIZATION_ID
,      ORGANIZATION_CODE
,      SUBINVENTORY_CODE
,      LOCATOR_ID
,      LOCATOR
,      INVENTORY_ITEM_ID
,      ITEM_DESCRIPTION
,      ITEM
,      REVISION
,      UOM
,      ON_HAND
,      LPN_ID
,      LPN
,      LOT_NUMBER
,      SUBINVENTORY_STATUS_ID
,      LOCATOR_STATUS_ID
,      LOT_STATUS_ID
,      SECONDARY_UOM_CODE
,      SECONDARY_ONHAND
,      GRADE_CODE
FROM APPS.MTL_LOT_ONHAND_SUM_V;

Dependencies

[top of page]

APPS.MTL_LOT_ONHAND_SUM_V references the following:

APPS: MTL_ITEM_LOCATIONS_KFV; MTL_LOT_NUMBERS; MTL_ONHAND_QUANTITIES_DETAIL; MTL_PARAMETERS; MTL_SECONDARY_INVENTORIES; MTL_SYSTEM_ITEMS_VL; WMS_LICENSE_PLATE_NUMBERS

APPS.MTL_LOT_ONHAND_SUM_V is not referenced by any database object