A bit of calculations and joining the creditor masterfile to be able to filter on the active transporters (using CrDormantFlag field).
SELECT TrCrNumber AS CrNumber,
TrCrName AS CrName,
TrInsCompany AS InsuranceCompany,
TrInsPolicy AS PolicyNumber,
TrInsValue AS InsuranceValue,
TrGoodsExcluded AS GoodsExcluded,
TrCurrencyCode AS CurrencyCode,
TrCurrencyName AS Currency,
DATE_FORMAT(TrInsExpirydate,'%Y-%m-%d') AS Insurance_Expiry_Date,
DATEDIFF(TrInsExpirydate,CURDATE()) AS Days_Until_Expiry,
CASE WHEN TrInsExpirydate < CURDATE() THEN 'GIT Expired'
ELSE 'GIT Valid' END AS GIT_Status,
CASE WHEN c.CrDormantFlag = 'N' THEN "Active"
ELSE "Dormant" END AS DormantFlag
FROM vwa_transito t
LEFT JOIN vwa_crmaster c ON t.TrCrNumber = c.CrNumber