Product: | OKC - Contracts Core |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKC_TERMS_ADD_VARIABL_V |
SELECT VAR_B.ROWID
, VAR_DOCS.DOC_TYPE
, VAR_B.VARIABLE_CODE
, VAR_B.OBJECT_VERSION_NUMBER
, VAR_B.VARIABLE_TYPE
, LOOKUP.MEANING
, VAR_TL.VARIABLE_NAME
, VAR_TL.DESCRIPTION
, VAR_B.EXTERNAL_YN
, VAR_B.VARIABLE_INTENT
, VAR_B.CONTRACT_EXPERT_YN
, VAR_B.DISABLED_YN
, VAR_B.VARIABLE_DATATYPE
, VAR_B.APPLICATION_ID
, VAR_B.VALUE_SET_ID
, VAR_B.VARIABLE_DEFAULT_VALUE
, VAR_B.CREATED_BY
, VAR_B.CREATION_DATE
, VAR_B.LAST_UPDATE_DATE
, VAR_B.LAST_UPDATED_BY
, VAR_B.LAST_UPDATE_LOGIN
, VAR_B.ATTRIBUTE_CATEGORY
, VAR_B.ATTRIBUTE1
, VAR_B.ATTRIBUTE2
, VAR_B.ATTRIBUTE3
, VAR_B.ATTRIBUTE4
, VAR_B.ATTRIBUTE5
, VAR_B.ATTRIBUTE6
, VAR_B.ATTRIBUTE7
, VAR_B.ATTRIBUTE8
, VAR_B.ATTRIBUTE9
, VAR_B.ATTRIBUTE10
, VAR_B.ATTRIBUTE11
, VAR_B.ATTRIBUTE12
, VAR_B.ATTRIBUTE13
, VAR_B.ATTRIBUTE14
, VAR_B.ATTRIBUTE15
, VAR_B.VARIABLE_SOURCE
FROM OKC_BUS_VARIABLES_TL VAR_TL
, OKC_BUS_VARIABLES_B VAR_B
, OKC_VARIABLE_DOC_TYPES VAR_DOCS
, FND_LOOKUPS LOOKUP
WHERE VAR_B.VARIABLE_CODE = VAR_TL.VARIABLE_CODE
AND VAR_TL.LANGUAGE = USERENV('LANG')
AND VAR_B.VARIABLE_CODE = VAR_DOCS.VARIABLE_CODE(+)
AND ((VAR_B.VARIABLE_TYPE <> 'U'
AND VAR_B.VARIABLE_CODE = VAR_DOCS.VARIABLE_CODE) OR (VAR_B.VARIABLE_TYPE = 'U'))
AND LOOKUP.LOOKUP_TYPE = 'OKC_ART_VAR_TYPE'
AND LOOKUP.LOOKUP_CODE = DECODE(VAR_B.VARIABLE_TYPE
, 'U'
, 'U'
, 'S')