VIEW: APPS.OKL_CRD_FUND_CHECKLISTS_TPL_UV

Source

View Text - Preformatted

SELECT rult.ID, rult.RGP_ID, rult.DNZ_CHR_ID khr_id, rult.OBJECT1_ID1 laclfm_id, rult.RULE_INFORMATION1 todo_item_code, lk1.MEANING todo_item_meaning, NVL(rult.RULE_INFORMATION2,'N') mandatory_flag, lk2.MEANING mandatory_flag_meaning, rult.RULE_INFORMATION4 note, nvl(rulh.RULE_INFORMATION3,'NEW') status, status.meaning status_meaning, FND_DATE.CANONICAL_TO_DATE(rulh.RULE_INFORMATION1) Effective_from, FND_DATE.CANONICAL_TO_DATE(rulh.RULE_INFORMATION2) Effective_to, nvl(fnd_profile.value('OKL_CREDIT_LINE_APPROVER'),'N') approverYN, rult.RULE_INFORMATION5 admin_note, rult.RULE_INFORMATION6 function_id, fun.name function_name, fun.source function_source, NVL(rult.RULE_INFORMATION7, 'FUNDING') checklist_type, lk3.MEANING checklist_type_meaning FROM OKC_RULES_B RULT,OKC_RULES_B RULH,FND_LOOKUPS LK1,FND_LOOKUPS LK2,FND_LOOKUPS LK3,OKC_STATUSES_V STATUS,OKL_DATA_SRC_FNCTNS_V FUN WHERE rult.object1_id1 = rulh.id and rult.object1_id2 = '#' and rult.rule_information_category = 'LACLFD' 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 nvl(rulh.RULE_INFORMATION3,'NEW') = status.code and lk3.lookup_code = NVL(rult.RULE_INFORMATION7, 'FUNDING') and lk3.lookup_type = 'OKL_CHECKLIST_TYPE' and rult.RULE_INFORMATION6 = fun.ID(+)

View Text - HTML Formatted

SELECT RULT.ID
, RULT.RGP_ID
, RULT.DNZ_CHR_ID KHR_ID
, RULT.OBJECT1_ID1 LACLFM_ID
, RULT.RULE_INFORMATION1 TODO_ITEM_CODE
, LK1.MEANING TODO_ITEM_MEANING
, NVL(RULT.RULE_INFORMATION2
, 'N') MANDATORY_FLAG
, LK2.MEANING MANDATORY_FLAG_MEANING
, RULT.RULE_INFORMATION4 NOTE
, NVL(RULH.RULE_INFORMATION3
, 'NEW') STATUS
, STATUS.MEANING STATUS_MEANING
, FND_DATE.CANONICAL_TO_DATE(RULH.RULE_INFORMATION1) EFFECTIVE_FROM
, FND_DATE.CANONICAL_TO_DATE(RULH.RULE_INFORMATION2) EFFECTIVE_TO
, NVL(FND_PROFILE.VALUE('OKL_CREDIT_LINE_APPROVER')
, 'N') APPROVERYN
, RULT.RULE_INFORMATION5 ADMIN_NOTE
, RULT.RULE_INFORMATION6 FUNCTION_ID
, FUN.NAME FUNCTION_NAME
, FUN.SOURCE FUNCTION_SOURCE
, NVL(RULT.RULE_INFORMATION7
, 'FUNDING') CHECKLIST_TYPE
, LK3.MEANING CHECKLIST_TYPE_MEANING
FROM OKC_RULES_B RULT
, OKC_RULES_B RULH
, FND_LOOKUPS LK1
, FND_LOOKUPS LK2
, FND_LOOKUPS LK3
, OKC_STATUSES_V STATUS
, OKL_DATA_SRC_FNCTNS_V FUN
WHERE RULT.OBJECT1_ID1 = RULH.ID
AND RULT.OBJECT1_ID2 = '#'
AND RULT.RULE_INFORMATION_CATEGORY = 'LACLFD'
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 NVL(RULH.RULE_INFORMATION3
, 'NEW') = STATUS.CODE
AND LK3.LOOKUP_CODE = NVL(RULT.RULE_INFORMATION7
, 'FUNDING')
AND LK3.LOOKUP_TYPE = 'OKL_CHECKLIST_TYPE'
AND RULT.RULE_INFORMATION6 = FUN.ID(+)