VIEW: APPS.OKL_CHECKLISTS_UV

Source

View Text - Preformatted

SELECT ckl.ID , ckl.OBJECT_VERSION_NUMBER , ckl.CHECKLIST_NUMBER , ckl.DESCRIPTION , ckl.SHORT_DESCRIPTION , ckl.CHECKLIST_TYPE , flk.meaning CHECKLIST_TYPE_MEANING , ckl.START_DATE , ckl.END_DATE , ckl.STATUS_CODE , flk4.meaning STATUS_CODE_MEANING , ckl.CHECKLIST_PURPOSE_CODE, flk2.meaning CHECKLIST_PURPOSE_MEANING , ckl.DECISION_DATE , ckl.CHECKLIST_OBJ_ID , ckl.CHECKLIST_OBJ_TYPE_CODE, ckl.ckl_id, ckl2.checklist_number, ckl.ATTRIBUTE_CATEGORY , ckl.ATTRIBUTE1 , ckl.ATTRIBUTE2 , ckl.ATTRIBUTE3 , ckl.ATTRIBUTE4 , ckl.ATTRIBUTE5 , ckl.ATTRIBUTE6 , ckl.ATTRIBUTE7 , ckl.ATTRIBUTE8 , ckl.ATTRIBUTE9 , ckl.ATTRIBUTE10 , ckl.ATTRIBUTE11 , ckl.ATTRIBUTE12 , ckl.ATTRIBUTE13 , ckl.ATTRIBUTE14 , ckl.ATTRIBUTE15 , ckl.ORG_ID , ckl.REQUEST_ID , ckl.PROGRAM_APPLICATION_ID , ckl.PROGRAM_ID , ckl.PROGRAM_UPDATE_DATE , ckl.CREATED_BY , ckl.CREATION_DATE , ckl.LAST_UPDATED_BY , ckl.LAST_UPDATE_DATE , ckl.LAST_UPDATE_LOGIN FROM OKL_CHECKLISTS CKL,OKL_CHECKLISTS_ALL CKL2,FND_LOOKUPS FLK,FND_LOOKUPS FLK2,FND_LOOKUPS FLK4 WHERE ckl.id = ckl2.ckl_id (+) and ckl.CHECKLIST_TYPE = flk.lookup_code and flk.lookup_type = 'OKL_CHECKLIST_TYPE' and ckl.CHECKLIST_PURPOSE_CODE = flk2.lookup_code and flk2.lookup_type = 'OKL_CHECKLIST_PURPOSE_CODE' and ckl.CHECKLIST_PURPOSE_CODE in ('CHECKLIST_TEMPLATE', 'CHECKLIST_TEMPLATE_GROUP') and ckl.STATUS_CODE = flk4.lookup_code and flk4.lookup_type = 'OKL_CHECKLIST_STATUS_CODE'

View Text - HTML Formatted

SELECT CKL.ID
, CKL.OBJECT_VERSION_NUMBER
, CKL.CHECKLIST_NUMBER
, CKL.DESCRIPTION
, CKL.SHORT_DESCRIPTION
, CKL.CHECKLIST_TYPE
, FLK.MEANING CHECKLIST_TYPE_MEANING
, CKL.START_DATE
, CKL.END_DATE
, CKL.STATUS_CODE
, FLK4.MEANING STATUS_CODE_MEANING
, CKL.CHECKLIST_PURPOSE_CODE
, FLK2.MEANING CHECKLIST_PURPOSE_MEANING
, CKL.DECISION_DATE
, CKL.CHECKLIST_OBJ_ID
, CKL.CHECKLIST_OBJ_TYPE_CODE
, CKL.CKL_ID
, CKL2.CHECKLIST_NUMBER
, CKL.ATTRIBUTE_CATEGORY
, CKL.ATTRIBUTE1
, CKL.ATTRIBUTE2
, CKL.ATTRIBUTE3
, CKL.ATTRIBUTE4
, CKL.ATTRIBUTE5
, CKL.ATTRIBUTE6
, CKL.ATTRIBUTE7
, CKL.ATTRIBUTE8
, CKL.ATTRIBUTE9
, CKL.ATTRIBUTE10
, CKL.ATTRIBUTE11
, CKL.ATTRIBUTE12
, CKL.ATTRIBUTE13
, CKL.ATTRIBUTE14
, CKL.ATTRIBUTE15
, CKL.ORG_ID
, CKL.REQUEST_ID
, CKL.PROGRAM_APPLICATION_ID
, CKL.PROGRAM_ID
, CKL.PROGRAM_UPDATE_DATE
, CKL.CREATED_BY
, CKL.CREATION_DATE
, CKL.LAST_UPDATED_BY
, CKL.LAST_UPDATE_DATE
, CKL.LAST_UPDATE_LOGIN
FROM OKL_CHECKLISTS CKL
, OKL_CHECKLISTS_ALL CKL2
, FND_LOOKUPS FLK
, FND_LOOKUPS FLK2
, FND_LOOKUPS FLK4
WHERE CKL.ID = CKL2.CKL_ID (+)
AND CKL.CHECKLIST_TYPE = FLK.LOOKUP_CODE
AND FLK.LOOKUP_TYPE = 'OKL_CHECKLIST_TYPE'
AND CKL.CHECKLIST_PURPOSE_CODE = FLK2.LOOKUP_CODE
AND FLK2.LOOKUP_TYPE = 'OKL_CHECKLIST_PURPOSE_CODE'
AND CKL.CHECKLIST_PURPOSE_CODE IN ('CHECKLIST_TEMPLATE'
, 'CHECKLIST_TEMPLATE_GROUP')
AND CKL.STATUS_CODE = FLK4.LOOKUP_CODE
AND FLK4.LOOKUP_TYPE = 'OKL_CHECKLIST_STATUS_CODE'