[Home] [Help]
View: 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
Name |
ID |
RGP_ID |
KHR_ID |
STATUS |
STATUS_MEANING |
EFFECTIVE_FROM |
EFFECTIVE_TO |
SHORT_DESCRIPTION |
APPROVERYN |