VIEW: APPS.PER_CHECKLIST_ITEMS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'