VIEW: APPS.CN_RULE_ATTRIBUTES_DESC_V

Source

View Text - Preformatted

SELECT decode(car.not_flag, '', '','N','', cn_api.get_lkup_meaning(decode(car.not_flag,'Y','NOT'), 'Expression Messages') || ' ')|| co.user_name ||' ' || cn_api.get_lkup_meaning('IIH', 'Expression Messages') ||' '|| chh.name ||' ' || cn_api.get_lkup_meaning('WV', 'Expression Messages') ||' ' || max(chn.name) descriptive_rule_attribute, car.attribute_rule_id attribute_rule_id, cr.rule_id rule_id, decode(cr.rule_id, null,'','RA') EXPRESSION_FLAG, cr.org_id FROM cn_rules cr, cn_attribute_rules car, cn_objects co, cn_head_hierarchies chh, cn_hierarchy_nodes chn WHERE car.rule_id = cr.rule_id AND car.column_id = co.object_id AND chh.head_hierarchy_id = car.dimension_hierarchy_id AND cr.org_id=car.org_id and car.org_id= co.org_id and co.org_id =chh.org_id and chh.org_id=chn.org_id AND to_char( chn.value_id) = car.column_value GROUP BY car.not_flag, co.user_name, chh.name, car.attribute_rule_id, cr.rule_id,cr.org_id UNION ALL SELECT decode(car.not_flag,'', '','N','', cn_api.get_lkup_meaning(decode(car.not_flag, 'Y', 'NOT'), 'Expression Messages') || ' ')|| co.user_name || ' ' || cn_api.get_lkup_meaning('IS', 'Expression Messages') || ' ' || car.column_value descriptive_rule_attribute ,car.attribute_rule_id, cr.rule_id rule_id, decode(cr.rule_id, null,'','RA') EXPRESSION_FLAG,cr.org_id FROM cn_rules cr, cn_attribute_rules car, cn_objects co WHERE car.rule_id = cr.rule_id AND car.column_id = co.object_id AND car.dimension_hierarchy_id IS NULL And cr.org_id=car.org_id And car.org_id= co.org_id AND car.column_value IS NOT NULL UNION ALL SELECT decode(car.not_flag, '', '','N','', cn_api.get_lkup_meaning(decode(car.not_flag, 'Y', 'NOT') , 'Expression Messages')|| ' ') || co.user_name || ' ' || cn_api.get_lkup_meaning('BET', 'Expression Messages') || ' ' || car.low_value || ' ' || cn_api.get_lkup_meaning('AND', 'Expression Messages') || '' || car.high_value descriptive_rule_attribute , car.attribute_rule_id, cr.rule_id rule_id, decode(cr.rule_id, null,'','RA') EXPRESSION_FLAG,cr.org_id FROM cn_rules cr, cn_attribute_rules car, cn_objects co WHERE car.rule_id = cr.rule_id AND car.column_id = co.object_id AND car.high_value IS NOT NULL AND car.low_value IS NOT NULL And cr.org_id=car.org_id And car.org_id= co.org_id UNION ALL SELECT decode(car.not_flag, '', '','N','', cn_api.get_lkup_meaning(decode(car.not_flag, 'Y', 'NOT'), 'Expression Messages')|| ' ')|| co.user_name || ' ' || cn_api.get_lkup_meaning('LT', 'Expression Messages') || ' ' || car.high_value descriptive_rule_attribute , car.attribute_rule_id, cr.rule_id rule_id, decode(cr.rule_id, null,'','RA') EXPRESSION_FLAG,cr.org_id FROM cn_rules cr, cn_attribute_rules car, cn_objects co WHERE car.rule_id = cr.rule_id AND car.column_id = co.object_id AND car.high_value IS NOT NULL And cr.org_id=car.org_id And car.org_id= co.org_id AND car.low_value IS NULL UNION SELECT decode(car.not_flag, '', '','N','', cn_api.get_lkup_meaning(decode(car.not_flag, 'Y', 'NOT'), 'Expression Messages') || ' ')|| co.user_name || ' ' || cn_api.get_lkup_meaning('GT', 'Expression Messages') || ' ' || car.low_value descriptive_rule_attribute , car.attribute_rule_id, cr.rule_id rule_id, decode(cr.rule_id, null,'','RA') EXPRESSION_FLAG,cr.org_id FROM cn_rules cr, cn_attribute_rules car, cn_objects co WHERE car.rule_id = cr.rule_id AND car.column_id = co.object_id AND car.high_value IS NULL And cr.org_id=car.org_id And car.org_id= co.org_id AND car.low_value IS NOT NULL

View Text - HTML Formatted

SELECT DECODE(CAR.NOT_FLAG
, ''
, ''
, 'N'
, ''
, CN_API.GET_LKUP_MEANING(DECODE(CAR.NOT_FLAG
, 'Y'
, 'NOT')
, 'EXPRESSION MESSAGES') || ' ')|| CO.USER_NAME ||' ' || CN_API.GET_LKUP_MEANING('IIH'
, 'EXPRESSION MESSAGES') ||' '|| CHH.NAME ||' ' || CN_API.GET_LKUP_MEANING('WV'
, 'EXPRESSION MESSAGES') ||' ' || MAX(CHN.NAME) DESCRIPTIVE_RULE_ATTRIBUTE
, CAR.ATTRIBUTE_RULE_ID ATTRIBUTE_RULE_ID
, CR.RULE_ID RULE_ID
, DECODE(CR.RULE_ID
, NULL
, ''
, 'RA') EXPRESSION_FLAG
, CR.ORG_ID
FROM CN_RULES CR
, CN_ATTRIBUTE_RULES CAR
, CN_OBJECTS CO
, CN_HEAD_HIERARCHIES CHH
, CN_HIERARCHY_NODES CHN
WHERE CAR.RULE_ID = CR.RULE_ID
AND CAR.COLUMN_ID = CO.OBJECT_ID
AND CHH.HEAD_HIERARCHY_ID = CAR.DIMENSION_HIERARCHY_ID
AND CR.ORG_ID=CAR.ORG_ID
AND CAR.ORG_ID= CO.ORG_ID
AND CO.ORG_ID =CHH.ORG_ID
AND CHH.ORG_ID=CHN.ORG_ID
AND TO_CHAR( CHN.VALUE_ID) = CAR.COLUMN_VALUE GROUP BY CAR.NOT_FLAG
, CO.USER_NAME
, CHH.NAME
, CAR.ATTRIBUTE_RULE_ID
, CR.RULE_ID
, CR.ORG_ID UNION ALL SELECT DECODE(CAR.NOT_FLAG
, ''
, ''
, 'N'
, ''
, CN_API.GET_LKUP_MEANING(DECODE(CAR.NOT_FLAG
, 'Y'
, 'NOT')
, 'EXPRESSION MESSAGES') || ' ')|| CO.USER_NAME || ' ' || CN_API.GET_LKUP_MEANING('IS'
, 'EXPRESSION MESSAGES') || ' ' || CAR.COLUMN_VALUE DESCRIPTIVE_RULE_ATTRIBUTE
, CAR.ATTRIBUTE_RULE_ID
, CR.RULE_ID RULE_ID
, DECODE(CR.RULE_ID
, NULL
, ''
, 'RA') EXPRESSION_FLAG
, CR.ORG_ID
FROM CN_RULES CR
, CN_ATTRIBUTE_RULES CAR
, CN_OBJECTS CO
WHERE CAR.RULE_ID = CR.RULE_ID
AND CAR.COLUMN_ID = CO.OBJECT_ID
AND CAR.DIMENSION_HIERARCHY_ID IS NULL
AND CR.ORG_ID=CAR.ORG_ID
AND CAR.ORG_ID= CO.ORG_ID
AND CAR.COLUMN_VALUE IS NOT NULL UNION ALL SELECT DECODE(CAR.NOT_FLAG
, ''
, ''
, 'N'
, ''
, CN_API.GET_LKUP_MEANING(DECODE(CAR.NOT_FLAG
, 'Y'
, 'NOT')
, 'EXPRESSION MESSAGES')|| ' ') || CO.USER_NAME || ' ' || CN_API.GET_LKUP_MEANING('BET'
, 'EXPRESSION MESSAGES') || ' ' || CAR.LOW_VALUE || ' ' || CN_API.GET_LKUP_MEANING('AND'
, 'EXPRESSION MESSAGES') || '' || CAR.HIGH_VALUE DESCRIPTIVE_RULE_ATTRIBUTE
, CAR.ATTRIBUTE_RULE_ID
, CR.RULE_ID RULE_ID
, DECODE(CR.RULE_ID
, NULL
, ''
, 'RA') EXPRESSION_FLAG
, CR.ORG_ID
FROM CN_RULES CR
, CN_ATTRIBUTE_RULES CAR
, CN_OBJECTS CO
WHERE CAR.RULE_ID = CR.RULE_ID
AND CAR.COLUMN_ID = CO.OBJECT_ID
AND CAR.HIGH_VALUE IS NOT NULL
AND CAR.LOW_VALUE IS NOT NULL
AND CR.ORG_ID=CAR.ORG_ID
AND CAR.ORG_ID= CO.ORG_ID UNION ALL SELECT DECODE(CAR.NOT_FLAG
, ''
, ''
, 'N'
, ''
, CN_API.GET_LKUP_MEANING(DECODE(CAR.NOT_FLAG
, 'Y'
, 'NOT')
, 'EXPRESSION MESSAGES')|| ' ')|| CO.USER_NAME || ' ' || CN_API.GET_LKUP_MEANING('LT'
, 'EXPRESSION MESSAGES') || ' ' || CAR.HIGH_VALUE DESCRIPTIVE_RULE_ATTRIBUTE
, CAR.ATTRIBUTE_RULE_ID
, CR.RULE_ID RULE_ID
, DECODE(CR.RULE_ID
, NULL
, ''
, 'RA') EXPRESSION_FLAG
, CR.ORG_ID
FROM CN_RULES CR
, CN_ATTRIBUTE_RULES CAR
, CN_OBJECTS CO
WHERE CAR.RULE_ID = CR.RULE_ID
AND CAR.COLUMN_ID = CO.OBJECT_ID
AND CAR.HIGH_VALUE IS NOT NULL
AND CR.ORG_ID=CAR.ORG_ID
AND CAR.ORG_ID= CO.ORG_ID
AND CAR.LOW_VALUE IS NULL UNION SELECT DECODE(CAR.NOT_FLAG
, ''
, ''
, 'N'
, ''
, CN_API.GET_LKUP_MEANING(DECODE(CAR.NOT_FLAG
, 'Y'
, 'NOT')
, 'EXPRESSION MESSAGES') || ' ')|| CO.USER_NAME || ' ' || CN_API.GET_LKUP_MEANING('GT'
, 'EXPRESSION MESSAGES') || ' ' || CAR.LOW_VALUE DESCRIPTIVE_RULE_ATTRIBUTE
, CAR.ATTRIBUTE_RULE_ID
, CR.RULE_ID RULE_ID
, DECODE(CR.RULE_ID
, NULL
, ''
, 'RA') EXPRESSION_FLAG
, CR.ORG_ID
FROM CN_RULES CR
, CN_ATTRIBUTE_RULES CAR
, CN_OBJECTS CO
WHERE CAR.RULE_ID = CR.RULE_ID
AND CAR.COLUMN_ID = CO.OBJECT_ID
AND CAR.HIGH_VALUE IS NULL
AND CR.ORG_ID=CAR.ORG_ID
AND CAR.ORG_ID= CO.ORG_ID
AND CAR.LOW_VALUE IS NOT NULL