Product: | OKC - Contracts Core |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKC_TERMS_LOCAL_VAR_V |
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
, DBMS_LOB.SUBSTR(V.ARTICLE_TEXT
, 2000) ARTICLE_TEXT
, SUBSTR(V.ADDITIONAL_INSTRUCTIONS
, 1
, 2000) 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
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')