View: OKC_TERMS_LOCAL_VAR_V

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

View Text

SELECT VAR.ROWID ROW_ID
, VAR.VARIABLE_CODE VARIABLE_CODE
, VAR.VARIABLE_TYPE VARIABLE_TYPE
, VAR_DEF.VARIABLE_NAME VARIABLE_NAME
, VAR_DEF.DESCRIPTION DESCRIPTION
, VAR.EXTERNAL_YN EXTERNAL_YN
, VAR.ATTRIBUTE_VALUE_SET_ID ATTRIBUTE_VALUE_SET_ID
, VAR.VARIABLE_VALUE_ID VARIABLE_VALUE_ID
, VAR.VARIABLE_VALUE VARIABLE_VALUE
, VAR_DEF_B.VARIABLE_DATATYPE VARIABLE_DATATYPE
, VAR.OVERRIDE_GLOBAL_YN OVERRIDE_GLOBAL_YN
, KART.DOCUMENT_TYPE DOCUMENT_TYPE
, KART.DOCUMENT_ID DOCUMENT_ID
, OKC_TERMS_UTIL_PVT.GET_ARTICLE_NAME(KART.SAV_SAE_ID
, KART.ARTICLE_VERSION_ID) ARTICLE_NAME
, KART.SAV_SAE_ID SAV_SAE_ID
, KART.ARTICLE_VERSION_ID ARTICLE_VERSION_ID
, OKC_TERMS_UTIL_PVT.GET_SECTION_LABEL(KART.SCN_ID) SECTION_LABEL
, KART.SCN_ID SECTION_ID
, VAR.CAT_ID CAT_ID
, V.ARTICLE_TEXT ARTICLE_TEXT
, SUBSTR(V.ADDITIONAL_INSTRUCTIONS
, 1
, 1000) INSTRUCTION_TEXT
, VAR.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, VAR.CREATED_BY CREATED_BY
, VAR.CREATION_DATE CREATION_DATE
, VAR.LAST_UPDATED_BY LAST_UPDATED_BY
, VAR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, VAR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, 'N' SHOW_DETAILS_FLAG
, VAR_DEF_B.CLM_SOURCE CLM_SOURCE
, VAR_DEF_B.CLM_REF1 CLM_REF1
, VAR_DEF_B.CLM_REF2 CLM_REF2
, VAR_DEF_B.CLM_REF3 CLM_REF3
, VAR_DEF_B.CLM_REF4 CLM_REF4
, VAR_DEF_B.CLM_REF5 CLM_REF5
, VAR_DEF_B.MRV_FLAG MRV_FLAG
, VAR_DEF_B.MRV_TMPL_CODE
, NVL(DECODE (KART.ORIG_SYSTEM_REFERENCE_CODE
, 'COPY'
, OKC_K_ENTITY_LOCKS_GRP.ISENTITYLOCKEDBYOTHERDOC('CLAUSE'
, KART.ORIG_SYSTEM_REFERENCE_ID1
, KART.DOCUMENT_TYPE
, KART.DOCUMENT_ID)
, 'N')
, 'N')
FROM OKC_ARTICLE_VERSIONS V
, OKC_BUS_VARIABLES_B VAR_DEF_B
, OKC_BUS_VARIABLES_TL VAR_DEF
, OKC_K_ARTICLES_B KART
, OKC_K_ART_VARIABLES VAR
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 V.ARTICLE_VERSION_ID = KART.ARTICLE_VERSION_ID
AND NVL(KART.AMENDMENT_OPERATION_CODE
, '?') <> 'DELETED' AND VAR_DEF_B.VARIABLE_TYPE = 'U' AND VAR_DEF.LANGUAGE = USERENV('LANG')
AND VAR_DEF_B.VARIABLE_SOURCE = 'M'

Columns