Retrieve/Pull up items that appear in Order Items page

This sample SQL query demonstrates how you can replicate how the items are pulled up in the Order Items Page (Transactions > Inventory > Order Items)
SELECT *
FROM item_location_map
WHERE ((reorder_point =< pref_stock_level) AND(on_hand_count < reorder_point))
OR ((reorder_point =< pref_stock_level) AND (available_count IS null))