SELECT AT.AM_ACTIVITY_TYPE_CD, BOS.DESCR AS STATDESCR FROM CI_AM_ACTIVITY_TYPE AT, F1_BUS_OBJ_STATUS_L BOS WHERE BOS.BUS_OBJ_CD = AT.BUS_OBJ_CD AND BOS.LANGUAGE_CD = :INSERT_LANGUAGE_HERE AND BOS.BO_STATUS_CD = AT.BO_STATUS_CDuploaded by Nuno Rodrigues