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 239: in ( select match_rule_id from hz_match_rules_vl where rule_purpose = 'Q')

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

Line 711: from hz_match_rules_vl

707:
708: --- VJN INTRODUCED CODE FOR QUICK DUPLICATE IDENTIFICATION
709:
710: select rule_purpose into match_rule_purpose
711: from hz_match_rules_vl
712: where match_rule_id = l_rule_id ;
713:
714:
715: IF match_rule_purpose = 'Q'

Line 736: FROM hz_match_rules_vl

732: ELSE
733:
734: SELECT match_score, auto_merge_score
735: INTO l_match_score, l_auto_merge_score
736: FROM hz_match_rules_vl
737: WHERE match_rule_id = l_rule_id;
738:
739: IF l_auto_merge_score is null OR l_auto_merge_score < l_match_score THEN
740: l_auto_merge_score := 999999999;

Line 1090: l_mr_last_updated_date HZ_MATCH_RULES_VL.last_update_date%type;

1086: l_num_matches NUMBER;
1087: l_count NUMBER;
1088:
1089: l_dup_set_creation_date HZ_DUP_SETS.creation_date%type;
1090: l_mr_last_updated_date HZ_MATCH_RULES_VL.last_update_date%type;
1091: l_mr_comp_flag VARCHAR2(1);
1092:
1093: BEGIN
1094: -- Initialize return status and message stack

Line 1115: from HZ_MATCH_RULES_VL

1111: FROM HZ_DUP_SETS
1112: WHERE dup_set_id = p_dup_set_id;
1113:
1114: select last_update_date,compilation_flag INTO l_mr_last_updated_date,l_mr_comp_flag
1115: from HZ_MATCH_RULES_VL
1116: where match_rule_id = p_rule_id;
1117:
1118: IF l_mr_comp_flag <> 'C' OR l_mr_last_updated_date > l_dup_set_creation_date THEN
1119: FND_MESSAGE.SET_NAME('AR', 'HZ_CDL_NO_MATCH_DETAILS');