VIEW: APPS.CN_RULE_ATTR_EXPRESSION_V

Source

View Text - Preformatted

SELECT exp.RULE_ATTR_EXPRESSION_ID rule_attr_expression_id , exp.OPERAND1 operand1 , exp.OPERAND2 operand2 , exp.OPERATOR operator, decode(exp.operator, 0, 'AND', 1,'OR') operator_disp , exp.RULE_ID rule_id , exp.OPERAND_EXPRESSION_ID operand_expression_id , exp.OPERAND1_RA_RAE_FLAG operand1_ra_rae_flag , exp.OPERAND2_RA_RAE_FLAG operand2_ra_rae_flag , decode(exp.operand1_ra_rae_flag, 'RAE', cn_api.get_lkup_meaning('RES', 'Expression Messages')||exp.operand1, cn_api.get_attribute_desc(exp.rule_id, exp.operand1)) operand1_disp, decode(exp.operand2_ra_rae_flag,'RAE',cn_api.get_lkup_meaning('RES','Expression Messages')||exp.operand2, cn_api.get_attribute_desc(exp.rule_id, exp.operand2)) operand2_disp, cn_api.get_lkup_meaning('RES', 'Expression Messages')||operand_expression_id result_disp FROM cn_rule_attr_expression exp order by RULE_ATTR_EXPRESSION_ID

View Text - HTML Formatted

SELECT EXP.RULE_ATTR_EXPRESSION_ID RULE_ATTR_EXPRESSION_ID
, EXP.OPERAND1 OPERAND1
, EXP.OPERAND2 OPERAND2
, EXP.OPERATOR OPERATOR
, DECODE(EXP.OPERATOR
, 0
, 'AND'
, 1
, 'OR') OPERATOR_DISP
, EXP.RULE_ID RULE_ID
, EXP.OPERAND_EXPRESSION_ID OPERAND_EXPRESSION_ID
, EXP.OPERAND1_RA_RAE_FLAG OPERAND1_RA_RAE_FLAG
, EXP.OPERAND2_RA_RAE_FLAG OPERAND2_RA_RAE_FLAG
, DECODE(EXP.OPERAND1_RA_RAE_FLAG
, 'RAE'
, CN_API.GET_LKUP_MEANING('RES'
, 'EXPRESSION MESSAGES')||EXP.OPERAND1
, CN_API.GET_ATTRIBUTE_DESC(EXP.RULE_ID
, EXP.OPERAND1)) OPERAND1_DISP
, DECODE(EXP.OPERAND2_RA_RAE_FLAG
, 'RAE'
, CN_API.GET_LKUP_MEANING('RES'
, 'EXPRESSION MESSAGES')||EXP.OPERAND2
, CN_API.GET_ATTRIBUTE_DESC(EXP.RULE_ID
, EXP.OPERAND2)) OPERAND2_DISP
, CN_API.GET_LKUP_MEANING('RES'
, 'EXPRESSION MESSAGES')||OPERAND_EXPRESSION_ID RESULT_DISP
FROM CN_RULE_ATTR_EXPRESSION EXP ORDER BY RULE_ATTR_EXPRESSION_ID