SELECT ss.DotCode, ss.stockingStatus FROM tbl_PRD_SKUs s INNER JOIN tbl_PRD_Packaging pack ON s.skuId = pack.linkId AND pack.linkType = 'SKU' INNER JOIN tbl_DOT_StockingStatus ss ON pack.scc14 = ss.gtin WHERE s.FSL_TableCode = AND s.OwnerID = AND s.skuId =