VIEW: APPS.WMS_LOADED_QUANTITIES_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)