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


VIEW: APPS.MTL_RCV_SERIAL_OH_V

Object Details
Object Name: MTL_RCV_SERIAL_OH_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.MTL_RCV_SERIAL_OH_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)
Subinventory code
LOCATOR_ID NUMBER

Locator identifier
LOCATOR VARCHAR2 (1)
Locator
INVENTORY_ITEM_ID NUMBER

Inventory item identifier
ITEM_DESCRIPTION VARCHAR2 (240)
Inventory item description
ITEM VARCHAR2 (40)
Item description?
REVISION VARCHAR2 (3)
Iventory item revision code
UOM VARCHAR2 (3)
Primary unit of measure of item
ON_HAND NUMBER

On-hand quantity for the item
UNPACKED NUMBER

Unpacked quantity for the item
PACKED NUMBER

Packed quantity for the item
COST_GROUP_ID NUMBER

Cost group identifier
LPN_ID NUMBER

License Plate Number identifier
LPN VARCHAR2 (0)
License Plate Number
LOT_NUMBER VARCHAR2 (30)
Lot number
EXPIRATION_DATE DATE

Expiration Date for the Lot
SERIAL_NUMBER VARCHAR2 (30)
Serial number
UNIT_NUMBER VARCHAR2 (0)
Unit number
PROJECT_ID NUMBER (15)
Project identifier
TASK_ID NUMBER (15)
Task identifier
LOCATOR_STATUS_ID NUMBER

Locator status identifier
SERIAL_STATUS_ID NUMBER

Serial status identifier
CONTAINERIZED_FLAG NUMBER

Containerized flag
PLANNING_TP_TYPE NUMBER

??
PLANNING_ORGANIZATION_ID NUMBER

??
OWNING_TP_TYPE NUMBER

??
OWNING_ORGANIZATION_ID NUMBER

??
ITEM_LOT_CONTROL NUMBER

Lot control code
ITEM_SERIAL_CONTROL NUMBER

Serial number control code
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.
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
,      LOT_NUMBER
,      EXPIRATION_DATE
,      SERIAL_NUMBER
,      UNIT_NUMBER
,      PROJECT_ID
,      TASK_ID
,      LOCATOR_STATUS_ID
,      SERIAL_STATUS_ID
,      CONTAINERIZED_FLAG
,      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
FROM APPS.MTL_RCV_SERIAL_OH_V;

Dependencies

[top of page]

APPS.MTL_RCV_SERIAL_OH_V references the following:

SchemaAPPS
ViewMTL_ITEM_LOCATIONS_KFV
SynonymMTL_LOT_NUMBERS
SynonymMTL_PARAMETERS
ViewMTL_SYSTEM_ITEMS_VL
SynonymRCV_SERIALS_SUPPLY
SynonymRCV_SUPPLY

APPS.MTL_RCV_SERIAL_OH_V is not referenced by any database object