[Home] [Help] [Dependency Information]

VIEW: APPS.MTL_ONHAND_SUB_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Query Text

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

SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      PADDED_CONCATENATED_SEGMENTS
,      REVISION
,      TOTAL_QOH
,      SUBINVENTORY_CODE
,      ITEM_DESCRIPTION
,      PRIMARY_UOM_CODE
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      NET
,      RSV
,      ATP
,      LOCATOR_TYPE
,      ITEM_REV_CONTROL
,      ITEM_LOCATOR_CONTROL
,      ITEM_LOT_CONTROL
,      ITEM_SERIAL_CONTROL
FROM APPS.MTL_ONHAND_SUB_V;

Dependencies

[top of page]

APPS

HR_GENERAL - show dependent code

HR_ORGANIZATION_UNITS

HR_SECURITY - show dependent code

MTL_ONHAND_QUANTITIES_DETAIL

MTL_PARAMETERS

MTL_SECONDARY_INVENTORIES

MTL_SYSTEM_ITEMS_KFV

APPS

CSP_AVAILABLE_PARTS_IN_LOOP_V

CSP_EXCESS_PARTS_PVT - show dependent code

GME_MOBILE_LOVS - show dependent code

POR_AUTOSOURCE_UTIL_PKG - show dependent code

POR_SRC_SUBINV_LOV_V