View: WMS_LOADED_QUANTITIES_V

Product:	WMS - Warehouse Management
Description:	This table shows the information for the quantity loaded in the lpn
Implementation/DBA Data:	APPS.WMS_LOADED_QUANTITIES_V

View Text

SELECT T.ORGANIZATION_ID
, T.INVENTORY_ITEM_ID
, T.REVISION
, L.LOT_NUMBER
, T.COST_GROUP_ID
, DECODE (NVL (T.LPN_ID
, NVL (T.CONTENT_LPN_ID
, -1))
, -1
, 2
, 1) CONTAINERIZED_FLAG
, T.SUBINVENTORY_CODE
, T.LOCATOR_ID
, (NVL (L.PRIMARY_QUANTITY
, T.PRIMARY_QUANTITY)) QUANTITY
, 'LOADED' QTYTYPE
, T.TRANSACTION_TEMP_ID
, T.CONTENT_LPN_ID
, T.LPN_ID
, T.TRANSFER_LPN_ID
, L.SERIAL_TRANSACTION_TEMP_ID
, (NVL (L.SECONDARY_QUANTITY
, T.SECONDARY_TRANSACTION_QUANTITY)) SECONDARY_QUANTITY
FROM WMS_DISPATCHED_TASKS W
, MTL_MATERIAL_TRANSACTIONS_TEMP T
, MTL_TRANSACTION_LOTS_TEMP L
WHERE W.STATUS = 4
AND W.TASK_TYPE <> 2
AND W.TRANSACTION_TEMP_ID = T.TRANSACTION_TEMP_ID
AND T.TRANSACTION_TEMP_ID = L.TRANSACTION_TEMP_ID (+)

Columns