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.AMS_METRIC_FORMULA_PVT dependencies on AMS_LOOKUPS

Line 1111: IF ams_utility_pvt.check_lookup_exists('AMS_LOOKUPS','AMS_METRIC_SOURCE_TYPE',p_metric_formula_rec.source_type) = FND_API.G_FALSE THEN

1107: p_token_value=>p_metric_formula_rec.use_sub_id_flag);
1108: x_return_status := FND_API.g_ret_sts_error;
1109: END IF;
1110:
1111: IF ams_utility_pvt.check_lookup_exists('AMS_LOOKUPS','AMS_METRIC_SOURCE_TYPE',p_metric_formula_rec.source_type) = FND_API.G_FALSE THEN
1112: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_METR_INVALID_SOURCE_TYPE',
1113: p_token_name => 'SOURCE_TYPE',
1114: p_token_value => p_metric_formula_rec.source_type);
1115: x_return_status := FND_API.g_ret_sts_error;

Line 1118: IF ams_utility_pvt.check_lookup_exists('AMS_LOOKUPS','AMS_METRIC_NOTATION_TYPE',p_metric_formula_rec.notation_type) = FND_API.G_FALSE THEN

1114: p_token_value => p_metric_formula_rec.source_type);
1115: x_return_status := FND_API.g_ret_sts_error;
1116: END IF;
1117:
1118: IF ams_utility_pvt.check_lookup_exists('AMS_LOOKUPS','AMS_METRIC_NOTATION_TYPE',p_metric_formula_rec.notation_type) = FND_API.G_FALSE THEN
1119: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_METR_INVALID_NOTATION_TYPE',
1120: p_token_name => 'NOTATION_TYPE',
1121: p_token_value => p_metric_formula_rec.notation_type);
1122: x_return_status := FND_API.g_ret_sts_error;

Line 1126: ams_utility_pvt.check_lookup_exists('AMS_LOOKUPS','AMS_METRIC_OPERAND_TYPE',p_metric_formula_rec.token) = FND_API.G_FALSE THEN

1122: x_return_status := FND_API.g_ret_sts_error;
1123: END IF;
1124:
1125: IF p_metric_formula_rec.source_type = 'OPERATOR' and p_metric_formula_rec.TOKEN is not null and
1126: ams_utility_pvt.check_lookup_exists('AMS_LOOKUPS','AMS_METRIC_OPERAND_TYPE',p_metric_formula_rec.token) = FND_API.G_FALSE THEN
1127: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_METR_INVALID_OPERATOR',
1128: p_token_name => 'OPERATOR',
1129: p_token_value => p_metric_formula_rec.token);
1130: x_return_status := FND_API.g_ret_sts_error;

Line 1678: FROM ams_metric_formulas f, ams_metrics_vl m, ams_lookups opers,

1674: f.use_sub_id_flag ,
1675: f.source_value ,
1676: f.source_id,
1677: f.source_sub_id
1678: FROM ams_metric_formulas f, ams_metrics_vl m, ams_lookups opers,
1679: ams_categories_vl c, ams_categories_vl sc, ams_lookups delim,
1680: ams_lookups incsubcat, ams_lookups excsubcat
1681: WHERE f.metric_id = l_metric_id
1682: AND f.source_id = m.metric_id(+)

Line 1679: ams_categories_vl c, ams_categories_vl sc, ams_lookups delim,

1675: f.source_value ,
1676: f.source_id,
1677: f.source_sub_id
1678: FROM ams_metric_formulas f, ams_metrics_vl m, ams_lookups opers,
1679: ams_categories_vl c, ams_categories_vl sc, ams_lookups delim,
1680: ams_lookups incsubcat, ams_lookups excsubcat
1681: WHERE f.metric_id = l_metric_id
1682: AND f.source_id = m.metric_id(+)
1683: AND f.source_id = c.category_id(+)

Line 1680: ams_lookups incsubcat, ams_lookups excsubcat

1676: f.source_id,
1677: f.source_sub_id
1678: FROM ams_metric_formulas f, ams_metrics_vl m, ams_lookups opers,
1679: ams_categories_vl c, ams_categories_vl sc, ams_lookups delim,
1680: ams_lookups incsubcat, ams_lookups excsubcat
1681: WHERE f.metric_id = l_metric_id
1682: AND f.source_id = m.metric_id(+)
1683: AND f.source_id = c.category_id(+)
1684: AND c.arc_category_created_for(+) = 'METR'