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.

[Home] [Help]

APPS.CN_RULE_PUB dependencies on CN_RULES_HIERARCHY

Line 377: FROM cn_rules_hierarchy

373: from dual;
374:
375: SELECT Nvl(MAX(sequence_number) + 1, 1)
376: INTO l_rule_rec_pvt.sequence_number
377: FROM cn_rules_hierarchy
378: WHERE ruleset_id = l_rule_rec_pvt.ruleset_id
379: AND parent_rule_id = l_rule_rec_pvt.parent_rule_id and
380: org_id=l_rule_rec_pvt.org_id;
381:

Line 1662: from cn_rules_hierarchy

1658: select distinct(name) ruleName
1659: from cn_rules
1660: where rule_id in (
1661: select PARENT_RULE_ID
1662: from cn_rules_hierarchy
1663: where ruleset_id = p_ruleset_id
1664: connect by prior PARENT_RULE_ID = rule_id
1665: start with rule_id = p_rule_id);
1666: