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

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

1673: END IF;
1674: IF p_restrict_entity = 'CONTACTS'
1675: THEN
1676: OPEN x_cursor FOR
1677: 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
1678: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1679: WHERE contains( concat_col, p_contains_str)>0
1680: AND d.search_context_id = p_search_ctx_id
1681: AND( (l_search_merged ='Y' )

Line 1678: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1674: IF p_restrict_entity = 'CONTACTS'
1675: THEN
1676: OPEN x_cursor FOR
1677: 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
1678: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1679: WHERE contains( concat_col, p_contains_str)>0
1680: AND d.search_context_id = p_search_ctx_id
1681: AND( (l_search_merged ='Y' )
1682: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

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

Line 1690: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

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

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

1702: 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);
1703: END IF;
1704: IF p_search_rel_cpts = 'N' THEN
1705: OPEN x_cursor FOR
1706: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1707: FROM HZ_STAGED_CONTACT_POINTS stage
1708: WHERE contains( concat_col, p_contains_str)>0
1709: AND( (l_search_merged ='Y' )
1710: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1707: FROM HZ_STAGED_CONTACT_POINTS stage

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

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

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

Line 1716: FROM HZ_STAGED_CONTACT_POINTS stage

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

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

1719: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1720: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1721: AND stage.party_id = p_party_id
1722: UNION
1723: 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
1724: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
1725: WHERE contains( concat_col, p_contains_str)>0
1726: AND r.object_id = p_party_id
1727: AND( (l_search_merged ='Y' )

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

1720: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1721: AND stage.party_id = p_party_id
1722: UNION
1723: 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
1724: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
1725: WHERE contains( concat_col, p_contains_str)>0
1726: AND r.object_id = p_party_id
1727: AND( (l_search_merged ='Y' )
1728: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1746: FROM HZ_STAGED_CONTACT_POINTS stage

1742: 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);
1743: END IF;
1744: OPEN x_cursor FOR
1745: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1746: FROM HZ_STAGED_CONTACT_POINTS stage
1747: WHERE contains( concat_col, p_contains_str)>0
1748: AND EXISTS (
1749: SELECT 1 FROM HZ_STAGED_PARTIES p
1750: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1766: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1762: END IF;
1763: IF p_person_api = 'Y' THEN
1764: OPEN x_cursor FOR
1765: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1766: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1767: WHERE contains( concat_col, p_contains_str)>0
1768: AND d.search_context_id = p_search_ctx_id
1769: AND d.party_id = stage.party_id
1770: AND( (l_search_merged ='Y' )

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

1771: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1772: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1773: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1774: UNION
1775: 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
1776: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
1777: WHERE contains( concat_col, p_contains_str)>0
1778: AND d.search_context_id = p_search_ctx_id
1779: AND d.party_id = r.subject_id

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

1772: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1773: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1774: UNION
1775: 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
1776: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
1777: WHERE contains( concat_col, p_contains_str)>0
1778: AND d.search_context_id = p_search_ctx_id
1779: AND d.party_id = r.subject_id
1780: AND r.relationship_id = oc.party_relationship_id

Line 1789: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1785: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1786: ELSE
1787: OPEN x_cursor FOR
1788: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID
1789: FROM HZ_DQM_PARTIES_GT d, 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 = stage.party_id
1793: AND( (l_search_merged ='Y' )

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

1805: IF (l_check_dt > 0 ) THEN
1806: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1807: 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);
1808: END IF;
1809: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
1810: ELSIF (l_check > 0 ) THEN
1811: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1812: 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);
1813: END IF;

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

1810: ELSIF (l_check > 0 ) THEN
1811: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1812: 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);
1813: END IF;
1814: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */';
1815: END IF;
1816: IF l_search_merged = 'Y' THEN
1817: l_status_sql := ' ' ;
1818: ELSIF l_search_merged = 'I' THEN

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

1829: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1830: ELSE
1831: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1832: END IF;
1833: 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 '||
1834: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1835: ' WHERE contains( concat_col, :cont)>0 '||
1836: ' AND (stage.org_contact_id is null '||
1837: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 1834: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

1830: ELSE
1831: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1832: END IF;
1833: 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 '||
1834: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1835: ' WHERE contains( concat_col, :cont)>0 '||
1836: ' AND (stage.org_contact_id is null '||
1837: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1838: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

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

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

Line 1844: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

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

Line 1859: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

1855: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1856: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1857: ELSE
1858: l_sqlstr := 'SELECT ' || l_hint ||' 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 EXISTS ('||
1862: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1863: ' WHERE p.party_id = stage.party_id ' ||

Line 1876: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

1872: ,p_dup_party_id, p_dup_party_id;
1873: END IF;
1874: ELSE
1875: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID '||
1876: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
1877: ' WHERE contains( concat_col, :cont)>0'||
1878: ' AND EXISTS ('||
1879: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
1880: ' WHERE p.party_id = stage.party_id ' ||