INV现有量视图

mtl_onhand_locator_v
这是view记录了库存的现有量.楼主研究一下这个view的创建语句,就可以知道现有量是如何计算出来的了.
其中total_qoh就是现有量,它的创建语句如下:

SELECT A.ORGANIZATION_ID ,
       A.INVENTORY_ITEM_ID ,
       B.PADDED_CONCATENATED_SEGMENTS ,
       A.REVISION ,
       SUM(A.PRIMARY_TRANSACTION_QUANTITY) TOTAL_QOH ,
       A.SUBINVENTORY_CODE ,
       A.LOCATOR_ID ,
       B.DESCRIPTION ITEM_DESCRIPTION ,
       B.PRIMARY_UOM_CODE ,
       C.ORGANIZATION_CODE ,
       E.NAME ORGANIZATION_NAME ,
       D.AVAILABILITY_TYPE NET ,
       D.RESERVABLE_TYPE RSV ,
       D.INVENTORY_ATP_CODE ATP ,
       D.LOCATOR_TYPE ,
       B.LOT_CONTROL_CODE ITEM_LOT_CONTROL ,
       B.LOCATION_CONTROL_CODE ITEM_LOCATOR_CONTROL ,
       B.SERIAL_NUMBER_CONTROL_CODE ITEM_SERIAL_CONTROL
FROM MTL_ONHAND_QUANTITIES_DETAIL A,
      MTL_SYSTEM_ITEMS_KFV B,
      MTL_PARAMETERS C,
      MTL_SECONDARY_INVENTORIES D,
      HR_ORGANIZATION_UNITS E
WHERE A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
  AND A.SUBINVENTORY_CODE = D.SECONDARY_INVENTORY_NAME
  AND A.ORGANIZATION_ID = B.ORGANIZATION_ID
  AND A.ORGANIZATION_ID = C.ORGANIZATION_ID
  AND A.ORGANIZATION_ID = D.ORGANIZATION_ID
  AND A.ORGANIZATION_ID = E.ORGANIZATION_ID
  AND A.IS_CONSIGNED = 2
GROUP BY A.ORGANIZATION_ID,
         A.INVENTORY_ITEM_ID,
         A.REVISION,
         A.SUBINVENTORY_CODE,
         A.LOCATOR_ID,
         B.PADDED_CONCATENATED_SEGMENTS,
         B.DESCRIPTION,
         B.PRIMARY_UOM_CODE,
         C.ORGANIZATION_CODE,
         E.NAME,
         D.AVAILABILITY_TYPE,
         D.RESERVABLE_TYPE,
         D.INVENTORY_ATP_CODE,
         D.LOCATOR_TYPE,
         B.LOT_CONTROL_CODE,
         B.LOCATION_CONTROL_CODE,
         B.SERIAL_NUMBER_CONTROL_CODE