APPS.HZ_BATCH_DUPLICATE dependencies on HZ_MATCH_RULES_VL

Line 141: from hz_match_rules_vl

137: req_data := fnd_conc_global.request_data;
138:
139: -- get the purpose of the match rule first
140: select rule_purpose into match_rule_purpose
141: from hz_match_rules_vl
142: where match_rule_id = p_rule_id ;
143:
144: l_batch_id := to_number(p_batch_name);
145:

Line 233: in ( select match_rule_id from hz_match_rules_vl where rule_purpose = 'Q')

229: from fnd_concurrent_requests a
230: where concurrent_program_id = 44445
231: and phase_code = 'R'
232: and substr(argument_text, 1, instr(argument_text,',') -1 )
233: in ( select match_rule_id from hz_match_rules_vl where rule_purpose = 'Q')
234: order by actual_start_date
235: )
236: LOOP
237: log('Request Id of the concurrent program running already is ' || req_cur.request_id );

Line 705: from hz_match_rules_vl

701:
702: --- VJN INTRODUCED CODE FOR QUICK DUPLICATE IDENTIFICATION
703:
704: select rule_purpose into match_rule_purpose
705: from hz_match_rules_vl
706: where match_rule_id = l_rule_id ;
707:
708:
709: IF match_rule_purpose = 'Q'

Line 730: FROM hz_match_rules_vl

726: ELSE
727:
728: SELECT match_score, auto_merge_score
729: INTO l_match_score, l_auto_merge_score
730: FROM hz_match_rules_vl
731: WHERE match_rule_id = l_rule_id;
732:
733: IF l_auto_merge_score is null OR l_auto_merge_score < l_match_score THEN
734: l_auto_merge_score := 999999999;

Line 1084: l_mr_last_updated_date HZ_MATCH_RULES_VL.last_update_date%type;

1080: l_num_matches NUMBER;
1081: l_count NUMBER;
1082:
1083: l_dup_set_creation_date HZ_DUP_SETS.creation_date%type;
1084: l_mr_last_updated_date HZ_MATCH_RULES_VL.last_update_date%type;
1085: l_mr_comp_flag VARCHAR2(1);
1086:
1087: BEGIN
1088: -- Initialize return status and message stack

Line 1109: from HZ_MATCH_RULES_VL

1105: FROM HZ_DUP_SETS
1106: WHERE dup_set_id = p_dup_set_id;
1107:
1108: select last_update_date,compilation_flag INTO l_mr_last_updated_date,l_mr_comp_flag
1109: from HZ_MATCH_RULES_VL
1110: where match_rule_id = p_rule_id;
1111:
1112: IF l_mr_comp_flag <> 'C' OR l_mr_last_updated_date > l_dup_set_creation_date THEN
1113: FND_MESSAGE.SET_NAME('AR', 'HZ_CDL_NO_MATCH_DETAILS');