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

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

Line 1755: FROM HZ_STAGED_PARTY_SITES stage

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

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

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

Line 1764: FROM HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

Line 1794: FROM HZ_STAGED_PARTY_SITES stage

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

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

1809: 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);
1810: END IF;
1811: IF p_person_api = 'Y' THEN
1812: OPEN x_cursor FOR
1813: 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
1814: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1815: WHERE contains( concat_col, p_contains_str)>0
1816: AND( (l_search_merged ='Y' )
1817: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1814: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1810: END IF;
1811: IF p_person_api = 'Y' THEN
1812: OPEN x_cursor FOR
1813: 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
1814: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1815: WHERE contains( concat_col, p_contains_str)>0
1816: AND( (l_search_merged ='Y' )
1817: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1818: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

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

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

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

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

1832: AND oc.org_contact_id = stage.org_contact_id
1833: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1834: ELSE
1835: OPEN x_cursor FOR
1836: 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
1837: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1838: WHERE contains( concat_col, p_contains_str)>0
1839: AND( (l_search_merged ='Y' )
1840: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1837: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1833: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1834: ELSE
1835: OPEN x_cursor FOR
1836: 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
1837: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1838: WHERE contains( concat_col, p_contains_str)>0
1839: AND( (l_search_merged ='Y' )
1840: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1841: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1853: IF (l_check_dt > 0 ) THEN
1854: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1855: 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);
1856: END IF;
1857: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
1858: ELSIF (l_check > 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 hint',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1861: END IF;

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

1858: ELSIF (l_check > 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 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_N1) */';
1863: END IF;
1864: IF l_search_merged = 'Y' THEN
1865: l_status_sql := ' ' ;
1866: ELSIF l_search_merged = 'I' THEN

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

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

Line 1882: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

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

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

Line 1892: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1907: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 1924: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

APPS.HZ_MATCH_RULE_8 dependencies on HZ_STAGED_PARTY_SITES

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