Victoria Yudin has a new SQL View up to show all of the Sales Order Processing transaction lines, posted and unposted.
SQL View with All Dynamics GP SOP Lines
SQL & DataSales, Purchasing & Inventory
Archived post from 2009. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.