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_DQM_MR_PVT dependencies on HZ_MATCH_RULE_SECONDARY

Line 65: from hz_trans_attributes_vl a, hz_match_rule_secondary s

61: IS
62: select sum(sc) sum_score , max(sc) max_score , min(sc) min_score
63: from
64: (select entity_name ename, sum(score) sc
65: from hz_trans_attributes_vl a, hz_match_rule_secondary s
66: where s.match_rule_id = p_match_rule_id
67: and s.attribute_id = a.attribute_id
68: group by entity_name
69: order by sum(score) desc

Line 190: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a

186: temp BOOLEAN := FALSE ;
187: BEGIN
188: FOR attrs in (
189: SELECT s.attribute_id
190: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a
191: where a.attribute_id=s.attribute_id
192: and s.match_rule_id=p_match_rule_id
193: and a.entity_name = p_entity_name
194: )

Line 234: from hz_trans_attributes_vl a, hz_match_rule_secondary s

230: return number
231: IS
232: CURSOR entity_cur IS
233: select entity_name, sum(score) sc
234: from hz_trans_attributes_vl a, hz_match_rule_secondary s
235: where s.match_rule_id = p_match_rule_id
236: and s.attribute_id = a.attribute_id
237: group by entity_name
238: order by sum(score) desc ;

Line 481: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a

477:
478: l('-------' || p_entity || ' ENTITY: SCORING SECTION ---------');
479:
480: SELECT count(1) into outer_row_count
481: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a
482: where a.attribute_id=s.attribute_id
483: and s.match_rule_id=p_match_rule_id
484: and a.entity_name = p_entity;
485:

Line 491: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a

487: THEN
488: -- Generate the Secondary Attribute section of the query for the passed in entity
489: FOR attrs in (
490: SELECT score,s.attribute_id , secondary_attribute_id
491: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a
492: where a.attribute_id=s.attribute_id
493: and s.match_rule_id=p_match_rule_id
494: and a.entity_name = p_entity)
495: LOOP

Line 791: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a

787: l(' select /*+ ORDERED */ s1.party_id f, s2.party_id t,');
788:
789:
790: SELECT count(1) into outer_row_count
791: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a
792: where a.attribute_id=s.attribute_id
793: and s.match_rule_id=p_match_rule_id
794: and a.entity_name = p_entity;
795:

Line 802: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a

798:
799: -- Generate the Secondary Attribute section of the query for the passed in entity
800: FOR attrs in (
801: SELECT score,s.attribute_id , secondary_attribute_id
802: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a
803: where a.attribute_id=s.attribute_id
804: and s.match_rule_id=p_match_rule_id
805: and a.entity_name = p_entity)
806: LOOP

Line 984: from hz_trans_attributes_vl a, hz_match_rule_secondary s

980: 'PARTY_SITES', 'HZ_STAGED_PARTY_SITES',
981: 'CONTACTS','HZ_STAGED_CONTACTS',
982: 'CONTACT_POINTS', 'HZ_STAGED_CONTACT_POINTS') entity_table_name,
983: sum(score) sc, 'S' att_flag
984: from hz_trans_attributes_vl a, hz_match_rule_secondary s
985: where s.match_rule_id = p_match_rule_id
986: and s.attribute_id = a.attribute_id
987: group by entity_name
988: union all

Line 1296: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a

1292:
1293: l('-------' || p_entity || ' ENTITY: SCORING SECTION ---------');
1294:
1295: SELECT count(1) into outer_row_count
1296: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a
1297: where a.attribute_id=s.attribute_id
1298: and s.match_rule_id=p_match_rule_id
1299: and a.entity_name = p_entity;
1300:

Line 1306: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a

1302: THEN
1303: -- Generate the Secondary Attribute section of the query for the passed in entity
1304: FOR attrs in (
1305: SELECT score,s.attribute_id , secondary_attribute_id
1306: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a
1307: where a.attribute_id=s.attribute_id
1308: and s.match_rule_id=p_match_rule_id
1309: and a.entity_name = p_entity)
1310: LOOP

Line 1535: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a

1531: l(',created_by,creation_date,last_update_login,last_update_date,last_updated_by)');
1532: l('select /*+ USE_CONCAT */ s1.party_id f,');
1533:
1534: SELECT count(1) into outer_row_count
1535: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a
1536: where a.attribute_id=s.attribute_id
1537: and s.match_rule_id=p_match_rule_id
1538: and a.entity_name = p_entity;
1539:

Line 1545: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a

1541: THEN
1542: -- Generate the Secondary Attribute section of the query for the passed in entity
1543: FOR attrs in (
1544: SELECT score,s.attribute_id , secondary_attribute_id
1545: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a
1546: where a.attribute_id=s.attribute_id
1547: and s.match_rule_id=p_match_rule_id
1548: and a.entity_name = p_entity)
1549: LOOP

Line 1830: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a

1826: l(' select /*+ USE_CONCAT */ s1.party_id f, s2.party_id t,');
1827:
1828: -- Generate the Secondary Attribute section of the query for the passed in entity
1829: SELECT count(1) into outer_row_count
1830: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a
1831: where a.attribute_id=s.attribute_id
1832: and s.match_rule_id=p_match_rule_id
1833: and a.entity_name = p_entity;
1834:

Line 1841: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a

1837: THEN
1838:
1839: FOR attrs in (
1840: SELECT score,s.attribute_id , secondary_attribute_id
1841: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a
1842: where a.attribute_id=s.attribute_id
1843: and s.match_rule_id=p_match_rule_id
1844: and a.entity_name = p_entity)
1845: LOOP

Line 2086: from hz_trans_attributes_vl a, hz_match_rule_secondary s

2082: 'PARTY_SITES', 'PARTY_SITE_OS',
2083: 'CONTACTS','CONTACT_OS',
2084: 'CONTACT_POINTS', 'CONTACT_PT_OS') entity_os_name,
2085: sum(score) sc, 'S' att_flag
2086: from hz_trans_attributes_vl a, hz_match_rule_secondary s
2087: where s.match_rule_id = p_match_rule_id
2088: and s.attribute_id = a.attribute_id
2089: group by entity_name
2090: union all

Line 2407: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a

2403:
2404: l('-------' || p_entity || ' ENTITY: SCORING SECTION ---------');
2405:
2406: SELECT count(1) into outer_row_count
2407: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a
2408: where a.attribute_id=s.attribute_id
2409: and s.match_rule_id=p_match_rule_id
2410: and a.entity_name = p_entity;
2411:

Line 2417: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a

2413: THEN
2414: -- Generate the Secondary Attribute section of the query for the passed in entity
2415: FOR attrs in (
2416: SELECT score,s.attribute_id , secondary_attribute_id
2417: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a
2418: where a.attribute_id=s.attribute_id
2419: and s.match_rule_id=p_match_rule_id
2420: and a.entity_name = p_entity)
2421: LOOP

Line 2627: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a

2623: l('select /*+ USE_CONCAT */ p_batch_id, s1.' || p_entity_osr_name || ', s1.' || p_entity_os_name || ',');
2624: l('s2.' || p_entity_osr_name || ', s2.' || p_entity_os_name || ',');
2625: l('s1.party_osr, s2.party_os,' || '''' || p_entity || ''',');
2626: SELECT count(1) into outer_row_count
2627: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a
2628: where a.attribute_id=s.attribute_id
2629: and s.match_rule_id=p_match_rule_id
2630: and a.entity_name = p_entity;
2631:

Line 2637: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a

2633: THEN
2634: -- Generate the Secondary Attribute section of the query for the passed in entity
2635: FOR attrs in (
2636: SELECT score,s.attribute_id , secondary_attribute_id
2637: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a
2638: where a.attribute_id=s.attribute_id
2639: and s.match_rule_id=p_match_rule_id
2640: and a.entity_name = p_entity)
2641: LOOP

Line 2917: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a

2913: l(' select /*+ USE_CONCAT */ s1.party_osr f, s2.party_osr t,');
2914:
2915: -- Generate the Secondary Attribute section of the query for the passed in entity
2916: SELECT count(1) into outer_row_count
2917: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a
2918: where a.attribute_id=s.attribute_id
2919: and s.match_rule_id=p_match_rule_id
2920: and a.entity_name = p_entity;
2921:

Line 2927: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a

2923: THEN
2924:
2925: FOR attrs in (
2926: SELECT score,s.attribute_id , secondary_attribute_id
2927: FROM HZ_MATCH_RULE_SECONDARY s, HZ_TRANS_ATTRIBUTES_VL a
2928: where a.attribute_id=s.attribute_id
2929: and s.match_rule_id=p_match_rule_id
2930: and a.entity_name = p_entity)
2931: LOOP

Line 3145: from hz_trans_attributes_vl a, hz_match_rule_secondary s

3141: 'PARTY_SITES', 'PARTY_SITE_OS',
3142: 'CONTACTS','CONTACT_OS',
3143: 'CONTACT_POINTS', 'CONTACT_PT_OS') entity_os_name,
3144: sum(score) sc, 'S' att_flag
3145: from hz_trans_attributes_vl a, hz_match_rule_secondary s
3146: where s.match_rule_id = p_match_rule_id
3147: and s.attribute_id = a.attribute_id
3148: group by entity_name
3149: union all