eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: OKE_TERMS_VL

Product:	OKE - Project Contracts
Description:	Multi-lingual view for contract terms and conditions.
Implementation/DBA Data:	APPS.OKE_TERMS_VL

View Text

SELECT B.TERM_CODE
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.TERM_TYPE_CODE
, T.TERM_NAME
, T.DESCRIPTION
, B.USER_DEFINED_FLAG
, B.VIEW_APPLICATION_ID
, B.LOOKUP_TYPE
FROM OKE_TERMS_B B
, OKE_TERMS_TL T
WHERE T.TERM_CODE = B.TERM_CODE
AND T.LANGUAGE = USERENV('LANG')

Columns

Name
TERM_CODE
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
TERM_TYPE_CODE
TERM_NAME
DESCRIPTION
USER_DEFINED_FLAG
VIEW_APPLICATION_ID
LOOKUP_TYPE