eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CN_CLRL_API_V

Source

View Text - Preformatted


SELECT cnrset.name ruleset_name, cnrset.start_date start_date, cnrset.end_date end_date, cnrul1.name rule_name, cnrul2.name parent_rule_name, cnrev.name revenue_class_name, cnobj.name object_name, cnratr.not_flag not_flag, cnratr.column_value value_1, null value_2, 'O' data_flag from cn_rulesets cnrset, cn_rules_v cnrv, cn_rules cnrul1, cn_rules cnrul2, cn_revenue_classes cnrev, cn_objects cnobj, cn_attribute_rules cnratr WHERE cnrset.ruleset_id = cnrv.ruleset_id and cnrv.rule_id = cnrul1.rule_id and cnrv.ruleset_id = cnrset.ruleset_id and cnrv.parent_rule_id = cnrul2.rule_id and cnrul1.ruleset_id = cnrset.ruleset_id and cnrul2.ruleset_id = cnrset.ruleset_id and cnrv.revenue_class_id = cnrev.revenue_class_id and cnrv.rule_id = cnratr.rule_id and cnrv.ruleset_id = cnratr.ruleset_id and cnrv.rule_id <> -1002 and cnratr.column_value is not null and dimension_hierarchy_id is null and cnratr.column_id = cnobj.object_id UNION select cnrset.name ruleset_name, cnrset.start_date start_date, cnrset.end_date end_date, cnrul1.name rule_name, cnrul2.name parent_rule_name, cnrev.name revenue_class_name, cnobj.name object_name, cnratr.not_flag not_flag, cnratr.low_value value_1, cnratr.high_value value_2, 'R' data_flag from cn_rulesets cnrset, cn_rules_v cnrv, cn_rules cnrul1, cn_rules cnrul2, cn_revenue_classes cnrev, cn_objects cnobj, cn_attribute_rules cnratr where cnrset.ruleset_id = cnrv.ruleset_id and cnrv.rule_id = cnrul1.rule_id and cnrv.ruleset_id = cnrset.ruleset_id and cnrv.parent_rule_id = cnrul2.rule_id and cnrul1.ruleset_id = cnrset.ruleset_id and cnrul2.ruleset_id = cnrset.ruleset_id and cnrv.revenue_class_id = cnrev.revenue_class_id and cnrv.rule_id = cnratr.rule_id and cnrv.ruleset_id = cnratr.ruleset_id and cnrv.rule_id <> -1002 and cnratr.low_value is not null and cnratr.high_value is not null and cnratr.column_id = cnobj.object_id UNION select cnrset.name ruleset_name, cnrset.start_date, cnrset.end_date, cnrul1.name rule_name, cnrul2.name parent_rule_name, cnrev.name revenue_class_name, cnobj.name object_name, cnratr.not_flag not_flag, to_char(cnratr.dimension_hierarchy_id) value_1, cnratr.column_value value_2, 'H' data_flag from cn_rulesets cnrset, cn_rules_v cnrv, cn_rules cnrul1, cn_rules cnrul2, cn_revenue_classes cnrev, cn_objects cnobj, cn_attribute_rules cnratr where cnrset.ruleset_id = cnrv.ruleset_id and cnrv.rule_id = cnrul1.rule_id and cnrv.ruleset_id = cnrset.ruleset_id and cnrv.parent_rule_id = cnrul2.rule_id and cnrul1.ruleset_id = cnrset.ruleset_id and cnrul2.ruleset_id = cnrset.ruleset_id and cnrv.revenue_class_id = cnrev.revenue_class_id and cnrv.rule_id = cnratr.rule_id and cnrv.ruleset_id = cnratr.ruleset_id and cnrv.rule_id <> -1002 and cnratr.column_value is not null and dimension_hierarchy_id is not null and cnratr.column_id = cnobj.object_id

View Text - HTML Formatted

SELECT CNRSET.NAME RULESET_NAME
, CNRSET.START_DATE START_DATE
, CNRSET.END_DATE END_DATE
, CNRUL1.NAME RULE_NAME
, CNRUL2.NAME PARENT_RULE_NAME
, CNREV.NAME REVENUE_CLASS_NAME
, CNOBJ.NAME OBJECT_NAME
, CNRATR.NOT_FLAG NOT_FLAG
, CNRATR.COLUMN_VALUE VALUE_1
, NULL VALUE_2
, 'O' DATA_FLAG
FROM CN_RULESETS CNRSET
, CN_RULES_V CNRV
, CN_RULES CNRUL1
, CN_RULES CNRUL2
, CN_REVENUE_CLASSES CNREV
, CN_OBJECTS CNOBJ
, CN_ATTRIBUTE_RULES CNRATR
WHERE CNRSET.RULESET_ID = CNRV.RULESET_ID
AND CNRV.RULE_ID = CNRUL1.RULE_ID
AND CNRV.RULESET_ID = CNRSET.RULESET_ID
AND CNRV.PARENT_RULE_ID = CNRUL2.RULE_ID
AND CNRUL1.RULESET_ID = CNRSET.RULESET_ID
AND CNRUL2.RULESET_ID = CNRSET.RULESET_ID
AND CNRV.REVENUE_CLASS_ID = CNREV.REVENUE_CLASS_ID
AND CNRV.RULE_ID = CNRATR.RULE_ID
AND CNRV.RULESET_ID = CNRATR.RULESET_ID
AND CNRV.RULE_ID <> -1002
AND CNRATR.COLUMN_VALUE IS NOT NULL
AND DIMENSION_HIERARCHY_ID IS NULL
AND CNRATR.COLUMN_ID = CNOBJ.OBJECT_ID UNION SELECT CNRSET.NAME RULESET_NAME
, CNRSET.START_DATE START_DATE
, CNRSET.END_DATE END_DATE
, CNRUL1.NAME RULE_NAME
, CNRUL2.NAME PARENT_RULE_NAME
, CNREV.NAME REVENUE_CLASS_NAME
, CNOBJ.NAME OBJECT_NAME
, CNRATR.NOT_FLAG NOT_FLAG
, CNRATR.LOW_VALUE VALUE_1
, CNRATR.HIGH_VALUE VALUE_2
, 'R' DATA_FLAG
FROM CN_RULESETS CNRSET
, CN_RULES_V CNRV
, CN_RULES CNRUL1
, CN_RULES CNRUL2
, CN_REVENUE_CLASSES CNREV
, CN_OBJECTS CNOBJ
, CN_ATTRIBUTE_RULES CNRATR
WHERE CNRSET.RULESET_ID = CNRV.RULESET_ID
AND CNRV.RULE_ID = CNRUL1.RULE_ID
AND CNRV.RULESET_ID = CNRSET.RULESET_ID
AND CNRV.PARENT_RULE_ID = CNRUL2.RULE_ID
AND CNRUL1.RULESET_ID = CNRSET.RULESET_ID
AND CNRUL2.RULESET_ID = CNRSET.RULESET_ID
AND CNRV.REVENUE_CLASS_ID = CNREV.REVENUE_CLASS_ID
AND CNRV.RULE_ID = CNRATR.RULE_ID
AND CNRV.RULESET_ID = CNRATR.RULESET_ID
AND CNRV.RULE_ID <> -1002
AND CNRATR.LOW_VALUE IS NOT NULL
AND CNRATR.HIGH_VALUE IS NOT NULL
AND CNRATR.COLUMN_ID = CNOBJ.OBJECT_ID UNION SELECT CNRSET.NAME RULESET_NAME
, CNRSET.START_DATE
, CNRSET.END_DATE
, CNRUL1.NAME RULE_NAME
, CNRUL2.NAME PARENT_RULE_NAME
, CNREV.NAME REVENUE_CLASS_NAME
, CNOBJ.NAME OBJECT_NAME
, CNRATR.NOT_FLAG NOT_FLAG
, TO_CHAR(CNRATR.DIMENSION_HIERARCHY_ID) VALUE_1
, CNRATR.COLUMN_VALUE VALUE_2
, 'H' DATA_FLAG
FROM CN_RULESETS CNRSET
, CN_RULES_V CNRV
, CN_RULES CNRUL1
, CN_RULES CNRUL2
, CN_REVENUE_CLASSES CNREV
, CN_OBJECTS CNOBJ
, CN_ATTRIBUTE_RULES CNRATR
WHERE CNRSET.RULESET_ID = CNRV.RULESET_ID
AND CNRV.RULE_ID = CNRUL1.RULE_ID
AND CNRV.RULESET_ID = CNRSET.RULESET_ID
AND CNRV.PARENT_RULE_ID = CNRUL2.RULE_ID
AND CNRUL1.RULESET_ID = CNRSET.RULESET_ID
AND CNRUL2.RULESET_ID = CNRSET.RULESET_ID
AND CNRV.REVENUE_CLASS_ID = CNREV.REVENUE_CLASS_ID
AND CNRV.RULE_ID = CNRATR.RULE_ID
AND CNRV.RULESET_ID = CNRATR.RULESET_ID
AND CNRV.RULE_ID <> -1002
AND CNRATR.COLUMN_VALUE IS NOT NULL
AND DIMENSION_HIERARCHY_ID IS NOT NULL
AND CNRATR.COLUMN_ID = CNOBJ.OBJECT_ID