VIEW: APPS.OKL_INSTANCE_CHECKLIST_DTL_UV

Source

View Text - Preformatted

SELECT cld.ID , cld.OBJECT_VERSION_NUMBER , cld.CKL_ID , 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.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, cld.INST_CHECKLIST_TYPE, flk7.MEANING INST_CHECKLIST_TYPE_MEANING FROM OKL_CHECKLIST_DETAILS CLD,FND_LOOKUPS FLK,FND_LOOKUPS FLK2,FND_LOOKUPS FLK3,FND_LOOKUPS FLK4,FND_LOOKUPS FLK6,FND_LOOKUPS FLK7,OKL_DATA_SRC_FNCTNS_B FUN WHERE 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 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 (+) and cld.INST_CHECKLIST_TYPE = flk7.lookup_code and flk7.lookup_type = 'OKL_CHECKLIST_TYPE'

View Text - HTML Formatted

SELECT CLD.ID
, CLD.OBJECT_VERSION_NUMBER
, CLD.CKL_ID
, 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.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
, CLD.INST_CHECKLIST_TYPE
, FLK7.MEANING INST_CHECKLIST_TYPE_MEANING
FROM OKL_CHECKLIST_DETAILS CLD
, FND_LOOKUPS FLK
, FND_LOOKUPS FLK2
, FND_LOOKUPS FLK3
, FND_LOOKUPS FLK4
, FND_LOOKUPS FLK6
, FND_LOOKUPS FLK7
, OKL_DATA_SRC_FNCTNS_B FUN
WHERE 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 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 (+)
AND CLD.INST_CHECKLIST_TYPE = FLK7.LOOKUP_CODE
AND FLK7.LOOKUP_TYPE = 'OKL_CHECKLIST_TYPE'