From Clause
hsi.itemdata, hsi.keyxitem113, hsi.keytable113
Where Clause
hsi.itemdata.itemnum= ki.itemnum and hsi.keyxitem113.keywordnum= hsi.keytable113.keywordnum and substring(hsi.keytable113.keyvaluechar,1,1)= 'A’ and hsi.itemdata.itemtypenum = 101 and hsi.itemdata.status + 0 = 0