SELECT
PHT.PHONE_TYPE_CD,
PHTL.DESCR,
PHT.PHONE_FMT_ALG_CD
FROM
CI_PHONE_TYPE PHT,
CI_PHONE_TYPE_L PHTL
WHERE
PHT.PHONE_TYPE_CD = PHTL.PHONE_TYPE_CD
AND PHTL.LANGUAGE_CD = 'INSERT_LANGUAGE_CD_MOSTLY_ENG'
uploaded by Nuno Rodrigues