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, DBMS_LOB.SUBSTR(V.ARTICLE_TEXT,1000) 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 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
, DBMS_LOB.SUBSTR(V.ARTICLE_TEXT
, 1000) 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
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'