VIEW: APPS.OKC_TERMS_GLOBAL_VAR_V

Source

View Text - Preformatted

SELECT S.VARIABLE_NAME VARIABLE_NAME, S.DESCRIPTION DESCRIPTION, S.VARIABLE_CODE VARIABLE_CODE, S.VARIABLE_TYPE, V.ATTRIBUTE_VALUE_SET_ID ATTRIBUTE_VALUE_SET_ID, S.VARIABLE_DATATYPE VARIABLE_DATATYPE, S.EXTERNAL_YN EXTERNAL_YN, K.DOCUMENT_TYPE DOCUMENT_TYPE, K.DOCUMENT_ID DOCUMENT_ID, NULL GLOBAL_VALUE, NULL GLOBAL_VALUE_ID FROM OKC_BUS_VARIABLES_VL S,OKC_K_ARTICLES_B K,OKC_K_ART_VARIABLES V WHERE K.ID = V.CAT_ID AND V.VARIABLE_CODE = S.VARIABLE_CODE AND S.VARIABLE_TYPE = 'U' AND S.VARIABLE_SOURCE = 'M' AND NVL(K.AMENDMENT_OPERATION_CODE,'?') <> 'DELETED' GROUP BY S.VARIABLE_NAME, S.DESCRIPTION, S.VARIABLE_CODE ,S .VARIABLE_TYPE, V.ATTRIBUTE_VALUE_SET_ID, S.VARIABLE_DATATYPE, S.EXTERNAL_YN, K.DOCUMENT_TYPE, K.DOCUMENT_ID

View Text - HTML Formatted

SELECT S.VARIABLE_NAME VARIABLE_NAME
, S.DESCRIPTION DESCRIPTION
, S.VARIABLE_CODE VARIABLE_CODE
, S.VARIABLE_TYPE
, V.ATTRIBUTE_VALUE_SET_ID ATTRIBUTE_VALUE_SET_ID
, S.VARIABLE_DATATYPE VARIABLE_DATATYPE
, S.EXTERNAL_YN EXTERNAL_YN
, K.DOCUMENT_TYPE DOCUMENT_TYPE
, K.DOCUMENT_ID DOCUMENT_ID
, NULL GLOBAL_VALUE
, NULL GLOBAL_VALUE_ID
FROM OKC_BUS_VARIABLES_VL S
, OKC_K_ARTICLES_B K
, OKC_K_ART_VARIABLES V
WHERE K.ID = V.CAT_ID
AND V.VARIABLE_CODE = S.VARIABLE_CODE
AND S.VARIABLE_TYPE = 'U'
AND S.VARIABLE_SOURCE = 'M'
AND NVL(K.AMENDMENT_OPERATION_CODE
, '?') <> 'DELETED' GROUP BY S.VARIABLE_NAME
, S.DESCRIPTION
, S.VARIABLE_CODE
, S .VARIABLE_TYPE
, V.ATTRIBUTE_VALUE_SET_ID
, S.VARIABLE_DATATYPE
, S.EXTERNAL_YN
, K.DOCUMENT_TYPE
, K.DOCUMENT_ID