How can I get serial number from item fulfillment using suiteql?

The S/N is going to be in the Inventory Number table and assigned to the IF in the Inventory Assignment table.