MBRD_query

SELECT     mbrd.Assembly, mbrd.ParentAssyDescription, mbrd.ItemID, mbrd.ItemName, mbrd.IMA_LeadTimeCode, POI.POI_PurchOrderID, POI.POI_POLineNbr, 
                      POI.POI_StatusCode, mbrd.QtyPerAssy, POD.POD_RequiredDate, POD.POD_RequiredQty, Item.IMA_ItemID, Item.IMA_DefaultVendorID AS Vendor, 
                      Item.IMA_PurLeadTime AS LeadTime, Item.IMA_OnHandQty AS OnHandQty
FROM         MultilevelBOM_ReportData AS mbrd INNER JOIN
                      Item ON mbrd.ItemID = Item.IMA_ItemID LEFT OUTER JOIN
                      POI AS POI ON mbrd.ItemID = POI.POI_ItemID LEFT OUTER JOIN
                      POD AS POD ON POD.POD_PurchOrderID = POI.POI_PurchOrderID AND POD.POD_POLineNbr = POI.POI_POLineNbr
WHERE     (mbrd.Assembly = '010-10723-0001-SMTRevK')
ORDER BY mbrd.Assembly, mbrd.ItemID, POI.POI_PurchOrderID