TRANSACTION HISTORICAL SUMMARY REPORT ON HAND QTY

                    TRANSACTION HISTORICAL SUMMARY REPORT ON HAND QTY


SELECT   SUM (mmt.primary_quantity)
--  INTO   i
  FROM   apps.mtl_transaction_types mtt,
         apps.MTL_MATERIAL_TRANSACTIONS mmt,
         apps.mtl_system_items msi
 WHERE       mtt.TRANSACTION_TYPE_ID = mmt.TRANSACTION_TYPE_ID
         AND mmt.organization_id = msi.organization_id
         AND mmt.inventory_item_id = msi.inventory_item_id
         AND (mmt.organization_id = 109)
         AND msi.segment1 = 'PLPCBWLAPI'
         AND TRUNC (MMT.transaction_date) <= TO_DATE (:P_FROM_DATE);