View: OKL_CRD_FUND_CHKLST_TPL_HDR_UV

Product:	OKL - Lease and Finance Management
Description:	Credit Fund Checklist TPL Header UI View
Implementation/DBA Data:	APPS.OKL_CRD_FUND_CHKLST_TPL_HDR_UV

View Text

SELECT RULH.ID
, RULH.RGP_ID
, RULH.DNZ_CHR_ID KHR_ID
, 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
, RULH.RULE_INFORMATION4 SHORT_DESCRIPTION
, NVL(FND_PROFILE.VALUE('OKL_CREDIT_LINE_APPROVER')
, 'N') APPROVERYN
FROM OKC_RULES_B RULH
, OKC_STATUSES_V STATUS
WHERE RULH.RULE_INFORMATION_CATEGORY = 'LACLFM'
AND NVL(RULH.RULE_INFORMATION3
, 'NEW') = STATUS.CODE

Columns