SELECT scr.SCR_CD as SCR_CD, scr.SCR_TYPE_FLG as SCR_TYPE_FLG, scrl.DESCR254 as DESCR254
FROM CI_SCR scr, CI_SCR_L scrl
WHERE
LANGUAGE_CD = 'INSERT_LANGUAGE_CD_MOSTLY_ENG'
AND scr.SCR_CD = scrl.SCR_CD
AND UPPER(scr.SCR_CD) LIKE UPPER('INSERT_SCRIPT_CODE')
uploaded by Nuno Rodrigues