SELECT opnt.code, opnt.meaning from OKC_OPERATIONS_B OPNB, OKC_OPERATIONS_TL OPNT WHERE OPNB.CODE = OPNT.CODE and OPNT.LANGUAGE = USERENV('LANG') and OPNT.code in ('RENEWAL', 'REN_CON', 'TRANSFER')
View Text - HTML Formatted
SELECT OPNT.CODE , OPNT.MEANING FROM OKC_OPERATIONS_B OPNB , OKC_OPERATIONS_TL OPNT WHERE OPNB.CODE = OPNT.CODE AND OPNT.LANGUAGE = USERENV('LANG') AND OPNT.CODE IN ('RENEWAL' , 'REN_CON' , 'TRANSFER')