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

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

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

Line 1760: FROM HZ_STAGED_PARTY_SITES stage

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

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

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

Line 1769: FROM HZ_STAGED_PARTY_SITES stage

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

Line 1776: 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, TX22

1772: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1773: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1774: AND stage.party_id = p_party_id
1775: UNION
1776: 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, TX22
1777: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1778: WHERE contains( concat_col, p_contains_str)>0
1779: AND( (l_search_merged ='Y' )
1780: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1773: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1774: AND stage.party_id = p_party_id
1775: UNION
1776: 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, TX22
1777: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1778: WHERE contains( concat_col, p_contains_str)>0
1779: AND( (l_search_merged ='Y' )
1780: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1781: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1799: FROM HZ_STAGED_PARTY_SITES stage

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

Line 1819: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

Line 1828: 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, TX22

1824: AND d.search_context_id = p_search_ctx_id
1825: AND d.party_id = stage.party_id
1826: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1827: UNION
1828: 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, TX22
1829: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1830: WHERE contains( concat_col, p_contains_str)>0
1831: AND( (l_search_merged ='Y' )
1832: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1825: AND d.party_id = stage.party_id
1826: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1827: UNION
1828: 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, TX22
1829: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1830: WHERE contains( concat_col, p_contains_str)>0
1831: AND( (l_search_merged ='Y' )
1832: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1833: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1842: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

1858: IF (l_check_dt > 0 ) THEN
1859: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1860: 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);
1861: END IF;
1862: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
1863: ELSIF (l_check > 0 ) THEN
1864: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1865: 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);
1866: END IF;

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

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

Line 1886: 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, TX22'||

1882: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1883: ELSE
1884: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1885: END IF;
1886: 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, TX22'||
1887: ' FROM HZ_STAGED_PARTY_SITES stage'||
1888: ' WHERE contains( concat_col, :cont)>0'||
1889: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1890: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1887: ' FROM HZ_STAGED_PARTY_SITES stage'||

1883: ELSE
1884: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1885: END IF;
1886: 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, TX22'||
1887: ' FROM HZ_STAGED_PARTY_SITES stage'||
1888: ' WHERE contains( concat_col, :cont)>0'||
1889: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1890: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1891: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

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

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

Line 1897: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1912: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1929: ' FROM HZ_STAGED_PARTY_SITES stage'||

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