View: PER_CHECKLIST_ITEMS_V

Product:	PER - Human Resources
Description:
Implementation/DBA Data:	APPS.PER_CHECKLIST_ITEMS_V

View Text

SELECT PCHK.CHECKLIST_ITEM_ID
, PCHK.PERSON_ID
, PCHK.ITEM_CODE
, LKUP1.MEANING
, PCHK.DATE_DUE
, PCHK.DATE_DONE
, PCHK.STATUS
, LKUP2.MEANING
, PCHK.NOTES
, PCHK.OBJECT_VERSION_NUMBER
, PCHK.ATTRIBUTE_CATEGORY
, PCHK.ATTRIBUTE1
, PCHK.ATTRIBUTE2
, PCHK.ATTRIBUTE3
, PCHK.ATTRIBUTE4
, PCHK.ATTRIBUTE5
, PCHK.ATTRIBUTE6
, PCHK.ATTRIBUTE7
, PCHK.ATTRIBUTE8
, PCHK.ATTRIBUTE9
, PCHK.ATTRIBUTE10
, PCHK.ATTRIBUTE11
, PCHK.ATTRIBUTE12
, PCHK.ATTRIBUTE13
, PCHK.ATTRIBUTE14
, PCHK.ATTRIBUTE15
, PCHK.ATTRIBUTE16
, PCHK.ATTRIBUTE17
, PCHK.ATTRIBUTE18
, PCHK.ATTRIBUTE19
, PCHK.ATTRIBUTE20
, PCHK.ATTRIBUTE21
, PCHK.ATTRIBUTE22
, PCHK.ATTRIBUTE23
, PCHK.ATTRIBUTE24
, PCHK.ATTRIBUTE25
, PCHK.ATTRIBUTE26
, PCHK.ATTRIBUTE27
, PCHK.ATTRIBUTE28
, PCHK.ATTRIBUTE29
, PCHK.ATTRIBUTE30
, PCHK.LAST_UPDATE_DATE
, PCHK.LAST_UPDATED_BY
, PCHK.LAST_UPDATE_LOGIN
, PCHK.CREATED_BY
, PCHK.CREATION_DATE
FROM PER_CHECKLIST_ITEMS PCHK
, HR_LOOKUPS LKUP1
, HR_LOOKUPS LKUP2
WHERE PCHK.ITEM_CODE = LKUP1.LOOKUP_CODE(+)
AND LKUP1.LOOKUP_TYPE(+) = 'CHECKLIST_ITEM'
AND PCHK.STATUS = LKUP2.LOOKUP_CODE (+)
AND LKUP2.LOOKUP_TYPE (+) = 'CHECKLIST_STATUS'

Columns