APPS.HZ_MATCH_RULE_COMPILE dependencies on HZ_MATCH_RULE_CONDITIONS

Line 15065: FROM HZ_MATCH_RULE_CONDITIONS

15061: CURSOR c_ruleset_trans_func IS
15062: SELECT f.FUNCTION_ID
15063: FROM hz_primary_trans f, hz_match_rule_primary a
15064: WHERE a.MATCH_RULE_ID IN (SELECT UNIQUE CONDITION_MATCH_RULE_ID
15065: FROM HZ_MATCH_RULE_CONDITIONS
15066: WHERE MATCH_RULE_SET_ID = p_rule_id
15067: )
15068: AND a.PRIMARY_ATTRIBUTE_ID = f.PRIMARY_ATTRIBUTE_ID
15069:

Line 15075: FROM HZ_MATCH_RULE_CONDITIONS

15071:
15072: SELECT f.FUNCTION_ID
15073: FROM hz_secondary_trans f, hz_match_rule_secondary a
15074: WHERE a.MATCH_RULE_ID IN (SELECT UNIQUE CONDITION_MATCH_RULE_ID
15075: FROM HZ_MATCH_RULE_CONDITIONS
15076: WHERE MATCH_RULE_SET_ID = p_rule_id
15077: )
15078: AND a.SECONDARY_ATTRIBUTE_ID = f.SECONDARY_ATTRIBUTE_ID;
15079:

Line 15967: FROM HZ_MATCH_RULE_CONDITIONS

15963: IS
15964: CURSOR c_uncompiled_children IS
15965: SELECT count(unique compilation_flag) FROM HZ_MATCH_RULES_B
15966: WHERE match_rule_id IN( SELECT unique condition_match_rule_id
15967: FROM HZ_MATCH_RULE_CONDITIONS
15968: WHERE match_rule_set_id = p_rule_set_id)
15969: AND compilation_flag <> 'C';
15970: l_count NUMBER;
15971:

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

15990:
15991: CURSOR c_rulesets_for_compile IS
15992: SELECT UNIQUE MATCH_RULE_ID,RULE_NAME FROM HZ_MATCH_RULES_VL
15993: WHERE COMPILATION_FLAG <> 'C'
15994: AND MATCH_RULE_ID IN (SELECT UNIQUE MATCH_RULE_SET_ID FROM HZ_MATCH_RULE_CONDITIONS
15995: WHERE CONDITION_MATCH_RULE_ID = p_cond_rule_id)
15996: ;
15997:
15998:

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

16078:
16079: IF p_eval_level = 'PARTY' THEN
16080: l_sql :='SELECT condition_match_rule_id,attr.entity_name,'||
16081: ' attr.attribute_name,operation,value,rank '||
16082: ' FROM hz_match_rule_conditions cond,hz_trans_attributes_vl attr '||
16083: ' WHERE cond.match_rule_set_id = '||P_MRULE_SET_ID||
16084: ' AND cond.attribute_id= attr.attribute_id (+) '||
16085: ' ORDER BY rank ASC';
16086: ELSIF p_eval_level = 'PARTY_SITES' then

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

16085: ' ORDER BY rank ASC';
16086: ELSIF p_eval_level = 'PARTY_SITES' then
16087: l_sql :='SELECT condition_match_rule_id,attr.entity_name,'||
16088: ' attr.attribute_name,operation,value,rank '||
16089: ' FROM hz_match_rule_conditions cond,hz_trans_attributes_vl attr '||
16090: ' WHERE cond.match_rule_set_id = '||P_MRULE_SET_ID||
16091: ' AND nvl(attr.entity_name,''XYZ'') NOT IN (''PARTY'',''CONTACTS'') '||
16092: ' AND cond.attribute_id= attr.attribute_id (+) '||
16093: ' ORDER BY rank ASC';

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

16093: ' ORDER BY rank ASC';
16094: ELSIF p_eval_level = 'CONTACTS' then
16095: l_sql :='SELECT condition_match_rule_id,attr.entity_name,'||
16096: ' attr.attribute_name,operation,value,rank '||
16097: ' FROM hz_match_rule_conditions cond,hz_trans_attributes_vl attr '||
16098: ' WHERE cond.match_rule_set_id = '||P_MRULE_SET_ID||
16099: ' AND nvl(attr.entity_name,''XYZ'') NOT IN (''PARTY'',''PARTY_SITES'') '||
16100: ' AND cond.attribute_id= attr.attribute_id (+) '||
16101: ' ORDER BY rank ASC';

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

16101: ' ORDER BY rank ASC';
16102: ELSIF p_eval_level = 'CONTACT_POINTS' then
16103: l_sql :='SELECT condition_match_rule_id,attr.entity_name,'||
16104: ' attr.attribute_name,operation,value,rank '||
16105: ' FROM hz_match_rule_conditions cond,hz_trans_attributes_vl attr '||
16106: ' WHERE cond.match_rule_set_id = '||P_MRULE_SET_ID||
16107: ' AND nvl(attr.entity_name,''XYZ'') NOT IN (''PARTY'',''PARTY_SITES'',''CONTACTS'') '||
16108: ' AND cond.attribute_id= attr.attribute_id (+) '||
16109: ' ORDER BY rank ASC';