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

1681: END IF;
1682: IF p_restrict_entity = 'CONTACTS'
1683: THEN
1684: OPEN x_cursor FOR
1685: 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: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1687: WHERE contains( concat_col, p_contains_str)>0
1688: AND d.search_context_id = p_search_ctx_id
1689: AND( (l_search_merged ='Y' )

Line 1686: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

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

1693: END IF;
1694: IF p_restrict_entity = 'PARTY_SITES'
1695: THEN
1696: OPEN x_cursor FOR
1697: 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: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1699: WHERE contains( concat_col, p_contains_str)>0
1700: AND d.search_context_id = p_search_ctx_id
1701: AND( (l_search_merged ='Y' )

Line 1698: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

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

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

Line 1715: FROM HZ_STAGED_CONTACT_POINTS stage

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

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

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

Line 1724: FROM HZ_STAGED_CONTACT_POINTS stage

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

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

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

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

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

Line 1754: FROM HZ_STAGED_CONTACT_POINTS stage

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

Line 1774: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

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

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

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

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

Line 1797: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

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

1813: IF (l_check_dt > 0 ) THEN
1814: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1815: 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);
1816: END IF;
1817: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
1818: ELSIF (l_check > 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 hint',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1821: END IF;

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

1818: ELSIF (l_check > 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 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_N1) */';
1823: END IF;
1824: IF l_search_merged = 'Y' THEN
1825: l_status_sql := ' ' ;
1826: ELSIF l_search_merged = 'I' THEN

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

1837: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1838: ELSE
1839: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1840: END IF;
1841: 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: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1843: ' WHERE contains( concat_col, :cont)>0 '||
1844: ' AND (stage.org_contact_id is null '||
1845: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 1842: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

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

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

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

Line 1852: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

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

Line 1867: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

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

Line 1884: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

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