View: OKL_CHECKLIST_DETAILS_UV

Product:	OKL - Lease and Finance Management
Description:	User interfacer view for funding checklist details page
Implementation/DBA Data:	APPS.OKL_CHECKLIST_DETAILS_UV

View Text

SELECT CLD.ID
, CLD.OBJECT_VERSION_NUMBER
, CLD.CKL_ID
, CLH.CHECKLIST_TYPE
, FLK5.MEANING CHECKLIST_TYPE_MEANING
, CLD.TODO_ITEM_CODE
, FLK.MEANING TODO_ITEM_MEANING
, FLK.DESCRIPTION DESCRIPTION
, NVL(FLK.START_DATE_ACTIVE
, SYSDATE) EFFECTIVE_FROM
, NVL(FLK.END_DATE_ACTIVE
, SYSDATE+3650) EFFECTIVE_TO
, CLD.APPEAL_FLAG
, CLD.ATTRIBUTE_CATEGORY
, CLD.ATTRIBUTE1
, CLD.ATTRIBUTE2
, CLD.ATTRIBUTE3
, CLD.ATTRIBUTE4
, CLD.ATTRIBUTE5
, CLD.ATTRIBUTE6
, CLD.ATTRIBUTE7
, CLD.ATTRIBUTE8
, CLD.ATTRIBUTE9
, CLD.ATTRIBUTE10
, CLD.ATTRIBUTE11
, CLD.ATTRIBUTE12
, CLD.ATTRIBUTE13
, CLD.ATTRIBUTE14
, CLD.ATTRIBUTE15
, CLD.ORG_ID
, CLD.REQUEST_ID
, CLD.PROGRAM_APPLICATION_ID
, CLD.PROGRAM_ID
, CLD.PROGRAM_UPDATE_DATE
, CLD.CREATED_BY
, CLD.CREATION_DATE
, CLD.LAST_UPDATED_BY
, CLD.LAST_UPDATE_DATE
, CLD.LAST_UPDATE_LOGIN
, NVL(CLD.MANDATORY_FLAG
, 'N')
, FLK2.MEANING MANDATORY_FLAG_MEANING
, NVL(CLD.USER_COMPLETE_FLAG
, 'N')
, FLK3.MEANING USER_COMPLETE_FLAG_MEANING
, FLK6.MEANING USER_COMPLETE_FLAG_RESULTS
, CLD.ADMIN_NOTE
, CLD.USER_NOTE
, NVL(CLD.FUNCTION_VALIDATE_RSTS
, 'UNDETERMINED')
, FLK4.MEANING FUNCTION_VALIDATE_RSTS_MEANING
, CLD.FUNCTION_VALIDATE_MSG
, CLD.DNZ_CHECKLIST_OBJ_ID
, CLD.FUNCTION_ID
, FUN.NAME FUNCTION_NAME
, FUN.SOURCE FUNCTION_SOURCE
, DECODE(CLD.FUNCTION_ID
, NULL
, FLK6.MEANING
, FLK4.MEANING) CHECKIST_RESULTS
FROM OKL_CHECKLIST_DTLS_ALL CLD
, OKL_CHECKLISTS CLH
, FND_LOOKUPS FLK
, FND_LOOKUPS FLK2
, FND_LOOKUPS FLK3
, FND_LOOKUPS FLK4
, FND_LOOKUPS FLK5
, FND_LOOKUPS FLK6
, OKL_DATA_SRC_FNCTNS_B FUN
WHERE CLD.CKL_ID = CLH.ID
AND CLD.TODO_ITEM_CODE = FLK.LOOKUP_CODE
AND FLK.LOOKUP_TYPE = 'OKL_TODO_ITEMS'
AND NVL(CLD.MANDATORY_FLAG
, 'N') = FLK2.LOOKUP_CODE
AND FLK2.LOOKUP_TYPE = 'OKL_YES_NO'
AND NVL(CLD.USER_COMPLETE_FLAG
, 'N') = FLK3.LOOKUP_CODE
AND FLK3.LOOKUP_TYPE = 'OKL_YES_NO'
AND NVL(CLD.FUNCTION_VALIDATE_RSTS
, 'UNDETERMINED') = FLK4.LOOKUP_CODE
AND FLK4.LOOKUP_TYPE = 'OKL_FUN_VALIDATE_RSTS'
AND CLH.CHECKLIST_TYPE = FLK5.LOOKUP_CODE
AND FLK5.LOOKUP_TYPE = 'OKL_CHECKLIST_TYPE'
AND FLK6.LOOKUP_CODE = DECODE(NVL(CLD.USER_COMPLETE_FLAG
, 'N')
, 'Y'
, 'PASSED'
, 'N'
, 'FAILED'
, 'UNDETERMINED')
AND FLK6.LOOKUP_TYPE = 'OKL_FUN_VALIDATE_RSTS'
AND CLD.FUNCTION_ID = FUN.ID (+)

Columns