Product: | OKE - Project Contracts |
---|---|
Description: | User Attributes View |
Implementation/DBA Data: | APPS.OKE_K_USER_ATTRIBUTES_V |
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