Inventory Item non Transactable query in oracle apps r12.1.3

 Inventory Item non Transactable query in oracle apps r12.1.3

SELECT   msib.segment1 item,
         msib.description,
         moq.subinventory_code,
         sum(moq.transaction_quantity) OHND_QTY,
         mp.organization_code,
         msib.primary_uom_code
FROM     MTL_SYSTEM_ITEMS_B MSIB,
         MTL_PARAMETERS MP,
         MTL_ONHAND_QUANTITIES MOQ
WHERE    1=1 --msib.segment1 = '70710FTOPAZ52'
AND      msib.inventory_item_id = moq.inventory_item_id
AND      msib.organization_id   = moq.organization_id
AND      mp.organization_code = :p_organization_code
AND                 msib.organization_id = mp.organization_id
AND                 msib.MTL_TRANSACTIONS_ENABLED_FLAG = 'N'
GROUP BY  msib.segment1,
                      msib.description,
                     mp.organization_code,
                    moq.subinventory_code,
                     msib.primary_uom_code
ORDER BY msib.segment1, mp.organization_code;