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_8 dependencies on HZ_STAGED_PARTY_SITES

Line 1756: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15

1752: 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);
1753: END IF;
1754: IF p_search_rel_sites = 'N' THEN
1755: OPEN x_cursor FOR
1756: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15
1757: FROM HZ_STAGED_PARTY_SITES stage
1758: WHERE contains( concat_col, p_contains_str)>0
1759: AND( (l_search_merged ='Y' )
1760: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1757: FROM HZ_STAGED_PARTY_SITES stage

1753: END IF;
1754: IF p_search_rel_sites = 'N' THEN
1755: OPEN x_cursor FOR
1756: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15
1757: FROM HZ_STAGED_PARTY_SITES stage
1758: WHERE contains( concat_col, p_contains_str)>0
1759: AND( (l_search_merged ='Y' )
1760: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1761: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1765: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15

1761: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1762: AND stage.party_id = p_party_id;
1763: ELSE
1764: OPEN x_cursor FOR
1765: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15
1766: FROM HZ_STAGED_PARTY_SITES stage
1767: WHERE contains( concat_col, p_contains_str)>0
1768: AND( (l_search_merged ='Y' )
1769: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1766: FROM HZ_STAGED_PARTY_SITES stage

1762: AND stage.party_id = p_party_id;
1763: ELSE
1764: OPEN x_cursor FOR
1765: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15
1766: FROM HZ_STAGED_PARTY_SITES stage
1767: WHERE contains( concat_col, p_contains_str)>0
1768: AND( (l_search_merged ='Y' )
1769: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1770: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1773: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15

1769: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1770: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1771: AND stage.party_id = p_party_id
1772: UNION
1773: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15
1774: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1775: WHERE contains( concat_col, p_contains_str)>0
1776: AND( (l_search_merged ='Y' )
1777: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1774: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc

1770: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1771: AND stage.party_id = p_party_id
1772: UNION
1773: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15
1774: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1775: WHERE contains( concat_col, p_contains_str)>0
1776: AND( (l_search_merged ='Y' )
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') )

Line 1796: FROM HZ_STAGED_PARTY_SITES stage

1792: hz_utility_v2pub.debug(p_message=>'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);
1793: END IF;
1794: OPEN x_cursor FOR
1795: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15
1796: FROM HZ_STAGED_PARTY_SITES stage
1797: WHERE contains( concat_col, p_contains_str)>0
1798: AND EXISTS (
1799: SELECT 1 FROM HZ_STAGED_PARTIES p
1800: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1816: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1812: END IF;
1813: IF p_person_api = 'Y' THEN
1814: OPEN x_cursor FOR
1815: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15
1816: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1817: WHERE contains( concat_col, p_contains_str)>0
1818: AND( (l_search_merged ='Y' )
1819: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1820: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1825: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15

1821: AND d.search_context_id = p_search_ctx_id
1822: AND d.party_id = stage.party_id
1823: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1824: UNION
1825: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15
1826: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1827: WHERE contains( concat_col, p_contains_str)>0
1828: AND( (l_search_merged ='Y' )
1829: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1826: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage

1822: AND d.party_id = stage.party_id
1823: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1824: UNION
1825: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15
1826: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1827: WHERE contains( concat_col, p_contains_str)>0
1828: AND( (l_search_merged ='Y' )
1829: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1830: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1839: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1835: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1836: ELSE
1837: OPEN x_cursor FOR
1838: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15
1839: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1840: WHERE contains( concat_col, p_contains_str)>0
1841: AND( (l_search_merged ='Y' )
1842: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1843: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1859: l_hint := '/+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) /';

1855: IF (l_check_dt > 0 ) THEN
1856: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1857: hz_utility_v2pub.debug(p_message=>'Restrict sql has the selective_ps hint',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1858: END IF;
1859: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
1860: ELSIF (l_check > 0 ) THEN
1861: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1862: 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);
1863: END IF;

Line 1864: l_hint := '/+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) /';

1860: ELSIF (l_check > 0 ) THEN
1861: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1862: 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);
1863: END IF;
1864: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */';
1865: END IF;
1866: IF l_search_merged = 'Y' THEN
1867: l_status_sql := ' ' ;
1868: ELSIF l_search_merged = 'I' THEN

Line 1883: l_sqlstr := 'SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX14, TX15'||

1879: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1880: ELSE
1881: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1882: END IF;
1883: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX14, TX15'||
1884: ' FROM HZ_STAGED_PARTY_SITES stage'||
1885: ' WHERE contains( concat_col, :cont)>0'||
1886: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1887: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1884: ' FROM HZ_STAGED_PARTY_SITES stage'||

1880: ELSE
1881: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1882: END IF;
1883: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX14, TX15'||
1884: ' FROM HZ_STAGED_PARTY_SITES stage'||
1885: ' WHERE contains( concat_col, :cont)>0'||
1886: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1887: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1888: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1893: 'SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX14, TX15'||

1889: ' AND (ORG_CONTACT_ID IS NULL ' ||
1890: ' AND ('||p_restrict_sql||'))' ||
1891: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1892: ' UNION ' ||
1893: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX14, TX15'||
1894: ' FROM HZ_STAGED_PARTY_SITES stage'||
1895: ' WHERE contains( concat_col, :cont)>0'||
1896: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1897: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1894: ' FROM HZ_STAGED_PARTY_SITES stage'||

1890: ' AND ('||p_restrict_sql||'))' ||
1891: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1892: ' UNION ' ||
1893: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX14, TX15'||
1894: ' FROM HZ_STAGED_PARTY_SITES stage'||
1895: ' WHERE contains( concat_col, :cont)>0'||
1896: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1897: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1898: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1909: ' FROM HZ_STAGED_PARTY_SITES stage'||

1905: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1906: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1907: ELSE
1908: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX14, TX15'||
1909: ' FROM HZ_STAGED_PARTY_SITES stage'||
1910: ' WHERE contains( concat_col, :cont)>0'||
1911: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1912: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1913: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1926: ' FROM HZ_STAGED_PARTY_SITES stage'||

1922: ,p_dup_party_id, p_dup_party_id;
1923: END IF;
1924: ELSE
1925: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX14, TX15'||
1926: ' FROM HZ_STAGED_PARTY_SITES stage'||
1927: ' WHERE contains( concat_col, :cont)>0'||
1928: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1929: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1930: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||