SELECT B.RULE_VALUE2,
DECODE(A.RULE_VALUE1, 'D', '1', 'M', '2', 'W', 3) VALUE1,
case when B.RULE_VALUE2 = DECODE(A.RULE_VALUE1, 'D', '1', 'M', '2', 'W', 3) then 'TRUE' else 'FASLE' END
-- DECODE(A.RULE_VALUE1, 'D', '1', 'M', '2', 'W', 3) VALUE1
FROM CPMP.CFG_CPMP_PLAN_RULE A, CPMP.CFG_CPMP_PLAN_RULE B
WHERE A.RULE_TYPE = 126
AND A.STATE = 1
AND A.MKTG_PLAN_ID = B.MKTG_PLAN_ID
AND B.RULE_TYPE = 113
AND B.STATE = 1
AND B.MKTG_PLAN_ID = 6354