VIEW: APPS.OKL_CREDIT_CHECKLISTS_UV

Source

View Text - Preformatted

SELECT rult.ID, rult.RGP_ID, rult.DNZ_CHR_ID khr_id, rult.RULE_INFORMATION1 todo_item_code, lk1.MEANING todo_item_meaning, NVL(rult.RULE_INFORMATION2, 'N') mandatory_flag, lk2.MEANING mandatory_flag_meaning, NVL(rult.RULE_INFORMATION3, 'N') check_off, lk3.MEANING check_off_meaning, lk6.MEANING check_off_results, rult.RULE_INFORMATION4 note, nvl(rult.RULE_INFORMATION5, 'NEW') status, status.meaning status_meaning, nvl(fnd_profile.value('OKL_CREDIT_LINE_APPROVER'), 'N') approverYN, rult.RULE_INFORMATION6 admin_note, NVL(rult.RULE_INFORMATION7, 'UNDETERMINED') function_validate_rsts, lk4.MEANING func_val_rsts_meaning, rult.RULE_INFORMATION8 function_validate_msg, rult.RULE_INFORMATION9 function_id, fun.name function_name, fun.source function_source, NVL(rult.RULE_INFORMATION10, 'ACTIVATION') checklist_type, lk5.MEANING checklist_type_meaning, decode(rult.RULE_INFORMATION9,null, lk6.MEANING, lk4.MEANING) Checkist_results FROM OKC_RULES_B RULT,FND_LOOKUPS LK1,FND_LOOKUPS LK2,FND_LOOKUPS LK3,FND_LOOKUPS LK4,FND_LOOKUPS LK5,FND_LOOKUPS LK6,OKL_DATA_SRC_FNCTNS_B FUN,OKC_STATUSES_V STATUS WHERE rult.rule_information_category = 'LACCLD' and lk1.lookup_code = rult.RULE_INFORMATION1 and lk1.lookup_type = 'OKL_TODO_ITEMS' and lk2.lookup_code = NVL(rult.RULE_INFORMATION2, 'N') and lk2.lookup_type = 'YES_NO' and lk3.lookup_code = NVL(rult.RULE_INFORMATION3, 'N') and lk3.lookup_type = 'YES_NO' and nvl(rult.RULE_INFORMATION5,'NEW') = status.code and lk4.lookup_code = NVL(rult.RULE_INFORMATION7, 'UNDETERMINED') and lk4.lookup_type = 'OKL_FUN_VALIDATE_RSTS' and lk5.lookup_code = NVL(rult.RULE_INFORMATION10, 'ACTIVATION') and lk5.lookup_type = 'OKL_CHECKLIST_TYPE' and lk6.lookup_code = DECODE(NVL(rult.RULE_INFORMATION3,'N'), 'Y', 'PASSED', 'N', 'FAILED', 'UNDETERMINED') and lk6.lookup_type = 'OKL_FUN_VALIDATE_RSTS' and rult.RULE_INFORMATION9 = fun.ID(+)

View Text - HTML Formatted

SELECT RULT.ID
, RULT.RGP_ID
, RULT.DNZ_CHR_ID KHR_ID
, RULT.RULE_INFORMATION1 TODO_ITEM_CODE
, LK1.MEANING TODO_ITEM_MEANING
, NVL(RULT.RULE_INFORMATION2
, 'N') MANDATORY_FLAG
, LK2.MEANING MANDATORY_FLAG_MEANING
, NVL(RULT.RULE_INFORMATION3
, 'N') CHECK_OFF
, LK3.MEANING CHECK_OFF_MEANING
, LK6.MEANING CHECK_OFF_RESULTS
, RULT.RULE_INFORMATION4 NOTE
, NVL(RULT.RULE_INFORMATION5
, 'NEW') STATUS
, STATUS.MEANING STATUS_MEANING
, NVL(FND_PROFILE.VALUE('OKL_CREDIT_LINE_APPROVER')
, 'N') APPROVERYN
, RULT.RULE_INFORMATION6 ADMIN_NOTE
, NVL(RULT.RULE_INFORMATION7
, 'UNDETERMINED') FUNCTION_VALIDATE_RSTS
, LK4.MEANING FUNC_VAL_RSTS_MEANING
, RULT.RULE_INFORMATION8 FUNCTION_VALIDATE_MSG
, RULT.RULE_INFORMATION9 FUNCTION_ID
, FUN.NAME FUNCTION_NAME
, FUN.SOURCE FUNCTION_SOURCE
, NVL(RULT.RULE_INFORMATION10
, 'ACTIVATION') CHECKLIST_TYPE
, LK5.MEANING CHECKLIST_TYPE_MEANING
, DECODE(RULT.RULE_INFORMATION9
, NULL
, LK6.MEANING
, LK4.MEANING) CHECKIST_RESULTS
FROM OKC_RULES_B RULT
, FND_LOOKUPS LK1
, FND_LOOKUPS LK2
, FND_LOOKUPS LK3
, FND_LOOKUPS LK4
, FND_LOOKUPS LK5
, FND_LOOKUPS LK6
, OKL_DATA_SRC_FNCTNS_B FUN
, OKC_STATUSES_V STATUS
WHERE RULT.RULE_INFORMATION_CATEGORY = 'LACCLD'
AND LK1.LOOKUP_CODE = RULT.RULE_INFORMATION1
AND LK1.LOOKUP_TYPE = 'OKL_TODO_ITEMS'
AND LK2.LOOKUP_CODE = NVL(RULT.RULE_INFORMATION2
, 'N')
AND LK2.LOOKUP_TYPE = 'YES_NO'
AND LK3.LOOKUP_CODE = NVL(RULT.RULE_INFORMATION3
, 'N')
AND LK3.LOOKUP_TYPE = 'YES_NO'
AND NVL(RULT.RULE_INFORMATION5
, 'NEW') = STATUS.CODE
AND LK4.LOOKUP_CODE = NVL(RULT.RULE_INFORMATION7
, 'UNDETERMINED')
AND LK4.LOOKUP_TYPE = 'OKL_FUN_VALIDATE_RSTS'
AND LK5.LOOKUP_CODE = NVL(RULT.RULE_INFORMATION10
, 'ACTIVATION')
AND LK5.LOOKUP_TYPE = 'OKL_CHECKLIST_TYPE'
AND LK6.LOOKUP_CODE = DECODE(NVL(RULT.RULE_INFORMATION3
, 'N')
, 'Y'
, 'PASSED'
, 'N'
, 'FAILED'
, 'UNDETERMINED')
AND LK6.LOOKUP_TYPE = 'OKL_FUN_VALIDATE_RSTS'
AND RULT.RULE_INFORMATION9 = FUN.ID(+)