/* Formatted on 10/18/2019 3:57:20 PM (QP5 v5.256.13226.35538) */
  SELECT *
    FROM (  SELECT msi.SEGMENT1,
                   ohd.SUBINVENTORY_CODE,
                   STGS.PROCESS_FLAG,
                   STGS.PROCESS_STATE,
                   QUANTITY,
                   SUM (TRANSACTION_QUANTITY) SQTY
              FROM apps.mtl_onhand_quantities_detail OHD,
                   apps.MTL_SYSTEM_ITEMS MSI,
                   xxwmsg.XXWG_WM_WSH_SHIP_CONFIRM_STG STGS
             WHERE     1 = 1
                   AND OHD.inventory_item_id = MSI.inventory_item_id
                   AND ohd.organization_id = 1561
                   AND OHD.organization_id = MSI.organization_id
                   AND msi.SEGMENT1 = STGS.ITEM_NUMBER
                   AND SUBINVENTORY_CODE = 'STAGING'
          GROUP BY msi.SEGMENT1,
                   ohd.SUBINVENTORY_CODE,
                   STGS.PROCESS_FLAG,
                   STGS.PROCESS_STATE,
                   QUANTITY)
   WHERE quantity = sqty
ORDER BY 1;