APPS.HZ_MATCH_RULE_COMPILE dependencies on HZ_MATCH_RULE_CONDITIONS

Line 15121: FROM HZ_MATCH_RULE_CONDITIONS

15117: CURSOR c_ruleset_trans_func IS
15118: SELECT f.FUNCTION_ID
15119: FROM hz_primary_trans f, hz_match_rule_primary a
15120: WHERE a.MATCH_RULE_ID IN (SELECT UNIQUE CONDITION_MATCH_RULE_ID
15121: FROM HZ_MATCH_RULE_CONDITIONS
15122: WHERE MATCH_RULE_SET_ID = p_rule_id
15123: )
15124: AND a.PRIMARY_ATTRIBUTE_ID = f.PRIMARY_ATTRIBUTE_ID
15125:

Line 15131: FROM HZ_MATCH_RULE_CONDITIONS

15127:
15128: SELECT f.FUNCTION_ID
15129: FROM hz_secondary_trans f, hz_match_rule_secondary a
15130: WHERE a.MATCH_RULE_ID IN (SELECT UNIQUE CONDITION_MATCH_RULE_ID
15131: FROM HZ_MATCH_RULE_CONDITIONS
15132: WHERE MATCH_RULE_SET_ID = p_rule_id
15133: )
15134: AND a.SECONDARY_ATTRIBUTE_ID = f.SECONDARY_ATTRIBUTE_ID;
15135:

Line 16025: FROM HZ_MATCH_RULE_CONDITIONS

16021: IS
16022: CURSOR c_uncompiled_children IS
16023: SELECT count(unique compilation_flag) FROM HZ_MATCH_RULES_B
16024: WHERE match_rule_id IN( SELECT unique condition_match_rule_id
16025: FROM HZ_MATCH_RULE_CONDITIONS
16026: WHERE match_rule_set_id = p_rule_set_id)
16027: AND compilation_flag <> 'C';
16028: l_count NUMBER;
16029:

Line 16052: AND MATCH_RULE_ID IN (SELECT UNIQUE MATCH_RULE_SET_ID FROM HZ_MATCH_RULE_CONDITIONS

16048:
16049: CURSOR c_rulesets_for_compile IS
16050: SELECT UNIQUE MATCH_RULE_ID,RULE_NAME FROM HZ_MATCH_RULES_VL
16051: WHERE COMPILATION_FLAG <> 'C'
16052: AND MATCH_RULE_ID IN (SELECT UNIQUE MATCH_RULE_SET_ID FROM HZ_MATCH_RULE_CONDITIONS
16053: WHERE CONDITION_MATCH_RULE_ID = p_cond_rule_id)
16054: ;
16055:
16056:

Line 16140: ' FROM hz_match_rule_conditions cond,hz_trans_attributes_vl attr '||

16136:
16137: IF p_eval_level = 'PARTY' THEN
16138: l_sql :='SELECT condition_match_rule_id,attr.entity_name,'||
16139: ' attr.attribute_name,operation,value,rank '||
16140: ' FROM hz_match_rule_conditions cond,hz_trans_attributes_vl attr '||
16141: ' WHERE cond.match_rule_set_id = '||P_MRULE_SET_ID||
16142: ' AND cond.attribute_id= attr.attribute_id (+) '||
16143: ' ORDER BY rank ASC';
16144: ELSIF p_eval_level = 'PARTY_SITES' then

Line 16147: ' FROM hz_match_rule_conditions cond,hz_trans_attributes_vl attr '||

16143: ' ORDER BY rank ASC';
16144: ELSIF p_eval_level = 'PARTY_SITES' then
16145: l_sql :='SELECT condition_match_rule_id,attr.entity_name,'||
16146: ' attr.attribute_name,operation,value,rank '||
16147: ' FROM hz_match_rule_conditions cond,hz_trans_attributes_vl attr '||
16148: ' WHERE cond.match_rule_set_id = '||P_MRULE_SET_ID||
16149: ' AND nvl(attr.entity_name,''XYZ'') NOT IN (''PARTY'',''CONTACTS'') '||
16150: ' AND cond.attribute_id= attr.attribute_id (+) '||
16151: ' ORDER BY rank ASC';

Line 16155: ' FROM hz_match_rule_conditions cond,hz_trans_attributes_vl attr '||

16151: ' ORDER BY rank ASC';
16152: ELSIF p_eval_level = 'CONTACTS' then
16153: l_sql :='SELECT condition_match_rule_id,attr.entity_name,'||
16154: ' attr.attribute_name,operation,value,rank '||
16155: ' FROM hz_match_rule_conditions cond,hz_trans_attributes_vl attr '||
16156: ' WHERE cond.match_rule_set_id = '||P_MRULE_SET_ID||
16157: ' AND nvl(attr.entity_name,''XYZ'') NOT IN (''PARTY'',''PARTY_SITES'') '||
16158: ' AND cond.attribute_id= attr.attribute_id (+) '||
16159: ' ORDER BY rank ASC';

Line 16163: ' FROM hz_match_rule_conditions cond,hz_trans_attributes_vl attr '||

16159: ' ORDER BY rank ASC';
16160: ELSIF p_eval_level = 'CONTACT_POINTS' then
16161: l_sql :='SELECT condition_match_rule_id,attr.entity_name,'||
16162: ' attr.attribute_name,operation,value,rank '||
16163: ' FROM hz_match_rule_conditions cond,hz_trans_attributes_vl attr '||
16164: ' WHERE cond.match_rule_set_id = '||P_MRULE_SET_ID||
16165: ' AND nvl(attr.entity_name,''XYZ'') NOT IN (''PARTY'',''PARTY_SITES'',''CONTACTS'') '||
16166: ' AND cond.attribute_id= attr.attribute_id (+) '||
16167: ' ORDER BY rank ASC';