DBA Data[Home] [Help]

VIEW: APPS.OKI_OPER_OLTP_V

Source

View Text - Preformatted

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')