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_CLASSIFICATION_GEN dependencies on CN_OBJ_COLUMNS_V

Line 106: FROM cn_attribute_rules car, cn_obj_columns_v cocv

102: --which will enable to distinguish between numeric and alphanumeric usage
103: --of the attribute columns
104: column_value value, high_value, low_value,
105: not_flag, dimension_hierarchy_id
106: FROM cn_attribute_rules car, cn_obj_columns_v cocv
107: WHERE rule_id = X_rule_id
108: AND car.org_id=cocv.org_id
109: and car.org_id=x_org_id
110: AND cocv.column_id = car.column_id;

Line 322: FROM cn_attribute_rules car, cn_obj_columns_v cocv

318: CURSOR attribute_rules_cursor IS
319: SELECT attribute_rule_id, LOWER(cocv.name) column_name,
320: cocv.column_datatype data_type,cocv.data_type datatype,column_value value,
321: high_value, low_value, not_flag, dimension_hierarchy_id
322: FROM cn_attribute_rules car, cn_obj_columns_v cocv
323: WHERE rule_id = X_rule_id
324: and car.org_id= cocv.org_id
325: AND cocv.column_id = car.column_id;
326: CURSOR rule_attr_expr_cursor IS

Line 1681: FROM cn_rulesets cr, cn_obj_columns_v cocv

1677: and ruleset_id = x_ruleset_id;
1678:
1679: CURSOR rulesets IS
1680: SELECT LOWER(cocv.name) dest_column, cr.ruleset_id,cr.org_id,module_type
1681: FROM cn_rulesets cr, cn_obj_columns_v cocv
1682: WHERE cr.destination_column_id = cocv.column_id
1683: AND cr.repository_id = x_repository_id
1684: AND cr.org_id = cocv.org_id
1685: AND cr.org_id=x_org_id_in