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

Object Details

Object Name:	WMS_LOADED_QUANTITIES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WMS.WMS_LOADED_QUANTITIES_V
Subobject Name:
Status:	VALID

View Type

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

This table shows the information for the quantity loaded in the lpn

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
REVISION	VARCHAR2	(3)		Inventory item revision code
LOT_NUMBER	VARCHAR2	(80)		Lot Number
COST_GROUP_ID	NUMBER			Cost Group Identifier
CONTAINERIZED_FLAG	NUMBER			Container Identifier
SUBINVENTORY_CODE	VARCHAR2	(10)		Subinventory Code
LOCATOR_ID	NUMBER			Locator
QUANTITY	NUMBER			Loaded Quantity
QTY_TYPE	CHAR	(6)		Status of Quantity
TRANSACTION_TEMP_ID	NUMBER			Transaction line identifier
CONTENT_LPN_ID	NUMBER			Content LPN Id
LPN_ID	NUMBER			LPN Id
TRANSFER_LPN_ID	NUMBER			Transfer LPN Id
SERIAL_TRANSACTION_TEMP_ID	NUMBER			Transaction line identifier used to join serial table for the serial controlled item
SECONDARY_QUANTITY	NUMBER			Dual UOM transaction Quantity

Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      REVISION
,      LOT_NUMBER
,      COST_GROUP_ID
,      CONTAINERIZED_FLAG
,      SUBINVENTORY_CODE
,      LOCATOR_ID
,      QUANTITY
,      QTY_TYPE
,      TRANSACTION_TEMP_ID
,      CONTENT_LPN_ID
,      LPN_ID
,      TRANSFER_LPN_ID
,      SERIAL_TRANSACTION_TEMP_ID
,      SECONDARY_QUANTITY
FROM APPS.WMS_LOADED_QUANTITIES_V;

Dependencies

[top of page]

APPS.WMS_LOADED_QUANTITIES_V references the following:

APPS: MTL_MATERIAL_TRANSACTIONS_TEMP; MTL_TRANSACTION_LOTS_TEMP; WMS_DISPATCHED_TASKS

APPS.WMS_LOADED_QUANTITIES_V is referenced by following:

APPS: INV_CYC_LOVS - show dependent code; INV_ITEM_INQ - show dependent code; INV_MINMAX_PVT - show dependent code; INV_MWB_QUERY_MANAGER - show dependent code; INV_UI_ITEM_ATT_LOVS - show dependent code; MTL_INV_UTIL_GRP - show dependent code; WMS_OPP_CYC_COUNT - show dependent code; WMS_PUTAWAY_UTILS - show dependent code