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: OKC_TERMS_VAR_VALUES_V

Product:	OKC - Contracts Core
Description:
Implementation/DBA Data:	APPS.OKC_TERMS_VAR_VALUES_V

View Text

SELECT VAR.ROWID
, KART.DOCUMENT_ID
, KART.DOCUMENT_TYPE
, VAR.CAT_ID
, VAR.VARIABLE_CODE
, VAR.VARIABLE_TYPE
, VAR_DEF.VARIABLE_NAME
, VAR_DEF.DESCRIPTION
, VAR.EXTERNAL_YN
, VAR.ATTRIBUTE_VALUE_SET_ID
, VAR.VARIABLE_VALUE_ID
, VAR.VARIABLE_VALUE
, VAR.OBJECT_VERSION_NUMBER
, VAR.CREATED_BY
, VAR.CREATION_DATE
, VAR.LAST_UPDATED_BY
, VAR.LAST_UPDATE_DATE
, VAR.LAST_UPDATE_LOGIN
, VAR_DEF_B.VARIABLE_DATATYPE
, VAR_DEF_B.VARIABLE_SOURCE
FROM OKC_K_ART_VARIABLES VAR
, OKC_K_ARTICLES_B KART
, OKC_BUS_VARIABLES_TL VAR_DEF
, OKC_BUS_VARIABLES_B VAR_DEF_B
WHERE KART.ID = VAR.CAT_ID
AND VAR_DEF.VARIABLE_CODE = VAR.VARIABLE_CODE
AND VAR_DEF.VARIABLE_CODE = VAR_DEF_B.VARIABLE_CODE
AND VAR_DEF.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
DOCUMENT_ID
DOCUMENT_TYPE
CAT_ID
VARIABLE_CODE
VARIABLE_TYPE
VARIABLE_NAME
VARIABLE_DESCRIPTION
EXTERNAL_YN
ATTRIBUTE_VALUE_SET_ID
VARIABLE_VALUE_ID
VARIABLE_VALUE
OBJECT_VERSION_NUMBER
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
VARIABLE_DATATYPE
VARIABLE_SOURCE