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_MATCH_RULE_COMPILE dependencies on HZ_SECONDARY_TRANS

Line 508: FROM hz_match_rule_secondary s, hz_secondary_trans pt, hz_trans_functions_vl f

504: AND f.function_id = pt.function_id
505: AND f.ACTIVE_FLAG = 'N'
506: UNION
507: SELECT 1
508: FROM hz_match_rule_secondary s, hz_secondary_trans pt, hz_trans_functions_vl f
509: WHERE s.match_rule_id = p_rule_id
510: AND pt.SECONDARY_ATTRIBUTE_ID = s.SECONDARY_ATTRIBUTE_ID
511: AND f.function_id = pt.function_id
512: AND f.ACTIVE_FLAG = 'N';

Line 2285: FROM hz_trans_functions_vl f, hz_secondary_trans st,

2281: l(' x_matchidx OUT NUMBER');
2282: FIRST := TRUE;
2283: FOR TX IN (
2284: SELECT f.staged_attribute_column
2285: FROM hz_trans_functions_vl f, hz_secondary_trans st,
2286: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
2287: WHERE sa.match_rule_id = p_rule_id
2288: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
2289: AND st.function_id = f.function_id

Line 2324: FROM HZ_SECONDARY_TRANS s,

2320: FIRST := TRUE;
2321: FOR SECTRANS IN (
2322: SELECT TRANSFORMATION_NAME, STAGED_ATTRIBUTE_COLUMN, f.FUNCTION_ID,
2323: TRANSFORMATION_WEIGHT, SIMILARITY_CUTOFF
2324: FROM HZ_SECONDARY_TRANS s,
2325: HZ_TRANS_FUNCTIONS_VL f
2326: WHERE s.SECONDARY_ATTRIBUTE_ID = SECATTRS.SECONDARY_ATTRIBUTE_ID
2327: AND s.FUNCTION_ID = f.FUNCTION_ID
2328: ORDER BY TRANSFORMATION_WEIGHT desc) LOOP

Line 2393: FROM hz_trans_functions_vl f, hz_secondary_trans st,

2389: END IF;
2390: FIRST := TRUE;
2391: FOR TX IN (
2392: SELECT f.staged_attribute_column
2393: FROM hz_trans_functions_vl f, hz_secondary_trans st,
2394: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
2395: WHERE sa.match_rule_id = p_rule_id
2396: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
2397: AND st.function_id = f.function_id

Line 2423: FROM HZ_SECONDARY_TRANS s,

2419: l(' l_score :=0;');
2420: FOR SECTRANS IN (
2421: SELECT TRANSFORMATION_NAME, STAGED_ATTRIBUTE_COLUMN, f.FUNCTION_ID,
2422: TRANSFORMATION_WEIGHT, SIMILARITY_CUTOFF
2423: FROM HZ_SECONDARY_TRANS s,
2424: HZ_TRANS_FUNCTIONS_VL f
2425: WHERE s.SECONDARY_ATTRIBUTE_ID = SECATTRS.SECONDARY_ATTRIBUTE_ID
2426: AND s.FUNCTION_ID = f.FUNCTION_ID
2427: ORDER BY TRANSFORMATION_WEIGHT desc) LOOP

Line 2849: FROM hz_trans_functions_vl f, hz_secondary_trans st,

2845:
2846: FIRST := TRUE;
2847: FOR TX IN (
2848: SELECT f.staged_attribute_column, a.attribute_name, f.procedure_name
2849: FROM hz_trans_functions_vl f, hz_secondary_trans st,
2850: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
2851: WHERE sa.match_rule_id = p_rule_id
2852: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
2853: AND st.function_id = f.function_id

Line 3138: FROM hz_trans_functions_vl f, hz_secondary_trans st,

3134: l(' FUNCTION GET_PARTY_SCORE ');
3135: FIRST := TRUE;
3136: FOR TX IN (
3137: SELECT f.staged_attribute_column
3138: FROM hz_trans_functions_vl f, hz_secondary_trans st,
3139: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
3140: WHERE sa.match_rule_id = p_rule_id
3141: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
3142: AND st.function_id = f.function_id

Line 3178: FROM HZ_SECONDARY_TRANS s,

3174: FIRST := TRUE;
3175: FOR SECTRANS IN (
3176: SELECT TRANSFORMATION_NAME, STAGED_ATTRIBUTE_COLUMN, f.FUNCTION_ID,
3177: TRANSFORMATION_WEIGHT, SIMILARITY_CUTOFF
3178: FROM HZ_SECONDARY_TRANS s,
3179: HZ_TRANS_FUNCTIONS_VL f
3180: WHERE s.SECONDARY_ATTRIBUTE_ID = SECATTRS.SECONDARY_ATTRIBUTE_ID
3181: AND s.FUNCTION_ID = f.FUNCTION_ID
3182: ORDER BY TRANSFORMATION_WEIGHT desc) LOOP

Line 4883: FROM hz_trans_functions_vl f, hz_secondary_trans st,

4879: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
4880: l('');
4881: FOR TX IN (
4882: SELECT distinct f.staged_attribute_column
4883: FROM hz_trans_functions_vl f, hz_secondary_trans st,
4884: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
4885: WHERE sa.match_rule_id = p_rule_id
4886: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
4887: AND st.function_id = f.function_id

Line 5863: FROM hz_trans_functions_vl f, hz_secondary_trans st,

5859: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
5860: l('');
5861: FOR TX IN (
5862: SELECT distinct f.staged_attribute_column
5863: FROM hz_trans_functions_vl f, hz_secondary_trans st,
5864: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
5865: WHERE sa.match_rule_id = p_rule_id
5866: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
5867: AND st.function_id = f.function_id

Line 7490: FROM hz_trans_functions_vl f, hz_secondary_trans st,

7486: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
7487: l('');
7488: FOR TX IN (
7489: SELECT distinct f.staged_attribute_column
7490: FROM hz_trans_functions_vl f, hz_secondary_trans st,
7491: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
7492: WHERE sa.match_rule_id = p_rule_id
7493: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
7494: AND st.function_id = f.function_id

Line 7764: FROM hz_trans_functions_vl f, hz_secondary_trans st,

7760: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
7761: l('');
7762: FOR TX IN (
7763: SELECT distinct f.staged_attribute_column
7764: FROM hz_trans_functions_vl f, hz_secondary_trans st,
7765: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
7766: WHERE sa.match_rule_id = p_rule_id
7767: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
7768: AND st.function_id = f.function_id

Line 8032: FROM hz_trans_functions_vl f, hz_secondary_trans st,

8028: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
8029: l('');
8030: FOR TX IN (
8031: SELECT distinct f.staged_attribute_column
8032: FROM hz_trans_functions_vl f, hz_secondary_trans st,
8033: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
8034: WHERE sa.match_rule_id = p_rule_id
8035: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
8036: AND st.function_id = f.function_id

Line 8219: FROM hz_trans_functions_vl f, hz_secondary_trans st,

8215: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
8216: l('');
8217: FOR TX IN (
8218: SELECT distinct f.staged_attribute_column
8219: FROM hz_trans_functions_vl f, hz_secondary_trans st,
8220: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
8221: WHERE sa.match_rule_id = p_rule_id
8222: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
8223: AND st.function_id = f.function_id

Line 8326: FROM hz_trans_functions_vl f, hz_secondary_trans st,

8322: l(' l_max_id := l_party_site_id;');
8323: l(' l_max_idx := l_match_idx;');
8324: FOR TX IN (
8325: SELECT distinct f.staged_attribute_column
8326: FROM hz_trans_functions_vl f, hz_secondary_trans st,
8327: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
8328: WHERE sa.match_rule_id = p_rule_id
8329: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
8330: AND st.function_id = f.function_id

Line 8359: FROM hz_trans_functions_vl f, hz_secondary_trans st,

8355: l(' l_max_id := l_org_contact_id;');
8356: l(' l_max_idx := l_match_idx;');
8357: FOR TX IN (
8358: SELECT distinct f.staged_attribute_column
8359: FROM hz_trans_functions_vl f, hz_secondary_trans st,
8360: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
8361: WHERE sa.match_rule_id = p_rule_id
8362: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
8363: AND st.function_id = f.function_id

Line 8396: FROM hz_trans_functions_vl f, hz_secondary_trans st,

8392: l(' l_max_id := l_contact_pt_id;');
8393: l(' l_max_idx := l_match_idx;');
8394: FOR TX IN (
8395: SELECT distinct f.staged_attribute_column
8396: FROM hz_trans_functions_vl f, hz_secondary_trans st,
8397: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
8398: WHERE sa.match_rule_id = p_rule_id
8399: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
8400: AND st.function_id = f.function_id

Line 8870: FROM hz_trans_functions_vl f, hz_secondary_trans st,

8866: l(' FUNCTION GET_PARTY_SCORE ');
8867: FIRST := TRUE;
8868: FOR TX IN (
8869: SELECT f.staged_attribute_column
8870: FROM hz_trans_functions_vl f, hz_secondary_trans st,
8871: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
8872: WHERE sa.match_rule_id = p_rule_id
8873: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
8874: AND st.function_id = f.function_id

Line 8908: FROM HZ_SECONDARY_TRANS s,

8904: FIRST := TRUE;
8905: FOR SECTRANS IN (
8906: SELECT TRANSFORMATION_NAME, STAGED_ATTRIBUTE_COLUMN, f.FUNCTION_ID,
8907: TRANSFORMATION_WEIGHT, SIMILARITY_CUTOFF
8908: FROM HZ_SECONDARY_TRANS s,
8909: HZ_TRANS_FUNCTIONS_VL f
8910: WHERE s.SECONDARY_ATTRIBUTE_ID = SECATTRS.SECONDARY_ATTRIBUTE_ID
8911: AND s.FUNCTION_ID = f.FUNCTION_ID
8912: ORDER BY TRANSFORMATION_WEIGHT desc) LOOP

Line 9753: FROM hz_trans_functions_vl f, hz_secondary_trans st,

9749: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
9750: l('');
9751: FOR TX IN (
9752: SELECT distinct f.staged_attribute_column
9753: FROM hz_trans_functions_vl f, hz_secondary_trans st,
9754: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
9755: WHERE sa.match_rule_id = p_rule_id
9756: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
9757: AND st.function_id = f.function_id

Line 10498: FROM hz_trans_functions_vl f, hz_secondary_trans st,

10494: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
10495: l('');
10496: FOR TX IN (
10497: SELECT distinct f.staged_attribute_column
10498: FROM hz_trans_functions_vl f, hz_secondary_trans st,
10499: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
10500: WHERE sa.match_rule_id = p_rule_id
10501: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
10502: AND st.function_id = f.function_id

Line 11893: FROM hz_trans_functions_vl f, hz_secondary_trans st,

11889: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
11890: l('');
11891: FOR TX IN (
11892: SELECT distinct f.staged_attribute_column
11893: FROM hz_trans_functions_vl f, hz_secondary_trans st,
11894: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
11895: WHERE sa.match_rule_id = p_rule_id
11896: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
11897: AND st.function_id = f.function_id

Line 12134: FROM hz_trans_functions_vl f, hz_secondary_trans st,

12130: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
12131: l('');
12132: FOR TX IN (
12133: SELECT distinct f.staged_attribute_column
12134: FROM hz_trans_functions_vl f, hz_secondary_trans st,
12135: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
12136: WHERE sa.match_rule_id = p_rule_id
12137: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
12138: AND st.function_id = f.function_id

Line 12366: FROM hz_trans_functions_vl f, hz_secondary_trans st,

12362: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
12363: l('');
12364: FOR TX IN (
12365: SELECT distinct f.staged_attribute_column
12366: FROM hz_trans_functions_vl f, hz_secondary_trans st,
12367: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
12368: WHERE sa.match_rule_id = p_rule_id
12369: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
12370: AND st.function_id = f.function_id

Line 12532: FROM hz_trans_functions_vl f, hz_secondary_trans st,

12528: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
12529: l('');
12530: FOR TX IN (
12531: SELECT distinct f.staged_attribute_column
12532: FROM hz_trans_functions_vl f, hz_secondary_trans st,
12533: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
12534: WHERE sa.match_rule_id = p_rule_id
12535: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
12536: AND st.function_id = f.function_id

Line 12622: FROM hz_trans_functions_vl f, hz_secondary_trans st,

12618: l(' l_max_id := l_party_site_id;');
12619: l(' l_max_idx := l_match_idx;');
12620: FOR TX IN (
12621: SELECT distinct f.staged_attribute_column
12622: FROM hz_trans_functions_vl f, hz_secondary_trans st,
12623: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
12624: WHERE sa.match_rule_id = p_rule_id
12625: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
12626: AND st.function_id = f.function_id

Line 12655: FROM hz_trans_functions_vl f, hz_secondary_trans st,

12651: l(' l_max_id := l_org_contact_id;');
12652: l(' l_max_idx := l_match_idx;');
12653: FOR TX IN (
12654: SELECT distinct f.staged_attribute_column
12655: FROM hz_trans_functions_vl f, hz_secondary_trans st,
12656: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
12657: WHERE sa.match_rule_id = p_rule_id
12658: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
12659: AND st.function_id = f.function_id

Line 12688: FROM hz_trans_functions_vl f, hz_secondary_trans st,

12684: l(' l_max_id := l_contact_pt_id;');
12685: l(' l_max_idx := l_match_idx;');
12686: FOR TX IN (
12687: SELECT distinct f.staged_attribute_column
12688: FROM hz_trans_functions_vl f, hz_secondary_trans st,
12689: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
12690: WHERE sa.match_rule_id = p_rule_id
12691: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
12692: AND st.function_id = f.function_id

Line 12895: HZ_SECONDARY_TRANS sfunc

12891: f.STAGED_ATTRIBUTE_COLUMN
12892: FROM HZ_TRANS_FUNCTIONS_VL f,
12893: HZ_TRANS_ATTRIBUTES_VL a,
12894: HZ_MATCH_RULE_SECONDARY sattr,
12895: HZ_SECONDARY_TRANS sfunc
12896: WHERE sattr.MATCH_RULE_ID = p_rule_id
12897: AND sattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
12898: AND a.ENTITY_NAME = 'PARTY'
12899: AND sattr.SECONDARY_ATTRIBUTE_ID = sfunc.SECONDARY_ATTRIBUTE_ID

Line 13110: HZ_SECONDARY_TRANS sfunc

13106: f.STAGED_ATTRIBUTE_COLUMN
13107: FROM HZ_TRANS_FUNCTIONS_VL f,
13108: HZ_TRANS_ATTRIBUTES_VL a,
13109: HZ_MATCH_RULE_SECONDARY sattr,
13110: HZ_SECONDARY_TRANS sfunc
13111: WHERE sattr.MATCH_RULE_ID = p_rule_id
13112: AND sattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
13113: AND a.ENTITY_NAME = p_entity
13114: AND sattr.SECONDARY_ATTRIBUTE_ID = sfunc.SECONDARY_ATTRIBUTE_ID

Line 13224: HZ_SECONDARY_TRANS sfunc

13220: SELECT a.ATTRIBUTE_ID, a.ATTRIBUTE_NAME
13221: FROM HZ_TRANS_FUNCTIONS_VL f,
13222: HZ_TRANS_ATTRIBUTES_VL a,
13223: HZ_MATCH_RULE_SECONDARY sattr,
13224: HZ_SECONDARY_TRANS sfunc
13225: WHERE sattr.MATCH_RULE_ID = p_rule_id
13226: AND sattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
13227: AND a.ENTITY_NAME = p_entity
13228: AND sattr.SECONDARY_ATTRIBUTE_ID = sfunc.SECONDARY_ATTRIBUTE_ID

Line 13356: HZ_SECONDARY_TRANS sfunc

13352: f.STAGED_ATTRIBUTE_COLUMN
13353: FROM HZ_TRANS_FUNCTIONS_VL f,
13354: HZ_TRANS_ATTRIBUTES_VL a,
13355: HZ_MATCH_RULE_SECONDARY sattr,
13356: HZ_SECONDARY_TRANS sfunc
13357: WHERE sattr.MATCH_RULE_ID = p_rule_id
13358: AND sattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
13359: AND a.ENTITY_NAME = p_entity
13360: AND sattr.SECONDARY_ATTRIBUTE_ID = sfunc.SECONDARY_ATTRIBUTE_ID

Line 13424: HZ_SECONDARY_TRANS sfunc

13420: f.STAGED_ATTRIBUTE_COLUMN
13421: FROM HZ_TRANS_FUNCTIONS_VL f,
13422: HZ_TRANS_ATTRIBUTES_VL a,
13423: HZ_MATCH_RULE_SECONDARY sattr,
13424: HZ_SECONDARY_TRANS sfunc
13425: WHERE sattr.MATCH_RULE_ID = p_rule_id
13426: AND sattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
13427: AND a.ENTITY_NAME = p_entity
13428: AND sattr.SECONDARY_ATTRIBUTE_ID = sfunc.SECONDARY_ATTRIBUTE_ID

Line 13579: HZ_SECONDARY_TRANS sfunc

13575: f.STAGED_ATTRIBUTE_COLUMN
13576: FROM HZ_TRANS_FUNCTIONS_VL f,
13577: HZ_TRANS_ATTRIBUTES_VL a,
13578: HZ_MATCH_RULE_SECONDARY sattr,
13579: HZ_SECONDARY_TRANS sfunc
13580: WHERE sattr.MATCH_RULE_ID = p_rule_id
13581: AND sattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
13582: AND a.ENTITY_NAME = 'PARTY'
13583: AND sattr.SECONDARY_ATTRIBUTE_ID = sfunc.SECONDARY_ATTRIBUTE_ID

Line 15112: FROM hz_secondary_trans f, hz_match_rule_secondary a

15108:
15109: UNION
15110:
15111: SELECT f.FUNCTION_ID
15112: FROM hz_secondary_trans f, hz_match_rule_secondary a
15113: WHERE a.MATCH_RULE_ID = p_rule_id
15114: AND a.SECONDARY_ATTRIBUTE_ID = f.SECONDARY_ATTRIBUTE_ID;
15115:
15116: ---Start of Code Change for Match Rule Set

Line 15129: FROM hz_secondary_trans f, hz_match_rule_secondary a

15125:
15126: UNION
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: )