Product: | OKL - Lease and Finance Management |
---|---|
Description: | User interface view for credit and funding checcklists page |
Implementation/DBA Data: | APPS.OKL_CHECKLISTS_UV |
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'