VIEW: APPS.PER_PERSON_TYPE_USAGES_V

Source

View Text - Preformatted

SELECT ptu.ROWID ROW_ID ,ptu.PERSON_TYPE_USAGE_ID ,ptu.PERSON_ID ,ptu.PERSON_TYPE_ID ,pt.SYSTEM_PERSON_TYPE ,pttl.USER_PERSON_TYPE ,ptu.EFFECTIVE_START_DATE ,ptu.EFFECTIVE_END_DATE ,ptu.OBJECT_VERSION_NUMBER ,ptu.LAST_UPDATED_BY ,ptu.LAST_UPDATE_DATE ,ptu.LAST_UPDATE_LOGIN ,ptu.CREATED_BY ,ptu.CREATION_DATE ,ptu.REQUEST_ID ,ptu.PROGRAM_APPLICATION_ID ,ptu.PROGRAM_ID ,ptu.PROGRAM_UPDATE_DATE ,ptu.ATTRIBUTE_CATEGORY ,ptu.ATTRIBUTE1 ,ptu.ATTRIBUTE2 ,ptu.ATTRIBUTE3 ,ptu.ATTRIBUTE4 ,ptu.ATTRIBUTE5 ,ptu.ATTRIBUTE6 ,ptu.ATTRIBUTE7 ,ptu.ATTRIBUTE8 ,ptu.ATTRIBUTE9 ,ptu.ATTRIBUTE10 ,ptu.ATTRIBUTE11 ,ptu.ATTRIBUTE12 ,ptu.ATTRIBUTE13 ,ptu.ATTRIBUTE14 ,ptu.ATTRIBUTE15 ,ptu.ATTRIBUTE16 ,ptu.ATTRIBUTE17 ,ptu.ATTRIBUTE18 ,ptu.ATTRIBUTE19 ,ptu.ATTRIBUTE20 ,ptu.ATTRIBUTE21 ,ptu.ATTRIBUTE22 ,ptu.ATTRIBUTE23 ,ptu.ATTRIBUTE24 ,ptu.ATTRIBUTE25 ,ptu.ATTRIBUTE26 ,ptu.ATTRIBUTE27 ,ptu.ATTRIBUTE28 ,ptu.ATTRIBUTE29 ,ptu.ATTRIBUTE30 from PER_PERSON_TYPE_USAGES_F ptu, fnd_sessions se, per_person_types_tl pttl, per_PERSON_TYPES pt where se.session_id = userenv('sessionid') and se.effective_date between ptu.effective_start_date and ptu.effective_end_date and pt.person_type_id = ptu.person_type_id and pt.person_type_id = pttl.person_type_id and pttl.language = userenv('LANG')

View Text - HTML Formatted

SELECT PTU.ROWID ROW_ID
, PTU.PERSON_TYPE_USAGE_ID
, PTU.PERSON_ID
, PTU.PERSON_TYPE_ID
, PT.SYSTEM_PERSON_TYPE
, PTTL.USER_PERSON_TYPE
, PTU.EFFECTIVE_START_DATE
, PTU.EFFECTIVE_END_DATE
, PTU.OBJECT_VERSION_NUMBER
, PTU.LAST_UPDATED_BY
, PTU.LAST_UPDATE_DATE
, PTU.LAST_UPDATE_LOGIN
, PTU.CREATED_BY
, PTU.CREATION_DATE
, PTU.REQUEST_ID
, PTU.PROGRAM_APPLICATION_ID
, PTU.PROGRAM_ID
, PTU.PROGRAM_UPDATE_DATE
, PTU.ATTRIBUTE_CATEGORY
, PTU.ATTRIBUTE1
, PTU.ATTRIBUTE2
, PTU.ATTRIBUTE3
, PTU.ATTRIBUTE4
, PTU.ATTRIBUTE5
, PTU.ATTRIBUTE6
, PTU.ATTRIBUTE7
, PTU.ATTRIBUTE8
, PTU.ATTRIBUTE9
, PTU.ATTRIBUTE10
, PTU.ATTRIBUTE11
, PTU.ATTRIBUTE12
, PTU.ATTRIBUTE13
, PTU.ATTRIBUTE14
, PTU.ATTRIBUTE15
, PTU.ATTRIBUTE16
, PTU.ATTRIBUTE17
, PTU.ATTRIBUTE18
, PTU.ATTRIBUTE19
, PTU.ATTRIBUTE20
, PTU.ATTRIBUTE21
, PTU.ATTRIBUTE22
, PTU.ATTRIBUTE23
, PTU.ATTRIBUTE24
, PTU.ATTRIBUTE25
, PTU.ATTRIBUTE26
, PTU.ATTRIBUTE27
, PTU.ATTRIBUTE28
, PTU.ATTRIBUTE29
, PTU.ATTRIBUTE30
FROM PER_PERSON_TYPE_USAGES_F PTU
, FND_SESSIONS SE
, PER_PERSON_TYPES_TL PTTL
, PER_PERSON_TYPES PT
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN PTU.EFFECTIVE_START_DATE
AND PTU.EFFECTIVE_END_DATE
AND PT.PERSON_TYPE_ID = PTU.PERSON_TYPE_ID
AND PT.PERSON_TYPE_ID = PTTL.PERSON_TYPE_ID
AND PTTL.LANGUAGE = USERENV('LANG')