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

VIEW: APPS.WMS_ONHAND_AND_LOADED_QTY_V

Object Details
Object Name: WMS_ONHAND_AND_LOADED_QTY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWMS.WMS_ONHAND_AND_LOADED_QTY_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
INVENTORY_ITEM_ID NUMBER

Inventory Item Id
REVISION VARCHAR2 (3)
Revision
LOT_NUMBER VARCHAR2 (80)
Lot Number
COST_GROUP_ID NUMBER

Cost Group Id
CONTAINERIZED_FLAG NUMBER

Containerized Flag - 1 means packed items and 2 means loose items
SUBINVENTORY_CODE VARCHAR2 (10)
Subinventory Code
LOCATOR_ID NUMBER

Locator Id
QUANTITY NUMBER

Quantity
SECONDARY_TRANSACTION_QUANTITY NUMBER

SECONDARY TRANSACTION QUANTITY
QTY_TYPE CHAR (6)
Indicates the type of recordIt wil be 'LOADED' for all records that have been loaded onto an equipment and 'ONHAND' for the rest
Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      REVISION
,      LOT_NUMBER
,      COST_GROUP_ID
,      CONTAINERIZED_FLAG
,      SUBINVENTORY_CODE
,      LOCATOR_ID
,      QUANTITY
,      SECONDARY_TRANSACTION_QUANTITY
,      QTY_TYPE
FROM APPS.WMS_ONHAND_AND_LOADED_QTY_V;

Dependencies

[top of page]

APPS.WMS_ONHAND_AND_LOADED_QTY_V references the following:

SchemaAPPS
SynonymMTL_MATERIAL_TRANSACTIONS_TEMP
SynonymMTL_ONHAND_QUANTITIES_DETAIL
SynonymMTL_TRANSACTION_LOTS_TEMP
SynonymWMS_DISPATCHED_TASKS
APPS.WMS_ONHAND_AND_LOADED_QTY_V is referenced by following:

SchemaAPPS
Package BodyINV_ITEM_INQ - show dependent code