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_2 dependencies on HZ_STAGED_CONTACT_POINTS

Line 1683: SELECT /+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) / CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID

1679: END IF;
1680: IF p_restrict_entity = 'CONTACTS'
1681: THEN
1682: OPEN x_cursor FOR
1683: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1684: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1685: WHERE contains( concat_col, p_contains_str)>0
1686: AND d.search_context_id = p_search_ctx_id
1687: AND( (l_search_merged ='Y' )

Line 1684: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1680: IF p_restrict_entity = 'CONTACTS'
1681: THEN
1682: OPEN x_cursor FOR
1683: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1684: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1685: WHERE contains( concat_col, p_contains_str)>0
1686: AND d.search_context_id = p_search_ctx_id
1687: AND( (l_search_merged ='Y' )
1688: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1695: SELECT /+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N3) / CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID

1691: END IF;
1692: IF p_restrict_entity = 'PARTY_SITES'
1693: THEN
1694: OPEN x_cursor FOR
1695: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N3) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1696: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1697: WHERE contains( concat_col, p_contains_str)>0
1698: AND d.search_context_id = p_search_ctx_id
1699: AND( (l_search_merged ='Y' )

Line 1696: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1692: IF p_restrict_entity = 'PARTY_SITES'
1693: THEN
1694: OPEN x_cursor FOR
1695: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N3) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1696: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1697: WHERE contains( concat_col, p_contains_str)>0
1698: AND d.search_context_id = p_search_ctx_id
1699: AND( (l_search_merged ='Y' )
1700: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1712: SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) / CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID

1708: hz_utility_v2pub.debug(p_message=>'Single Party Scenario',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1709: END IF;
1710: IF p_search_rel_cpts = 'N' THEN
1711: OPEN x_cursor FOR
1712: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1713: FROM HZ_STAGED_CONTACT_POINTS stage
1714: WHERE contains( concat_col, p_contains_str)>0
1715: AND( (l_search_merged ='Y' )
1716: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1713: FROM HZ_STAGED_CONTACT_POINTS stage

1709: END IF;
1710: IF p_search_rel_cpts = 'N' THEN
1711: OPEN x_cursor FOR
1712: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1713: FROM HZ_STAGED_CONTACT_POINTS stage
1714: WHERE contains( concat_col, p_contains_str)>0
1715: AND( (l_search_merged ='Y' )
1716: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1717: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1721: SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) / CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID

1717: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1718: AND stage.party_id = p_party_id;
1719: ELSE
1720: OPEN x_cursor FOR
1721: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1722: FROM HZ_STAGED_CONTACT_POINTS stage
1723: WHERE contains( concat_col, p_contains_str)>0
1724: AND( (l_search_merged ='Y' )
1725: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1722: FROM HZ_STAGED_CONTACT_POINTS stage

1718: AND stage.party_id = p_party_id;
1719: ELSE
1720: OPEN x_cursor FOR
1721: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1722: FROM HZ_STAGED_CONTACT_POINTS stage
1723: WHERE contains( concat_col, p_contains_str)>0
1724: AND( (l_search_merged ='Y' )
1725: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1726: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1729: SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) / stage.CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID

1725: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1726: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1727: AND stage.party_id = p_party_id
1728: UNION
1729: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ stage.CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID
1730: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
1731: WHERE contains( concat_col, p_contains_str)>0
1732: AND r.object_id = p_party_id
1733: AND( (l_search_merged ='Y' )

Line 1730: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc

1726: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1727: AND stage.party_id = p_party_id
1728: UNION
1729: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ stage.CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID
1730: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
1731: WHERE contains( concat_col, p_contains_str)>0
1732: AND r.object_id = p_party_id
1733: AND( (l_search_merged ='Y' )
1734: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1752: FROM HZ_STAGED_CONTACT_POINTS stage

1748: hz_utility_v2pub.debug(p_message=>'Either Search context id is null',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1749: END IF;
1750: OPEN x_cursor FOR
1751: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1752: FROM HZ_STAGED_CONTACT_POINTS stage
1753: WHERE contains( concat_col, p_contains_str)>0
1754: AND EXISTS (
1755: SELECT 1 FROM HZ_STAGED_PARTIES p
1756: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1771: SELECT /+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) / CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID

1767: hz_utility_v2pub.debug(p_message=>'Search_context_id is not null',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1768: END IF;
1769: IF p_person_api = 'Y' THEN
1770: OPEN x_cursor FOR
1771: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1772: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1773: WHERE contains( concat_col, p_contains_str)>0
1774: AND d.search_context_id = p_search_ctx_id
1775: AND d.party_id = stage.party_id

Line 1772: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1768: END IF;
1769: IF p_person_api = 'Y' THEN
1770: OPEN x_cursor FOR
1771: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1772: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1773: WHERE contains( concat_col, p_contains_str)>0
1774: AND d.search_context_id = p_search_ctx_id
1775: AND d.party_id = stage.party_id
1776: AND( (l_search_merged ='Y' )

Line 1781: SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) / CONTACT_POINT_ID, stage.contact_point_type, r.subject_id, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID

1777: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1778: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1779: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1780: UNION
1781: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, r.subject_id, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID
1782: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
1783: WHERE contains( concat_col, p_contains_str)>0
1784: AND d.search_context_id = p_search_ctx_id
1785: AND d.party_id = r.subject_id

Line 1782: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage

1778: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1779: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1780: UNION
1781: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, r.subject_id, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID
1782: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
1783: WHERE contains( concat_col, p_contains_str)>0
1784: AND d.search_context_id = p_search_ctx_id
1785: AND d.party_id = r.subject_id
1786: AND r.relationship_id = oc.party_relationship_id

Line 1794: SELECT /+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) / CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID

1790: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1791: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1792: ELSE
1793: OPEN x_cursor FOR
1794: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1795: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1796: WHERE contains( concat_col, p_contains_str)>0
1797: AND d.search_context_id = p_search_ctx_id
1798: AND d.party_id = stage.party_id

Line 1795: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1791: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1792: ELSE
1793: OPEN x_cursor FOR
1794: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1795: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1796: WHERE contains( concat_col, p_contains_str)>0
1797: AND d.search_context_id = p_search_ctx_id
1798: AND d.party_id = stage.party_id
1799: AND( (l_search_merged ='Y' )

Line 1815: l_hint := '/+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) /';

1811: IF (l_check_dt > 0 ) THEN
1812: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1813: hz_utility_v2pub.debug(p_message=>'Restrict Sql has the selective_cpt hint',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1814: END IF;
1815: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
1816: ELSIF (l_check > 0 ) THEN
1817: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1818: hz_utility_v2pub.debug(p_message=>'Restrict Sql has the selective hint',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1819: END IF;

Line 1820: l_hint := '/+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) /';

1816: ELSIF (l_check > 0 ) THEN
1817: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1818: hz_utility_v2pub.debug(p_message=>'Restrict Sql has the selective hint',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1819: END IF;
1820: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */';
1821: END IF;
1822: IF l_search_merged = 'Y' THEN
1823: l_status_sql := ' ' ;
1824: ELSIF l_search_merged = 'I' THEN

Line 1839: l_sqlstr := ' SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) / CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||

1835: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1836: ELSE
1837: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1838: END IF;
1839: l_sqlstr := ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
1840: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1841: ' WHERE contains( concat_col, :cont)>0 '||
1842: ' AND (stage.org_contact_id is null '||
1843: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 1840: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

1836: ELSE
1837: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1838: END IF;
1839: l_sqlstr := ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
1840: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1841: ' WHERE contains( concat_col, :cont)>0 '||
1842: ' AND (stage.org_contact_id is null '||
1843: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1844: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1849: ' SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) / CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||

1845: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1846: ' AND ('||p_restrict_sql||'))' ||
1847: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1848: ' UNION ' ||
1849: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
1850: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1851: ' WHERE contains( concat_col, :cont)>0 '||
1852: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1853: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1850: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

1846: ' AND ('||p_restrict_sql||'))' ||
1847: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1848: ' UNION ' ||
1849: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
1850: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1851: ' WHERE contains( concat_col, :cont)>0 '||
1852: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1853: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1854: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1865: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

1861: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1862: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1863: ELSE
1864: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
1865: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1866: ' WHERE contains( concat_col, :cont)>0'||
1867: ' AND EXISTS ('||
1868: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1869: ' WHERE p.party_id = stage.party_id ' ||

Line 1882: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

1878: ,p_dup_party_id, p_dup_party_id;
1879: END IF;
1880: ELSE
1881: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
1882: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1883: ' WHERE contains( concat_col, :cont)>0'||
1884: ' AND EXISTS ('||
1885: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1886: ' WHERE p.party_id = stage.party_id ' ||

APPS.HZ_MATCH_RULE_2 dependencies on HZ_STAGED_CONTACT_POINTS

Line 1683: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID

Line 1684: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

Line 1695: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N3) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID