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 1757: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22

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

Line 1758: FROM HZ_STAGED_PARTY_SITES stage

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

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

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

Line 1767: FROM HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

Line 1797: FROM HZ_STAGED_PARTY_SITES stage

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

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

1812: hz_utility_v2pub.debug(p_message=>'Search context id is not null',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1813: END IF;
1814: IF p_person_api = 'Y' THEN
1815: OPEN x_cursor FOR
1816: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX22
1817: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1818: WHERE contains( concat_col, p_contains_str)>0
1819: AND( (l_search_merged ='Y' )
1820: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1817: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

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

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

Line 1840: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

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

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

Line 1885: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

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

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

Line 1895: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1910: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1927: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

APPS.HZ_MATCH_RULE_53 dependencies on HZ_STAGED_PARTY_SITES

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