Product: | OKL - Lease and Finance Management |
---|---|
Description: | User inteface view for lease creditline checklist |
Implementation/DBA Data: | APPS.OKL_CREDIT_CHECKLISTS_UV |
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(+)