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.

APPS.CN_RULEATTRIBUTE_PVT dependencies on CN_DIM_HIERARCHIES

Line 483: cn_dim_hierarchies dh

479:
480: SELECT hn.value_id
481: INTO l_hierarchy_value
482: FROM cn_hierarchy_nodes hn,
483: cn_dim_hierarchies dh
484: --WHERE hn.name = p_value_2
485: WHERE hn.value_id = p_value_2
486: AND hn.dim_hierarchy_id = dh.dim_hierarchy_id
487: and hn.org_id=dh.org_id

Line 806: cn_dim_hierarchies dh

802: WHERE head_hierarchy_id = p_RuleAttribute_rec.value_1 and org_id=p_RuleAttribute_rec.org_id;
803: SELECT hn.value_id
804: INTO l_hierarchy_value
805: FROM cn_hierarchy_nodes hn,
806: cn_dim_hierarchies dh
807: --WHERE hn.name = p_RuleAttribute_rec.value_2
808: WHERE hn.value_id = p_RuleAttribute_rec.value_2
809: AND hn.dim_hierarchy_id = dh.dim_hierarchy_id
810: AND dh.header_dim_hierarchy_id = l_dim_hierarchy_id

Line 1207: cn_dim_hierarchies dh

1203:
1204: SELECT hn.value_id
1205: INTO l_hierarchy_value
1206: FROM cn_hierarchy_nodes hn,
1207: cn_dim_hierarchies dh
1208: WHERE hn.value_id = p_RuleAttribute_rec.value_2
1209: AND hn.dim_hierarchy_id = dh.dim_hierarchy_id
1210: AND dh.header_dim_hierarchy_id = l_dim_hierarchy_id
1211: AND hn.org_id=dh.org_id