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

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

Line 1693: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

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

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

Line 1705: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

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: 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);
1718: END IF;
1719: IF p_search_rel_cpts = 'N' THEN
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: END IF;
1719: IF p_search_rel_cpts = 'N' THEN
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 1730: SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) / CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID

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

Line 1731: FROM HZ_STAGED_CONTACT_POINTS stage

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

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

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

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

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

Line 1761: FROM HZ_STAGED_CONTACT_POINTS stage

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

Line 1781: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1777: END IF;
1778: IF p_person_api = 'Y' THEN
1779: OPEN x_cursor FOR
1780: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1781: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1782: WHERE contains( concat_col, p_contains_str)>0
1783: AND d.search_context_id = p_search_ctx_id
1784: AND d.party_id = stage.party_id
1785: AND( (l_search_merged ='Y' )

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

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

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

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

Line 1804: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1800: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1801: ELSE
1802: OPEN x_cursor FOR
1803: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1804: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1805: WHERE contains( concat_col, p_contains_str)>0
1806: AND d.search_context_id = p_search_ctx_id
1807: AND d.party_id = stage.party_id
1808: AND( (l_search_merged ='Y' )

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

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

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

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

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

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

Line 1849: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

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

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

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

Line 1859: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

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

Line 1874: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

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

Line 1891: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

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