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, V.GLOBAL_VARIABLE_VALUE GLOBAL_VALUE, V.GLOBAL_VARIABLE_VALUE_ID GLOBAL_VALUE_ID, S.CLM_SOURCE 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' AND (V.GLOBAL_VARIABLE_VALUE IS NOT NULL OR NOT EXISTS (SELECT 1 FROM OKC_K_ART_VARIABLES W, OKC_K_ARTICLES_B K1 WHERE V.VARIABLE_CODE = W.VARIABLE_CODE AND V.VARIABLE_TYPE = W.VARIABLE_TYPE AND W.GLOBAL_VARIABLE_VALUE IS NOT NULL and K1.document_id = k.document_id and k1.document_type = k.document_type and k1.id = w.cat_id)) 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, V.GLOBAL_VARIABLE_VALUE, V.GLOBAL_VARIABLE_VALUE_ID, S.CLM_SOURCE

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
, V.GLOBAL_VARIABLE_VALUE GLOBAL_VALUE
, V.GLOBAL_VARIABLE_VALUE_ID GLOBAL_VALUE_ID
, S.CLM_SOURCE
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'
AND (V.GLOBAL_VARIABLE_VALUE IS NOT NULL OR NOT EXISTS (SELECT 1
FROM OKC_K_ART_VARIABLES W
, OKC_K_ARTICLES_B K1
WHERE V.VARIABLE_CODE = W.VARIABLE_CODE
AND V.VARIABLE_TYPE = W.VARIABLE_TYPE
AND W.GLOBAL_VARIABLE_VALUE IS NOT NULL
AND K1.DOCUMENT_ID = K.DOCUMENT_ID
AND K1.DOCUMENT_TYPE = K.DOCUMENT_TYPE
AND K1.ID = W.CAT_ID)) 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
, V.GLOBAL_VARIABLE_VALUE
, V.GLOBAL_VARIABLE_VALUE_ID
, S.CLM_SOURCE