Oracle Inventory Move Order Personalization where On Hand Qty = 0

hi all

i have created some personalisations on the move order form, so that my customer cannot approve a move order where the Order Qty is greater than On Hand Qty, and all this is working fine

i am having an issue where the On Hand Qty = 0, as the inventory item does not appear in the MTL_ONHAND_QUANTITIES table

i have written the below query which works well in SQL, returning the item 1001600 with 0 on hand qty

Select msi.segment1, sum(nvl(moq.transaction_quantity,0))

from mtl_onhand_quantities moq, mtl_system_items msi

where

moq.inventory_Item_id (+) = msi.inventory_item_id