DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.MTL_ONHAND_NET

Object Details
Object Name: MTL_ONHAND_NET
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.MTL_ONHAND_NET
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
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
DATE_RECEIVED DATE

Date received
PRIMARY_TRANSACTION_QUANTITY NUMBER
Yes Transaction quantity in the primary unit of measure of the item
SECONDARY_TRANSACTION_QUANTITY NUMBER

Secondary quantity
SUBINVENTORY_CODE VARCHAR2 (10) Yes Subinventory code
REVISION VARCHAR2 (3)
Item revision code
LOCATOR_ID NUMBER

Locator identifier
LOT_NUMBER VARCHAR2 (80)
Lot number
LPN_ID NUMBER

LPN Identifier
PLANNING_TP_TYPE NUMBER
Yes Planning Trading Partner Type. The values are based on MTL_TP_TYPES lookup.
PLANNING_ORGANIZATION_ID NUMBER
Yes Planning organization identifier
Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      DATE_RECEIVED
,      PRIMARY_TRANSACTION_QUANTITY
,      SECONDARY_TRANSACTION_QUANTITY
,      SUBINVENTORY_CODE
,      REVISION
,      LOCATOR_ID
,      LOT_NUMBER
,      LPN_ID
,      PLANNING_TP_TYPE
,      PLANNING_ORGANIZATION_ID
FROM APPS.MTL_ONHAND_NET;

Dependencies

[top of page]

APPS.MTL_ONHAND_NET references the following:

SchemaAPPS
SynonymMTL_ITEM_LOCATIONS
SynonymMTL_LOT_NUMBERS
SynonymMTL_MATERIAL_STATUSES
SynonymMTL_ONHAND_QUANTITIES_DETAIL
SynonymMTL_PARAMETERS
SynonymMTL_SECONDARY_INVENTORIES
APPS.MTL_ONHAND_NET is referenced by following:

SchemaAPPS
Package BodyINV_CONSIGNED_VALIDATIONS - show dependent code