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_ONHAND_SYNC_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CATEGORY	VARCHAR2	(163)		Item Category.
WAREHOUSE_ID	NUMBER			Warehouse identifier.
WAREHOUSE	VARCHAR2	(3)		Warehouse name information.
ITEM_ID	NUMBER			Item identifier.
ITEM	VARCHAR2	(40)		Item name information.
ITEM_DESCRIPTION	VARCHAR2	(240)		Item description.
REVISION	VARCHAR2	(3)		Item revision code.
SUBINVENTORY	VARCHAR2	(10)		Subinventory code.
LOCATOR	CHAR	(1)		Locator information.
LOT	VARCHAR2	(80)		Lot information.
LPN	VARCHAR2	(30)		LPN information.
PARENT_LPN	VARCHAR2	(30)		Parent LPN information.
SERIAL	VARCHAR2	(30)		Serial information.
CONTAINERIZED_FLAG	VARCHAR2	(3)		Containerized flag.
PRIMARY_QUANTITY	NUMBER			Primary Quantity.
PRIMARY_UOM	VARCHAR2	(25)	Yes	Primary Unit of measure.
SECONDARY_QUANTITY	NUMBER			Secondary quantity.
SECONDARY_UOM	VARCHAR2	(25)		Secondary unit of measure.
SNAPSHOT_DATE	DATE			Snapshot date.
ONHAND_STATUS	VARCHAR2	(80)		Specify onhand status.

Query Text

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


SELECT CATEGORY
,      WAREHOUSE_ID
,      WAREHOUSE
,      ITEM_ID
,      ITEM
,      ITEM_DESCRIPTION
,      REVISION
,      SUBINVENTORY
,      LOCATOR
,      LOT
,      LPN
,      PARENT_LPN
,      SERIAL
,      CONTAINERIZED_FLAG
,      PRIMARY_QUANTITY
,      PRIMARY_UOM
,      SECONDARY_QUANTITY
,      SECONDARY_UOM
,      SNAPSHOT_DATE
,      ONHAND_STATUS
FROM APPS.MTL_ONHAND_SYNC_V;

Dependencies

[top of page]

APPS.MTL_ONHAND_SYNC_V references the following:

APPS: INV_MATERIAL_STATUS_GRP - show dependent code; MTL_CATEGORIES_KFV; MTL_ITEM_CATEGORIES; MTL_ITEM_LOCATIONS_KFV; MTL_MATERIAL_STATUSES; MTL_ONHAND_QUANTITIES_DETAIL; MTL_PARAMETERS; MTL_SERIAL_NUMBERS; MTL_SYSTEM_ITEMS_B; MTL_SYSTEM_ITEMS_B_KFV; MTL_UNITS_OF_MEASURE; WMS_LICENSE_PLATE_NUMBERS

APPS.MTL_ONHAND_SYNC_V is not referenced by any database object