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
, 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 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

Columns