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.HZ_DQM_MR_PVT dependencies on HZ_MATCH_RULES_VL

Line 93: from hz_match_rules_vl

89: IS
90: CURSOR c0
91: IS
92: select match_score
93: from hz_match_rules_vl
94: where match_rule_id = p_match_rule_id;
95: l_yn number ;
96: result VARCHAR2(1);
97: BEGIN

Line 111: from hz_match_rules_vl

107: IS
108: CURSOR c0
109: IS
110: select auto_merge_score
111: from hz_match_rules_vl
112: where match_rule_id = p_match_rule_id;
113: l_yn number ;
114: result VARCHAR2(1);
115: BEGIN

Line 129: from hz_match_rules_vl

125: IS
126: CURSOR c0
127: IS
128: select match_all_flag
129: from hz_match_rules_vl
130: where match_rule_id = p_match_rule_id;
131: result VARCHAR2(1);
132: BEGIN
133: OPEN c0;

Line 252: from hz_match_rules_vl

248:
249:
250: -- Get the threshold and match_all_flag
251: select match_score, match_all_flag into match_score, match_all_flag
252: from hz_match_rules_vl
253: where match_rule_id = p_match_rule_id;
254:
255: -- threhold for the most part is the match-score, except that
256: -- we would change it according to the match_all_flag

Line 1014: from hz_match_rules_vl

1010:
1011: -- dbms_output.put_line('Attribute flag is ' || p_att_flag );
1012: -- Get the threshold and match_all_flag
1013: select match_score, match_all_flag into threshold, match_all_flag
1014: from hz_match_rules_vl
1015: where match_rule_id = p_match_rule_id;
1016:
1017: -- Get the different aggregates that would help in determining the template
1018: -- that need to be used -- UNION/UPDATE for the corresponding entity.

Line 2134: from hz_match_rules_vl

2130: BEGIN
2131:
2132: -- Get the threshold and match_all_flag
2133: select match_score, match_all_flag into threshold, match_all_flag
2134: from hz_match_rules_vl
2135: where match_rule_id = p_match_rule_id;
2136:
2137: -- Get the different aggregates that would help in determining the template
2138: -- that need to be used -- UNION/UPDATE for the corresponding entity.

Line 3188: from hz_match_rules_vl

3184: BEGIN
3185:
3186: -- Get the threshold and match_all_flag
3187: select match_score, match_all_flag into threshold, match_all_flag
3188: from hz_match_rules_vl
3189: where match_rule_id = p_match_rule_id;
3190:
3191: -- Get the different aggregates that would help in determining the template
3192: -- that need to be used -- UNION/UPDATE for the corresponding entity.