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.MTH_UTIL_PKG dependencies on EGO_ATTRS_V

Line 1976: FROM EGO_ATTRS_V

1972: ) RETURN VARCHAR2 IS
1973: cursor getColumnName (p_attr_name in varchar2,
1974: p_att_grp_name IN VARCHAR2) is
1975: SELECT DATABASE_COLUMN
1976: FROM EGO_ATTRS_V
1977: WHERE application_id = 9001 AND
1978: ATTR_GROUP_TYPE = 'MTH_EQUIPMENTS_GROUP' AND
1979: attr_group_name = p_att_grp_name AND
1980: ATTR_NAME = p_attr_name;

Line 2040: * p_low_lim_name: attribute name in EGO_ATTRS_V *

2036: * Parameters : *
2037: * p_equipment_fk_key: Equipment fk key *
2038: * p_attr_name: Attribute name *
2039: * p_att_grp_name: attribute group name *
2040: * p_low_lim_name: attribute name in EGO_ATTRS_V *
2041: * p_upp_lim_name: another attribute name in EGO_ATTRS_V *
2042: * p_ret_LOWER_LIMIT : Lower limit returned *
2043: * p_ret_UPPER_LIMIT : Upper limit returned *
2044: * Modification log : *

Line 2041: * p_upp_lim_name: another attribute name in EGO_ATTRS_V *

2037: * p_equipment_fk_key: Equipment fk key *
2038: * p_attr_name: Attribute name *
2039: * p_att_grp_name: attribute group name *
2040: * p_low_lim_name: attribute name in EGO_ATTRS_V *
2041: * p_upp_lim_name: another attribute name in EGO_ATTRS_V *
2042: * p_ret_LOWER_LIMIT : Lower limit returned *
2043: * p_ret_UPPER_LIMIT : Upper limit returned *
2044: * Modification log : *
2045: * Author Date Change: Yong Feng 14-Jul-2009 Initial Creation *

Line 2485: * p_mean_attr_name: attribute name in EGO_ATTRS_V *

2481: * p_tag_code: tag code name *
2482: * p_tag_data: tag data *
2483: * p_reading_time: corresponding reading_time *
2484: * p_att_grp_name: group name *
2485: * p_mean_attr_name: attribute name in EGO_ATTRS_V *
2486: * p_num_of_readings: Number of consective readings to check *
2487: * p_range_in_hours: Number of hours, which is used to limit *
2488: * the search of the prevous reading to the range that is earlier *
2489: * than the reading_time and later than *

Line 2510: FROM mth_tag_destination_map t, ego_attrs_v a, EGO_ATTR_GROUPS_V g

2506: RETURN NUMBER
2507: IS
2508: CURSOR c_attr_name (p_tag_code IN VARCHAR2) IS
2509: SELECT a.attr_name, t.equipment_fk_key
2510: FROM mth_tag_destination_map t, ego_attrs_v a, EGO_ATTR_GROUPS_V g
2511: WHERE t.tag_code = p_tag_code and t.attribute = a.attr_id AND
2512: t.attribute_group = g.attr_group_id AND a.application_id = 9001 AND
2513: a.application_id = g.application_id and
2514: a.attr_group_name = g.attr_group_name;