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

VIEW: APPS.WMS_LOADED_QUANTITIES_V

Object Details
Object Name: WMS_LOADED_QUANTITIES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWMS.WMS_LOADED_QUANTITIES_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
Yes Organization identifier
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
REVISION VARCHAR2 (3)
Inventory item revision code
LOT_NUMBER VARCHAR2 (80)
Lot Number
COST_GROUP_ID NUMBER

Cost Group Identifier
CONTAINERIZED_FLAG NUMBER

Container Identifier
SUBINVENTORY_CODE VARCHAR2 (10)
Subinventory Code
LOCATOR_ID NUMBER

Locator
QUANTITY NUMBER

Loaded Quantity
QTY_TYPE CHAR (6)
Status of Quantity
TRANSACTION_TEMP_ID NUMBER

Transaction line identifier
CONTENT_LPN_ID NUMBER

Content LPN Id
LPN_ID NUMBER

LPN Id
TRANSFER_LPN_ID NUMBER

Transfer LPN Id
SERIAL_TRANSACTION_TEMP_ID NUMBER

Transaction line identifier used to join serial table for the serial controlled item
SECONDARY_QUANTITY NUMBER

Dual UOM transaction Quantity
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
,      QTY_TYPE
,      TRANSACTION_TEMP_ID
,      CONTENT_LPN_ID
,      LPN_ID
,      TRANSFER_LPN_ID
,      SERIAL_TRANSACTION_TEMP_ID
,      SECONDARY_QUANTITY
FROM APPS.WMS_LOADED_QUANTITIES_V;

Dependencies

[top of page]

APPS.WMS_LOADED_QUANTITIES_V references the following:

SchemaAPPS
SynonymMTL_MATERIAL_TRANSACTIONS_TEMP
SynonymMTL_TRANSACTION_LOTS_TEMP
SynonymWMS_DISPATCHED_TASKS
APPS.WMS_LOADED_QUANTITIES_V is referenced by following:

SchemaAPPS
Package BodyINV_CYC_LOVS - show dependent code
Package BodyINV_MINMAX_PVT - show dependent code
Package BodyMTL_INV_UTIL_GRP - show dependent code