VIEW: APPS.OKE_K_USER_ATTRIBUTES_V

Source

View Text - Preformatted

SELECT UA.ROWID , UA.K_USER_ATTRIBUTE_ID , UA.CREATION_DATE , UA.CREATED_BY , UA.LAST_UPDATE_DATE , UA.LAST_UPDATED_BY , UA.LAST_UPDATE_LOGIN , UA.RECORD_VERSION_NUMBER , UA.K_HEADER_ID , UA.K_LINE_ID , UA.USER_ATTRIBUTE_CONTEXT , DFC.DESCRIPTIVE_FLEX_CONTEXT_NAME , DFC.DESCRIPTION , UA.USER_ATTRIBUTE01 , UA.USER_ATTRIBUTE02 , UA.USER_ATTRIBUTE03 , UA.USER_ATTRIBUTE04 , UA.USER_ATTRIBUTE05 , UA.USER_ATTRIBUTE06 , UA.USER_ATTRIBUTE07 , UA.USER_ATTRIBUTE08 , UA.USER_ATTRIBUTE09 , UA.USER_ATTRIBUTE10 , UA.USER_ATTRIBUTE11 , UA.USER_ATTRIBUTE12 , UA.USER_ATTRIBUTE13 , UA.USER_ATTRIBUTE14 , UA.USER_ATTRIBUTE15 , UA.USER_ATTRIBUTE16 , UA.USER_ATTRIBUTE17 , UA.USER_ATTRIBUTE18 , UA.USER_ATTRIBUTE19 , UA.USER_ATTRIBUTE20 , UA.USER_ATTRIBUTE21 , UA.USER_ATTRIBUTE22 , UA.USER_ATTRIBUTE23 , UA.USER_ATTRIBUTE24 , UA.USER_ATTRIBUTE25 , UA.USER_ATTRIBUTE26 , UA.USER_ATTRIBUTE27 , UA.USER_ATTRIBUTE28 , UA.USER_ATTRIBUTE29 , UA.USER_ATTRIBUTE30 FROM OKE_K_USER_ATTRIBUTES UA , FND_DESCR_FLEX_CONTEXTS_TL DFC WHERE DFC.DESCRIPTIVE_FLEXFIELD_NAME = 'OKE_K_USER_ATTRIBUTES' AND DFC.APPLICATION_ID = 777 AND DFC.LANGUAGE = USERENV('LANG') AND UA.USER_ATTRIBUTE_CONTEXT = DFC.DESCRIPTIVE_FLEX_CONTEXT_CODE

View Text - HTML Formatted

SELECT UA.ROWID
, UA.K_USER_ATTRIBUTE_ID
, UA.CREATION_DATE
, UA.CREATED_BY
, UA.LAST_UPDATE_DATE
, UA.LAST_UPDATED_BY
, UA.LAST_UPDATE_LOGIN
, UA.RECORD_VERSION_NUMBER
, UA.K_HEADER_ID
, UA.K_LINE_ID
, UA.USER_ATTRIBUTE_CONTEXT
, DFC.DESCRIPTIVE_FLEX_CONTEXT_NAME
, DFC.DESCRIPTION
, UA.USER_ATTRIBUTE01
, UA.USER_ATTRIBUTE02
, UA.USER_ATTRIBUTE03
, UA.USER_ATTRIBUTE04
, UA.USER_ATTRIBUTE05
, UA.USER_ATTRIBUTE06
, UA.USER_ATTRIBUTE07
, UA.USER_ATTRIBUTE08
, UA.USER_ATTRIBUTE09
, UA.USER_ATTRIBUTE10
, UA.USER_ATTRIBUTE11
, UA.USER_ATTRIBUTE12
, UA.USER_ATTRIBUTE13
, UA.USER_ATTRIBUTE14
, UA.USER_ATTRIBUTE15
, UA.USER_ATTRIBUTE16
, UA.USER_ATTRIBUTE17
, UA.USER_ATTRIBUTE18
, UA.USER_ATTRIBUTE19
, UA.USER_ATTRIBUTE20
, UA.USER_ATTRIBUTE21
, UA.USER_ATTRIBUTE22
, UA.USER_ATTRIBUTE23
, UA.USER_ATTRIBUTE24
, UA.USER_ATTRIBUTE25
, UA.USER_ATTRIBUTE26
, UA.USER_ATTRIBUTE27
, UA.USER_ATTRIBUTE28
, UA.USER_ATTRIBUTE29
, UA.USER_ATTRIBUTE30
FROM OKE_K_USER_ATTRIBUTES UA
, FND_DESCR_FLEX_CONTEXTS_TL DFC
WHERE DFC.DESCRIPTIVE_FLEXFIELD_NAME = 'OKE_K_USER_ATTRIBUTES'
AND DFC.APPLICATION_ID = 777
AND DFC.LANGUAGE = USERENV('LANG')
AND UA.USER_ATTRIBUTE_CONTEXT = DFC.DESCRIPTIVE_FLEX_CONTEXT_CODE