SELECT id, transNo, customerId, pickOrderNo, locationId, volType, count, state, customerName, custAddress, operater, phone1, lineName,lineOrder FROM dbo.v_tmsPickRequestBulks