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

VIEW: APPS.MTL_ONHAND_DUMMY_V

Object Details
Object Name: MTL_ONHAND_DUMMY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.MTL_ONHAND_DUMMY_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
ORGANIZATION_ID NUMBER

Organization ID
ORGANIZATION_CODE VARCHAR2 (0)
Organization Code
SUBINVENTORY_CODE VARCHAR2 (0)
Subinventory Code
LOCATOR_ID NUMBER

Stock Locator ID
LOCATOR VARCHAR2 (0)
Stock Locator
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier
ITEM_DESCRIPTION VARCHAR2 (0)
Item Description
ITEM VARCHAR2 (0)
Item Name
REVISION VARCHAR2 (0)
Revision
UOM VARCHAR2 (0)
Unit Of Measure
ON_HAND NUMBER

Onhand Quantity of the item
UNPACKED NUMBER

Loose Quantity present in the Inventory
PACKED NUMBER

Quantity present in LPNs
COST_GROUP_ID NUMBER

Cost Group ID
LPN_ID NUMBER

LPN Identifier
LPN VARCHAR2 (0)
License Plate Number
PARENT_LPN_ID NUMBER

Parent LPN ID
LPN_CONTEXT NUMBER

LPN Context
LOT_NUMBER VARCHAR2 (0)
Lot Number
SERIAL_NUMBER VARCHAR2 (0)
Serial Number
UNIT_NUMBER VARCHAR2 (0)
Unit Number
PROJECT_ID NUMBER

Project Identifier
TASK_ID NUMBER

Task Identifier
PLANNING_ORGANIZATION_ID NUMBER

Planning organization identifier
PLANNING_TP_TYPE NUMBER

Planning Trading Partner Type. The values are based on MTL_TP_TYPES lookup
OWNING_ORGANIZATION_ID NUMBER

Owning organization identifier
OWNING_TP_TYPE NUMBER

Owning Trading Partner Type. The values are based on MTL_TP_TYPES lookup
SUBINVENTORY_STATUS_ID NUMBER

Subinventory Status
LOCATOR_STATUS_ID NUMBER

Locator Status
LOT_STATUS_ID NUMBER

Lot Status Identifier
SERIAL_STATUS_ID NUMBER

Serial Status Identifier
ITEM_LOT_CONTROL NUMBER

Item Lot Control
ITEM_SERIAL_CONTROL NUMBER

Item Serial Control
SECONDARY_ONHAND NUMBER

Onhand Quantity in Secondary UOM.
SECONDARY_UOM_CODE VARCHAR2 (0)
Secodnary UOM code.
GRADE_CODE VARCHAR2 (0)
Grade code.
SECONDARY_PACKED NUMBER

Packed quantity in Secondary UOM.
SECONDARY_UNPACKED NUMBER

Unpacked quantity in Secondary UOM.
Query Text

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


SELECT ORGANIZATION_ID
,      ORGANIZATION_CODE
,      SUBINVENTORY_CODE
,      LOCATOR_ID
,      LOCATOR
,      INVENTORY_ITEM_ID
,      ITEM_DESCRIPTION
,      ITEM
,      REVISION
,      UOM
,      ON_HAND
,      UNPACKED
,      PACKED
,      COST_GROUP_ID
,      LPN_ID
,      LPN
,      PARENT_LPN_ID
,      LPN_CONTEXT
,      LOT_NUMBER
,      SERIAL_NUMBER
,      UNIT_NUMBER
,      PROJECT_ID
,      TASK_ID
,      PLANNING_ORGANIZATION_ID
,      PLANNING_TP_TYPE
,      OWNING_ORGANIZATION_ID
,      OWNING_TP_TYPE
,      SUBINVENTORY_STATUS_ID
,      LOCATOR_STATUS_ID
,      LOT_STATUS_ID
,      SERIAL_STATUS_ID
,      ITEM_LOT_CONTROL
,      ITEM_SERIAL_CONTROL
,      SECONDARY_ONHAND
,      SECONDARY_UOM_CODE
,      GRADE_CODE
,      SECONDARY_PACKED
,      SECONDARY_UNPACKED
FROM APPS.MTL_ONHAND_DUMMY_V;

Dependencies

[top of page]

APPS.MTL_ONHAND_DUMMY_V references the following:

SchemaPUBLIC
SynonymDUAL

APPS.MTL_ONHAND_DUMMY_V is not referenced by any database object