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 3131: FROM hz_trans_functions_vl f, hz_secondary_trans st,

3127: l(' FUNCTION GET_PARTY_SCORE ');
3128: FIRST := TRUE;
3129: FOR TX IN (
3130: SELECT f.staged_attribute_column
3131: FROM hz_trans_functions_vl f, hz_secondary_trans st,
3132: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
3133: WHERE sa.match_rule_id = p_rule_id
3134: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
3135: AND st.function_id = f.function_id

Line 3171: FROM HZ_SECONDARY_TRANS s,

3167: FIRST := TRUE;
3168: FOR SECTRANS IN (
3169: SELECT TRANSFORMATION_NAME, STAGED_ATTRIBUTE_COLUMN, f.FUNCTION_ID,
3170: TRANSFORMATION_WEIGHT, SIMILARITY_CUTOFF
3171: FROM HZ_SECONDARY_TRANS s,
3172: HZ_TRANS_FUNCTIONS_VL f
3173: WHERE s.SECONDARY_ATTRIBUTE_ID = SECATTRS.SECONDARY_ATTRIBUTE_ID
3174: AND s.FUNCTION_ID = f.FUNCTION_ID
3175: ORDER BY TRANSFORMATION_WEIGHT desc) LOOP

Line 4874: FROM hz_trans_functions_vl f, hz_secondary_trans st,

4870: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
4871: l('');
4872: FOR TX IN (
4873: SELECT distinct f.staged_attribute_column
4874: FROM hz_trans_functions_vl f, hz_secondary_trans st,
4875: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
4876: WHERE sa.match_rule_id = p_rule_id
4877: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
4878: AND st.function_id = f.function_id

Line 5840: FROM hz_trans_functions_vl f, hz_secondary_trans st,

5836: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
5837: l('');
5838: FOR TX IN (
5839: SELECT distinct f.staged_attribute_column
5840: FROM hz_trans_functions_vl f, hz_secondary_trans st,
5841: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
5842: WHERE sa.match_rule_id = p_rule_id
5843: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
5844: AND st.function_id = f.function_id

Line 7451: FROM hz_trans_functions_vl f, hz_secondary_trans st,

7447: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
7448: l('');
7449: FOR TX IN (
7450: SELECT distinct f.staged_attribute_column
7451: FROM hz_trans_functions_vl f, hz_secondary_trans st,
7452: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
7453: WHERE sa.match_rule_id = p_rule_id
7454: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
7455: AND st.function_id = f.function_id

Line 7725: FROM hz_trans_functions_vl f, hz_secondary_trans st,

7721: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
7722: l('');
7723: FOR TX IN (
7724: SELECT distinct f.staged_attribute_column
7725: FROM hz_trans_functions_vl f, hz_secondary_trans st,
7726: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
7727: WHERE sa.match_rule_id = p_rule_id
7728: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
7729: AND st.function_id = f.function_id

Line 7993: FROM hz_trans_functions_vl f, hz_secondary_trans st,

7989: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
7990: l('');
7991: FOR TX IN (
7992: SELECT distinct f.staged_attribute_column
7993: FROM hz_trans_functions_vl f, hz_secondary_trans st,
7994: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
7995: WHERE sa.match_rule_id = p_rule_id
7996: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
7997: AND st.function_id = f.function_id

Line 8180: FROM hz_trans_functions_vl f, hz_secondary_trans st,

8176: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
8177: l('');
8178: FOR TX IN (
8179: SELECT distinct f.staged_attribute_column
8180: FROM hz_trans_functions_vl f, hz_secondary_trans st,
8181: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
8182: WHERE sa.match_rule_id = p_rule_id
8183: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
8184: AND st.function_id = f.function_id

Line 8280: FROM hz_trans_functions_vl f, hz_secondary_trans st,

8276: l(' l_max_id := l_party_site_id;');
8277: l(' l_max_idx := l_match_idx;');
8278: FOR TX IN (
8279: SELECT distinct f.staged_attribute_column
8280: FROM hz_trans_functions_vl f, hz_secondary_trans st,
8281: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
8282: WHERE sa.match_rule_id = p_rule_id
8283: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
8284: AND st.function_id = f.function_id

Line 8313: FROM hz_trans_functions_vl f, hz_secondary_trans st,

8309: l(' l_max_id := l_org_contact_id;');
8310: l(' l_max_idx := l_match_idx;');
8311: FOR TX IN (
8312: SELECT distinct f.staged_attribute_column
8313: FROM hz_trans_functions_vl f, hz_secondary_trans st,
8314: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
8315: WHERE sa.match_rule_id = p_rule_id
8316: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
8317: AND st.function_id = f.function_id

Line 8350: FROM hz_trans_functions_vl f, hz_secondary_trans st,

8346: l(' l_max_id := l_contact_pt_id;');
8347: l(' l_max_idx := l_match_idx;');
8348: FOR TX IN (
8349: SELECT distinct f.staged_attribute_column
8350: FROM hz_trans_functions_vl f, hz_secondary_trans st,
8351: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
8352: WHERE sa.match_rule_id = p_rule_id
8353: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
8354: AND st.function_id = f.function_id

Line 8824: FROM hz_trans_functions_vl f, hz_secondary_trans st,

8820: l(' FUNCTION GET_PARTY_SCORE ');
8821: FIRST := TRUE;
8822: FOR TX IN (
8823: SELECT f.staged_attribute_column
8824: FROM hz_trans_functions_vl f, hz_secondary_trans st,
8825: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
8826: WHERE sa.match_rule_id = p_rule_id
8827: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
8828: AND st.function_id = f.function_id

Line 8862: FROM HZ_SECONDARY_TRANS s,

8858: FIRST := TRUE;
8859: FOR SECTRANS IN (
8860: SELECT TRANSFORMATION_NAME, STAGED_ATTRIBUTE_COLUMN, f.FUNCTION_ID,
8861: TRANSFORMATION_WEIGHT, SIMILARITY_CUTOFF
8862: FROM HZ_SECONDARY_TRANS s,
8863: HZ_TRANS_FUNCTIONS_VL f
8864: WHERE s.SECONDARY_ATTRIBUTE_ID = SECATTRS.SECONDARY_ATTRIBUTE_ID
8865: AND s.FUNCTION_ID = f.FUNCTION_ID
8866: ORDER BY TRANSFORMATION_WEIGHT desc) LOOP

Line 9707: FROM hz_trans_functions_vl f, hz_secondary_trans st,

9703: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
9704: l('');
9705: FOR TX IN (
9706: SELECT distinct f.staged_attribute_column
9707: FROM hz_trans_functions_vl f, hz_secondary_trans st,
9708: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
9709: WHERE sa.match_rule_id = p_rule_id
9710: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
9711: AND st.function_id = f.function_id

Line 10442: FROM hz_trans_functions_vl f, hz_secondary_trans st,

10438: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
10439: l('');
10440: FOR TX IN (
10441: SELECT distinct f.staged_attribute_column
10442: FROM hz_trans_functions_vl f, hz_secondary_trans st,
10443: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
10444: WHERE sa.match_rule_id = p_rule_id
10445: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
10446: AND st.function_id = f.function_id

Line 11837: FROM hz_trans_functions_vl f, hz_secondary_trans st,

11833: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
11834: l('');
11835: FOR TX IN (
11836: SELECT distinct f.staged_attribute_column
11837: FROM hz_trans_functions_vl f, hz_secondary_trans st,
11838: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
11839: WHERE sa.match_rule_id = p_rule_id
11840: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
11841: AND st.function_id = f.function_id

Line 12078: FROM hz_trans_functions_vl f, hz_secondary_trans st,

12074: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
12075: l('');
12076: FOR TX IN (
12077: SELECT distinct f.staged_attribute_column
12078: FROM hz_trans_functions_vl f, hz_secondary_trans st,
12079: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
12080: WHERE sa.match_rule_id = p_rule_id
12081: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
12082: AND st.function_id = f.function_id

Line 12310: FROM hz_trans_functions_vl f, hz_secondary_trans st,

12306: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
12307: l('');
12308: FOR TX IN (
12309: SELECT distinct f.staged_attribute_column
12310: FROM hz_trans_functions_vl f, hz_secondary_trans st,
12311: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
12312: WHERE sa.match_rule_id = p_rule_id
12313: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
12314: AND st.function_id = f.function_id

Line 12476: FROM hz_trans_functions_vl f, hz_secondary_trans st,

12472: l(' l_search_ctx_id NUMBER; -- Generated Search Context ID');
12473: l('');
12474: FOR TX IN (
12475: SELECT distinct f.staged_attribute_column
12476: FROM hz_trans_functions_vl f, hz_secondary_trans st,
12477: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
12478: WHERE sa.match_rule_id = p_rule_id
12479: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
12480: AND st.function_id = f.function_id

Line 12566: FROM hz_trans_functions_vl f, hz_secondary_trans st,

12562: l(' l_max_id := l_party_site_id;');
12563: l(' l_max_idx := l_match_idx;');
12564: FOR TX IN (
12565: SELECT distinct f.staged_attribute_column
12566: FROM hz_trans_functions_vl f, hz_secondary_trans st,
12567: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
12568: WHERE sa.match_rule_id = p_rule_id
12569: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
12570: AND st.function_id = f.function_id

Line 12599: FROM hz_trans_functions_vl f, hz_secondary_trans st,

12595: l(' l_max_id := l_org_contact_id;');
12596: l(' l_max_idx := l_match_idx;');
12597: FOR TX IN (
12598: SELECT distinct f.staged_attribute_column
12599: FROM hz_trans_functions_vl f, hz_secondary_trans st,
12600: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
12601: WHERE sa.match_rule_id = p_rule_id
12602: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
12603: AND st.function_id = f.function_id

Line 12632: FROM hz_trans_functions_vl f, hz_secondary_trans st,

12628: l(' l_max_id := l_contact_pt_id;');
12629: l(' l_max_idx := l_match_idx;');
12630: FOR TX IN (
12631: SELECT distinct f.staged_attribute_column
12632: FROM hz_trans_functions_vl f, hz_secondary_trans st,
12633: hz_match_rule_secondary sa, HZ_TRANS_ATTRIBUTES_VL a
12634: WHERE sa.match_rule_id = p_rule_id
12635: AND st.SECONDARY_ATTRIBUTE_ID = sa.SECONDARY_ATTRIBUTE_ID
12636: AND st.function_id = f.function_id

Line 12839: HZ_SECONDARY_TRANS sfunc

12835: f.STAGED_ATTRIBUTE_COLUMN
12836: FROM HZ_TRANS_FUNCTIONS_VL f,
12837: HZ_TRANS_ATTRIBUTES_VL a,
12838: HZ_MATCH_RULE_SECONDARY sattr,
12839: HZ_SECONDARY_TRANS sfunc
12840: WHERE sattr.MATCH_RULE_ID = p_rule_id
12841: AND sattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
12842: AND a.ENTITY_NAME = 'PARTY'
12843: AND sattr.SECONDARY_ATTRIBUTE_ID = sfunc.SECONDARY_ATTRIBUTE_ID

Line 13054: HZ_SECONDARY_TRANS sfunc

13050: f.STAGED_ATTRIBUTE_COLUMN
13051: FROM HZ_TRANS_FUNCTIONS_VL f,
13052: HZ_TRANS_ATTRIBUTES_VL a,
13053: HZ_MATCH_RULE_SECONDARY sattr,
13054: HZ_SECONDARY_TRANS sfunc
13055: WHERE sattr.MATCH_RULE_ID = p_rule_id
13056: AND sattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
13057: AND a.ENTITY_NAME = p_entity
13058: AND sattr.SECONDARY_ATTRIBUTE_ID = sfunc.SECONDARY_ATTRIBUTE_ID

Line 13168: HZ_SECONDARY_TRANS sfunc

13164: SELECT a.ATTRIBUTE_ID, a.ATTRIBUTE_NAME
13165: FROM HZ_TRANS_FUNCTIONS_VL f,
13166: HZ_TRANS_ATTRIBUTES_VL a,
13167: HZ_MATCH_RULE_SECONDARY sattr,
13168: HZ_SECONDARY_TRANS sfunc
13169: WHERE sattr.MATCH_RULE_ID = p_rule_id
13170: AND sattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
13171: AND a.ENTITY_NAME = p_entity
13172: AND sattr.SECONDARY_ATTRIBUTE_ID = sfunc.SECONDARY_ATTRIBUTE_ID

Line 13300: HZ_SECONDARY_TRANS sfunc

13296: f.STAGED_ATTRIBUTE_COLUMN
13297: FROM HZ_TRANS_FUNCTIONS_VL f,
13298: HZ_TRANS_ATTRIBUTES_VL a,
13299: HZ_MATCH_RULE_SECONDARY sattr,
13300: HZ_SECONDARY_TRANS sfunc
13301: WHERE sattr.MATCH_RULE_ID = p_rule_id
13302: AND sattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
13303: AND a.ENTITY_NAME = p_entity
13304: AND sattr.SECONDARY_ATTRIBUTE_ID = sfunc.SECONDARY_ATTRIBUTE_ID

Line 13368: HZ_SECONDARY_TRANS sfunc

13364: f.STAGED_ATTRIBUTE_COLUMN
13365: FROM HZ_TRANS_FUNCTIONS_VL f,
13366: HZ_TRANS_ATTRIBUTES_VL a,
13367: HZ_MATCH_RULE_SECONDARY sattr,
13368: HZ_SECONDARY_TRANS sfunc
13369: WHERE sattr.MATCH_RULE_ID = p_rule_id
13370: AND sattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
13371: AND a.ENTITY_NAME = p_entity
13372: AND sattr.SECONDARY_ATTRIBUTE_ID = sfunc.SECONDARY_ATTRIBUTE_ID

Line 13523: HZ_SECONDARY_TRANS sfunc

13519: f.STAGED_ATTRIBUTE_COLUMN
13520: FROM HZ_TRANS_FUNCTIONS_VL f,
13521: HZ_TRANS_ATTRIBUTES_VL a,
13522: HZ_MATCH_RULE_SECONDARY sattr,
13523: HZ_SECONDARY_TRANS sfunc
13524: WHERE sattr.MATCH_RULE_ID = p_rule_id
13525: AND sattr.ATTRIBUTE_ID = a.ATTRIBUTE_ID
13526: AND a.ENTITY_NAME = 'PARTY'
13527: AND sattr.SECONDARY_ATTRIBUTE_ID = sfunc.SECONDARY_ATTRIBUTE_ID

Line 15056: FROM hz_secondary_trans f, hz_match_rule_secondary a

15052:
15053: UNION
15054:
15055: SELECT f.FUNCTION_ID
15056: FROM hz_secondary_trans f, hz_match_rule_secondary a
15057: WHERE a.MATCH_RULE_ID = p_rule_id
15058: AND a.SECONDARY_ATTRIBUTE_ID = f.SECONDARY_ATTRIBUTE_ID;
15059:
15060: ---Start of Code Change for Match Rule Set

Line 15073: FROM hz_secondary_trans f, hz_match_rule_secondary a

15069:
15070: UNION
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: )