Did NetSuite change table names on me in the newset relese this sql is returning zero results

SELECT DISTINCT
    AssemblyItem.ID AS AssemblyItemID,
    AssemblyItem.itemid as name,
    (SELECT islotitem FROM Item WHERE Item.id = AssemblyItemMember.Item )AS  Memberlot,
    AssemblyItem.islotitem AS parentlot,
    inventoryItemLocations.item,
    inventoryItemLocations.quantitybackordered,
    inventoryItemLocations.quantityonhand,
    inventoryItemLocations.location
    FROM
        Item AS AssemblyItem
        INNER JOIN AssemblyItemMember ON
         (AssemblyItemMember.ParentItem = AssemblyItem.ID)
        INNER JOIN inventoryItemLocations ON AssemblyItem.ID = inventoryItemLocations.item  AND inventoryItemLocations.location = ${loadid}
        WHERE   AssemblyItem.itemtype = 'Assembly'  AND inventoryItemLocations.quantitybackordered > 0`