View: OKC_TERMS_GLOBAL_VAR_V

Product:	OKC - Contracts Core
Description:
Implementation/DBA Data:	APPS.OKC_TERMS_GLOBAL_VAR_V

View Text

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

Columns