View: OKL_CRD_FUND_CHECKLISTS_TPL_UV

Product:	OKL - Lease and Finance Management
Description:	User interface view for credit and funding check list instance page
Implementation/DBA Data:	APPS.OKL_CRD_FUND_CHECKLISTS_TPL_UV

View Text

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(+)

Columns