VIEW: APPS.OKC_TERMS_VAR_VALUES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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