SELECT A.MAP_CD, UI_MAP_TYPE_FLG
FROM F1_MAP A, F1_MAP_L B
WHERE UPPER(DESCR) LIKE UPPER('INSERT_UI_MAP_DESCRIPTION')
AND LANGUAGE_CD = 'INSERT_LANGUAGE_CD_MOSTLY_ENG'
AND A.MAP_CD = B.MAP_CD
uploaded by Nuno Rodrigues