VIEW: APPS.OKC_TERMS_ADD_VARIABL_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')