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_TRANS_ATTRIBUTES_VL

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 148: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a

144: filter_count number := 0;
145: BEGIN
146:
147: SELECT count(1) into filter_count
148: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a
149: where p.match_rule_id=p_match_rule_id
150: and p.attribute_id=a.attribute_id
151: and a.entity_name = 'PARTY'
152: and p.filter_flag = 'Y';

Line 169: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a

165: filter_count number := 0;
166: BEGIN
167:
168: SELECT count(1) into filter_count
169: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a
170: where p.match_rule_id=p_match_rule_id
171: and p.attribute_id=a.attribute_id
172: and a.entity_name = p_entity_name
173: and p.filter_flag = 'Y';

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 564: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a

560: -- TAKE CARE OF NON-FILTER ATTRIBUTES FIRST
561: FIRST1 := TRUE;
562: FOR attrs in (
563: SELECT primary_attribute_id
564: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a
565: where p.match_rule_id=p_match_rule_id
566: and p.attribute_id=a.attribute_id
567: and a.entity_name = p_entity
568: and nvl(p.filter_flag,'N') = 'N' )

Line 618: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a

614: THEN
615: FIRST1 := TRUE;
616: FOR attrs in (
617: SELECT primary_attribute_id
618: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a
619: where p.match_rule_id=p_match_rule_id
620: and p.attribute_id=a.attribute_id
621: and a.entity_name = p_entity
622: and nvl(p.filter_flag,'N') = 'Y' )

Line 694: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a

690: l('WHERE p1.party_id = f and p2.party_id = t');
691: FIRST1 := TRUE;
692: FOR attrs in (
693: SELECT primary_attribute_id
694: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a
695: where p.match_rule_id=p_match_rule_id
696: and p.attribute_id=a.attribute_id
697: and a.entity_name = 'PARTY'
698: and nvl(p.filter_flag,'N') = 'Y' )

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 852: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a

848: FIRST1 := TRUE;
849: -- Generate the Primary Attribute section of the query for the passed in entity
850: FOR attrs in (
851: SELECT primary_attribute_id
852: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a
853: where p.match_rule_id=p_match_rule_id
854: and p.attribute_id=a.attribute_id
855: and a.entity_name = p_entity
856: and nvl(p.filter_flag,'N') = 'N' )

Line 904: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a

900: -- NOW TAKE CARE OF FILTER ATTRIBUTES FIRST
901: FIRST1 := TRUE;
902: FOR attrs in (
903: SELECT primary_attribute_id
904: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a
905: where p.match_rule_id=p_match_rule_id
906: and p.attribute_id=a.attribute_id
907: and a.entity_name = p_entity
908: and nvl(p.filter_flag,'N') = 'Y' )

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 995: from hz_trans_attributes_vl a, hz_match_rule_primary p

991: 'PARTY_SITES', 'HZ_STAGED_PARTY_SITES',
992: 'CONTACTS','HZ_STAGED_CONTACTS',
993: 'CONTACT_POINTS', 'HZ_STAGED_CONTACT_POINTS') entity_table_name,
994: 0 sc, 'P' att_flag
995: from hz_trans_attributes_vl a, hz_match_rule_primary p
996: where p.match_rule_id = p_match_rule_id
997: and p.attribute_id = a.attribute_id
998: group by entity_name
999: )

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 1393: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a

1389: FIRST1 := TRUE;
1390: -- Generate the Primary Attribute section of the query for the passed in entity
1391: FOR attrs in (
1392: SELECT primary_attribute_id
1393: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a
1394: where p.match_rule_id=p_match_rule_id
1395: and p.attribute_id=a.attribute_id
1396: and a.entity_name = p_entity
1397: and nvl(p.filter_flag,'N') = 'N' )

Line 1449: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a

1445: -- NOW TAKE CARE OF FILTER ATTRIBUTES
1446: FIRST1 := TRUE;
1447: FOR attrs in (
1448: SELECT primary_attribute_id
1449: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a
1450: where p.match_rule_id=p_match_rule_id
1451: and p.attribute_id=a.attribute_id
1452: and a.entity_name = p_entity
1453: and nvl(p.filter_flag,'N') = 'Y' )

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 1599: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a

1595: FIRST1 := TRUE;
1596: -- Generate the Primary Attribute section of the query for the passed in entity
1597: FOR attrs in (
1598: SELECT primary_attribute_id
1599: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a
1600: where p.match_rule_id=p_match_rule_id
1601: and p.attribute_id=a.attribute_id
1602: and a.entity_name = p_entity
1603: and nvl(p.filter_flag,'N') = 'N' )

Line 1651: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a

1647: -- NOW TAKE CARE OF FILTER ATTRIBUTES
1648: FIRST1 := TRUE;
1649: FOR attrs in (
1650: SELECT primary_attribute_id
1651: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a
1652: where p.match_rule_id=p_match_rule_id
1653: and p.attribute_id=a.attribute_id
1654: and a.entity_name = p_entity
1655: and nvl(p.filter_flag,'N') = 'Y'

Line 1739: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a

1735: l('and p2.party_id = t');
1736: FIRST1 := TRUE;
1737: FOR attrs in (
1738: SELECT primary_attribute_id
1739: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a
1740: where p.match_rule_id=p_match_rule_id
1741: and p.attribute_id=a.attribute_id
1742: and a.entity_name = 'PARTY'
1743: and nvl(p.filter_flag,'N') = 'Y'

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 1891: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a

1887: FIRST1 := TRUE;
1888: -- Generate the Primary Attribute section of the query for the passed in entity
1889: FOR attrs in (
1890: SELECT primary_attribute_id
1891: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a
1892: where p.match_rule_id=p_match_rule_id
1893: and p.attribute_id=a.attribute_id
1894: and a.entity_name = p_entity
1895: and nvl(p.filter_flag,'N') = 'N' )

Line 1943: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a

1939: -- NOW TAKE CARE OF FILTER ATTRIBUTES
1940: FIRST1 := TRUE;
1941: FOR attrs in (
1942: SELECT primary_attribute_id
1943: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a
1944: where p.match_rule_id=p_match_rule_id
1945: and p.attribute_id=a.attribute_id
1946: and a.entity_name = p_entity
1947: and nvl(p.filter_flag,'N') = 'Y'

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 2117: from hz_trans_attributes_vl a, hz_match_rule_primary p

2113: 'PARTY_SITES', 'PARTY_SITE_OS',
2114: 'CONTACTS','CONTACT_OS',
2115: 'CONTACT_POINTS', 'CONTACT_PT_OS') entity_os_name,
2116: 0 sc, 'P' att_flag
2117: from hz_trans_attributes_vl a, hz_match_rule_primary p
2118: where p.match_rule_id = p_match_rule_id
2119: and p.attribute_id = a.attribute_id
2120: group by entity_name
2121: ) where att_flag = p_att_flag

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 2484: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a

2480: FIRST1 := TRUE;
2481: -- Generate the Primary Attribute section of the query for the passed in entity
2482: FOR attrs in (
2483: SELECT primary_attribute_id
2484: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a
2485: where p.match_rule_id=p_match_rule_id
2486: and p.attribute_id=a.attribute_id
2487: and a.entity_name = p_entity
2488: and nvl(p.filter_flag,'N') = 'N' )

Line 2540: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a

2536:
2537: FIRST1 := TRUE;
2538: FOR attrs in (
2539: SELECT primary_attribute_id
2540: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a
2541: where p.match_rule_id=p_match_rule_id
2542: and p.attribute_id=a.attribute_id
2543: and a.entity_name = p_entity
2544: and nvl(p.filter_flag,'N') = 'Y' )

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 2698: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a

2694: FIRST1 := TRUE;
2695: -- Generate the Primary Attribute section of the query for the passed in entity
2696: FOR attrs in (
2697: SELECT primary_attribute_id
2698: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a
2699: where p.match_rule_id=p_match_rule_id
2700: and p.attribute_id=a.attribute_id
2701: and a.entity_name = p_entity
2702: and nvl(p.filter_flag,'N') = 'N' )

Line 2750: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a

2746: -- NOW TAKE CARE OF FILTER ATTRIBUTES
2747: FIRST1 := TRUE;
2748: FOR attrs in (
2749: SELECT primary_attribute_id
2750: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a
2751: where p.match_rule_id=p_match_rule_id
2752: and p.attribute_id=a.attribute_id
2753: and a.entity_name = p_entity
2754: and nvl(p.filter_flag,'N') = 'Y'

Line 2826: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a

2822: l('and p2.batch_id = p_batch_id and p2.party_osr = t and p2.party_os = tos');
2823: FIRST1 := TRUE;
2824: FOR attrs in (
2825: SELECT primary_attribute_id
2826: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a
2827: where p.match_rule_id=p_match_rule_id
2828: and p.attribute_id=a.attribute_id
2829: and a.entity_name = 'PARTY'
2830: and nvl(p.filter_flag,'N') = 'Y'

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 2987: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a

2983: FIRST1 := TRUE;
2984: -- Generate the Primary Attribute section of the query for the passed in entity
2985: FOR attrs in (
2986: SELECT primary_attribute_id
2987: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a
2988: where p.match_rule_id=p_match_rule_id
2989: and p.attribute_id=a.attribute_id
2990: and a.entity_name = p_entity
2991: and nvl(p.filter_flag,'N') = 'N' )

Line 3039: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a

3035: -- NOW TAKE CARE OF FILTER ATTRIBUTES
3036: FIRST1 := TRUE;
3037: FOR attrs in (
3038: SELECT primary_attribute_id
3039: FROM HZ_MATCH_RULE_PRIMARY p, HZ_TRANS_ATTRIBUTES_VL a
3040: where p.match_rule_id=p_match_rule_id
3041: and p.attribute_id=a.attribute_id
3042: and a.entity_name = p_entity
3043: and nvl(p.filter_flag,'N') = 'Y' )

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

Line 3171: from hz_trans_attributes_vl a, hz_match_rule_primary p

3167: 'PARTY_SITES', 'PARTY_SITE_OS',
3168: 'CONTACTS','CONTACT_OS',
3169: 'CONTACT_POINTS', 'CONTACT_PT_OS') entity_os_name,
3170: 0 sc, 'P' att_flag
3171: from hz_trans_attributes_vl a, hz_match_rule_primary p
3172: where p.match_rule_id = p_match_rule_id
3173: and p.attribute_id = a.attribute_id
3174: group by entity_name
3175: ) where att_flag = p_att_flag