VIEW: APPS.OKC_TERMS_LOCAL_VAR_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'