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

Line 1690: 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

1686: END IF;
1687: IF p_restrict_entity = 'CONTACTS'
1688: THEN
1689: OPEN x_cursor FOR
1690: 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
1691: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1692: WHERE contains( concat_col, p_contains_str)>0
1693: AND d.search_context_id = p_search_ctx_id
1694: AND( (l_search_merged ='Y' )

Line 1691: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1687: IF p_restrict_entity = 'CONTACTS'
1688: THEN
1689: OPEN x_cursor FOR
1690: 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
1691: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1692: WHERE contains( concat_col, p_contains_str)>0
1693: AND d.search_context_id = p_search_ctx_id
1694: AND( (l_search_merged ='Y' )
1695: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1702: 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

1698: END IF;
1699: IF p_restrict_entity = 'PARTY_SITES'
1700: THEN
1701: OPEN x_cursor FOR
1702: 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
1703: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1704: WHERE contains( concat_col, p_contains_str)>0
1705: AND d.search_context_id = p_search_ctx_id
1706: AND( (l_search_merged ='Y' )

Line 1703: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1699: IF p_restrict_entity = 'PARTY_SITES'
1700: THEN
1701: OPEN x_cursor FOR
1702: 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
1703: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1704: WHERE contains( concat_col, p_contains_str)>0
1705: AND d.search_context_id = p_search_ctx_id
1706: AND( (l_search_merged ='Y' )
1707: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1715: 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);
1716: END IF;
1717: IF p_search_rel_cpts = 'N' THEN
1718: OPEN x_cursor FOR
1719: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1720: FROM HZ_STAGED_CONTACT_POINTS stage
1721: WHERE contains( concat_col, p_contains_str)>0
1722: AND( (l_search_merged ='Y' )
1723: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1720: FROM HZ_STAGED_CONTACT_POINTS stage

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

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

1724: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1725: AND stage.party_id = p_party_id;
1726: ELSE
1727: OPEN x_cursor FOR
1728: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1729: FROM HZ_STAGED_CONTACT_POINTS stage
1730: WHERE contains( concat_col, p_contains_str)>0
1731: AND( (l_search_merged ='Y' )
1732: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1729: FROM HZ_STAGED_CONTACT_POINTS stage

1725: AND stage.party_id = p_party_id;
1726: ELSE
1727: OPEN x_cursor FOR
1728: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1729: FROM HZ_STAGED_CONTACT_POINTS stage
1730: WHERE contains( concat_col, p_contains_str)>0
1731: AND( (l_search_merged ='Y' )
1732: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1733: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1736: 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

1732: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1733: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1734: AND stage.party_id = p_party_id
1735: UNION
1736: 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
1737: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
1738: WHERE contains( concat_col, p_contains_str)>0
1739: AND r.object_id = p_party_id
1740: AND( (l_search_merged ='Y' )

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

1733: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1734: AND stage.party_id = p_party_id
1735: UNION
1736: 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
1737: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
1738: WHERE contains( concat_col, p_contains_str)>0
1739: AND r.object_id = p_party_id
1740: AND( (l_search_merged ='Y' )
1741: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1759: FROM HZ_STAGED_CONTACT_POINTS stage

1755: 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);
1756: END IF;
1757: OPEN x_cursor FOR
1758: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1759: FROM HZ_STAGED_CONTACT_POINTS stage
1760: WHERE contains( concat_col, p_contains_str)>0
1761: AND EXISTS (
1762: SELECT 1 FROM HZ_STAGED_PARTIES p
1763: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1778: 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

1774: 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);
1775: END IF;
1776: IF p_person_api = 'Y' THEN
1777: OPEN x_cursor FOR
1778: 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
1779: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1780: WHERE contains( concat_col, p_contains_str)>0
1781: AND d.search_context_id = p_search_ctx_id
1782: AND d.party_id = stage.party_id

Line 1779: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1775: END IF;
1776: IF p_person_api = 'Y' THEN
1777: OPEN x_cursor FOR
1778: 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
1779: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1780: WHERE contains( concat_col, p_contains_str)>0
1781: AND d.search_context_id = p_search_ctx_id
1782: AND d.party_id = stage.party_id
1783: AND( (l_search_merged ='Y' )

Line 1788: 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

1784: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1785: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1786: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1787: UNION
1788: 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
1789: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
1790: WHERE contains( concat_col, p_contains_str)>0
1791: AND d.search_context_id = p_search_ctx_id
1792: AND d.party_id = r.subject_id

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

1785: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1786: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1787: UNION
1788: 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
1789: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
1790: WHERE contains( concat_col, p_contains_str)>0
1791: AND d.search_context_id = p_search_ctx_id
1792: AND d.party_id = r.subject_id
1793: AND r.relationship_id = oc.party_relationship_id

Line 1801: 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

1797: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1798: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1799: ELSE
1800: OPEN x_cursor FOR
1801: 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
1802: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1803: WHERE contains( concat_col, p_contains_str)>0
1804: AND d.search_context_id = p_search_ctx_id
1805: AND d.party_id = stage.party_id

Line 1802: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1798: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1799: ELSE
1800: OPEN x_cursor FOR
1801: 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
1802: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1803: WHERE contains( concat_col, p_contains_str)>0
1804: AND d.search_context_id = p_search_ctx_id
1805: AND d.party_id = stage.party_id
1806: AND( (l_search_merged ='Y' )

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

1818: IF (l_check_dt > 0 ) THEN
1819: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1820: 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);
1821: END IF;
1822: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
1823: ELSIF (l_check > 0 ) THEN
1824: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1825: 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);
1826: END IF;

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

1823: ELSIF (l_check > 0 ) THEN
1824: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1825: 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);
1826: END IF;
1827: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */';
1828: END IF;
1829: IF l_search_merged = 'Y' THEN
1830: l_status_sql := ' ' ;
1831: ELSIF l_search_merged = 'I' THEN

Line 1846: 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 '||

1842: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1843: ELSE
1844: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1845: END IF;
1846: 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 '||
1847: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1848: ' WHERE contains( concat_col, :cont)>0 '||
1849: ' AND (stage.org_contact_id is null '||
1850: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 1847: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

1843: ELSE
1844: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1845: END IF;
1846: 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 '||
1847: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1848: ' WHERE contains( concat_col, :cont)>0 '||
1849: ' AND (stage.org_contact_id is null '||
1850: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1851: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

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

Line 1857: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

1853: ' AND ('||p_restrict_sql||'))' ||
1854: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1855: ' UNION ' ||
1856: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
1857: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1858: ' WHERE contains( concat_col, :cont)>0 '||
1859: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1860: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1861: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1872: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

1868: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1869: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1870: ELSE
1871: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
1872: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1873: ' WHERE contains( concat_col, :cont)>0'||
1874: ' AND EXISTS ('||
1875: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1876: ' WHERE p.party_id = stage.party_id ' ||

Line 1889: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

1885: ,p_dup_party_id, p_dup_party_id;
1886: END IF;
1887: ELSE
1888: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
1889: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1890: ' WHERE contains( concat_col, :cont)>0'||
1891: ' AND EXISTS ('||
1892: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1893: ' WHERE p.party_id = stage.party_id ' ||

APPS.HZ_MATCH_RULE_4 dependencies on HZ_STAGED_CONTACT_POINTS

Line 1690: 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 1691: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

Line 1702: 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