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_PRIMARY

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 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 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 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 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 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 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 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 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 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 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 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