[Home] [Help] [Dependency Information]

VIEW: APPS.MTL_ONHAND_LOT_V

Object Details

Object Name:	MTL_ONHAND_LOT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	INV.MTL_ONHAND_LOT_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
,      LOCATOR_ID
,      LOT
,      ITEM_DESCRIPTION
,      PRIMARY_UOM_CODE
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      EXPIRATION_DATE
,      ITEM_LOT_CONTROL
,      ITEM_LOCATOR_CONTROL
,      ITEM_SERIAL_CONTROL
,      GRADE_CODE
,      SECONDARY_UOM_CODE
,      SECONDARY_TOTAL
FROM APPS.MTL_ONHAND_LOT_V;

Dependencies

[top of page]

APPS

HR_GENERAL - show dependent code

HR_ORGANIZATION_UNITS

HR_SECURITY - show dependent code

MTL_LOT_NUMBERS

MTL_ONHAND_QUANTITIES_DETAIL

MTL_PARAMETERS

MTL_SYSTEM_ITEMS_KFV

APPS

CSP_SCH_INT_PVT - show dependent code