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

VIEW: APPS.MTL_ONHAND_NEW_LPN_MWB_V

Object Details
Object Name: MTL_ONHAND_NEW_LPN_MWB_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.MTL_ONHAND_NEW_LPN_MWB_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
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Organization identifier
ORGANIZATION_CODE VARCHAR2 (3)
Organization code
SUBINVENTORY_CODE VARCHAR2 (10)
Current subinventory code
LOCATOR_ID NUMBER

Current locator, if item is under locator control
LOCATOR VARCHAR2 (1)
The concatenation of segments enabled for this flexfield
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier
ITEM_DESCRIPTION VARCHAR2 (240)
Item Description
ITEM VARCHAR2 (40)
Item name
REVISION VARCHAR2 (3)
Revision of the item, if it is under revision control.
UOM VARCHAR2 (3)
Primary UOM code of the item
ON_HAND NUMBER

Transaction quantity in the primary unit of measure of the item
UNPACKED NUMBER

Unpacked quantity
PACKED NUMBER

Packed quantity
COST_GROUP_ID NUMBER

Cost group Identifier of the container content item
LPN_ID NUMBER

LPN identifier
LPN VARCHAR2 (30)
License Plate Number
LPN_CONTEXT NUMBER

LPN Context
LOT_NUMBER VARCHAR2 (80)
Lot number if item under lot control
EXPIRATION_DATE DATE

Lot expiration date
SERIAL_NUMBER VARCHAR2 (30)
Serial number
UNIT_NUMBER VARCHAR2 (30)
Model unit number
PROJECT_ID NUMBER (15)
Project Identifier
TASK_ID NUMBER (15)
Task Identifier
LOCATOR_STATUS_ID NUMBER

Status identifier - Used by WMS only
SERIAL_STATUS_ID NUMBER

Status identifier - Used by WMS only
OUTERMOST_LPN_ID NUMBER

Outermost LPN Identifier
PARENT_LPN_ID NUMBER

LPN ID of the container in which the current lpn is in, If the LPN being created already has a parent
PLANNING_TP_TYPE NUMBER

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

Planning Organization identifier
OWNING_TP_TYPE NUMBER

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

Owning organization 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 (3)
Secodnary UOM code.
GRADE_CODE VARCHAR2 (0)
Grade code.
SECONDARY_UNPACKED NUMBER

Unpacked quantity in Secondary UOM.
SECONDARY_PACKED NUMBER

Packed quantity in Secondary UOM.
ONHAND_STATUS_ID NUMBER

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
,      LPN_CONTEXT
,      LOT_NUMBER
,      EXPIRATION_DATE
,      SERIAL_NUMBER
,      UNIT_NUMBER
,      PROJECT_ID
,      TASK_ID
,      LOCATOR_STATUS_ID
,      SERIAL_STATUS_ID
,      OUTERMOST_LPN_ID
,      PARENT_LPN_ID
,      PLANNING_TP_TYPE
,      PLANNING_ORGANIZATION_ID
,      OWNING_TP_TYPE
,      OWNING_ORGANIZATION_ID
,      ITEM_LOT_CONTROL
,      ITEM_SERIAL_CONTROL
,      SECONDARY_ONHAND
,      SECONDARY_UOM_CODE
,      GRADE_CODE
,      SECONDARY_UNPACKED
,      SECONDARY_PACKED
,      ONHAND_STATUS_ID
FROM APPS.MTL_ONHAND_NEW_LPN_MWB_V;

Dependencies

[top of page]

APPS.MTL_ONHAND_NEW_LPN_MWB_V references the following:

SchemaAPPS
ViewMTL_ITEM_LOCATIONS_KFV
SynonymMTL_LOT_NUMBERS
SynonymMTL_ONHAND_QUANTITIES_DETAIL
SynonymMTL_PARAMETERS
SynonymMTL_SERIAL_NUMBERS
ViewMTL_SYSTEM_ITEMS_VL
SynonymWMS_LICENSE_PLATE_NUMBERS

APPS.MTL_ONHAND_NEW_LPN_MWB_V is not referenced by any database object