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

Line 1744: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22

1740: 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);
1741: END IF;
1742: IF p_search_rel_sites = 'N' THEN
1743: OPEN x_cursor FOR
1744: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1745: FROM HZ_STAGED_PARTY_SITES stage
1746: WHERE contains( concat_col, p_contains_str)>0
1747: AND( (l_search_merged ='Y' )
1748: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1745: FROM HZ_STAGED_PARTY_SITES stage

1741: END IF;
1742: IF p_search_rel_sites = 'N' THEN
1743: OPEN x_cursor FOR
1744: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1745: FROM HZ_STAGED_PARTY_SITES stage
1746: WHERE contains( concat_col, p_contains_str)>0
1747: AND( (l_search_merged ='Y' )
1748: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1749: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1753: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22

1749: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1750: AND stage.party_id = p_party_id;
1751: ELSE
1752: OPEN x_cursor FOR
1753: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1754: FROM HZ_STAGED_PARTY_SITES stage
1755: WHERE contains( concat_col, p_contains_str)>0
1756: AND( (l_search_merged ='Y' )
1757: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1754: FROM HZ_STAGED_PARTY_SITES stage

1750: AND stage.party_id = p_party_id;
1751: ELSE
1752: OPEN x_cursor FOR
1753: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1754: FROM HZ_STAGED_PARTY_SITES stage
1755: WHERE contains( concat_col, p_contains_str)>0
1756: AND( (l_search_merged ='Y' )
1757: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1758: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1761: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22

1757: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1758: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1759: AND stage.party_id = p_party_id
1760: UNION
1761: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1762: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1763: WHERE contains( concat_col, p_contains_str)>0
1764: AND( (l_search_merged ='Y' )
1765: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1758: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1759: AND stage.party_id = p_party_id
1760: UNION
1761: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1762: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1763: WHERE contains( concat_col, p_contains_str)>0
1764: AND( (l_search_merged ='Y' )
1765: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1766: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1784: FROM HZ_STAGED_PARTY_SITES stage

1780: 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);
1781: END IF;
1782: OPEN x_cursor FOR
1783: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1784: FROM HZ_STAGED_PARTY_SITES stage
1785: WHERE contains( concat_col, p_contains_str)>0
1786: AND EXISTS (
1787: SELECT 1 FROM HZ_STAGED_PARTIES p
1788: WHERE p.PARTY_ID = stage.PARTY_ID

Line 1804: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1800: END IF;
1801: IF p_person_api = 'Y' THEN
1802: OPEN x_cursor FOR
1803: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1804: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1805: WHERE contains( concat_col, p_contains_str)>0
1806: AND( (l_search_merged ='Y' )
1807: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1808: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1813: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22

1809: AND d.search_context_id = p_search_ctx_id
1810: AND d.party_id = stage.party_id
1811: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1812: UNION
1813: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1814: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, 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_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage

1810: AND d.party_id = stage.party_id
1811: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1812: UNION
1813: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1814: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, 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 1827: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1823: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1824: ELSE
1825: OPEN x_cursor FOR
1826: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1827: FROM HZ_DQM_PARTIES_GT d, 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 1847: l_hint := '/+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) /';

1843: IF (l_check_dt > 0 ) THEN
1844: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1845: 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);
1846: END IF;
1847: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
1848: ELSIF (l_check > 0 ) THEN
1849: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1850: 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);
1851: END IF;

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

1848: ELSIF (l_check > 0 ) THEN
1849: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1850: 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);
1851: END IF;
1852: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */';
1853: END IF;
1854: IF l_search_merged = 'Y' THEN
1855: l_status_sql := ' ' ;
1856: ELSIF l_search_merged = 'I' THEN

Line 1871: l_sqlstr := 'SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22'||

1867: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1868: ELSE
1869: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1870: END IF;
1871: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22'||
1872: ' FROM HZ_STAGED_PARTY_SITES stage'||
1873: ' WHERE contains( concat_col, :cont)>0'||
1874: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1875: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1872: ' FROM HZ_STAGED_PARTY_SITES stage'||

1868: ELSE
1869: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1870: END IF;
1871: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22'||
1872: ' FROM HZ_STAGED_PARTY_SITES stage'||
1873: ' WHERE contains( concat_col, :cont)>0'||
1874: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1875: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1876: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

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

1877: ' AND (ORG_CONTACT_ID IS NULL ' ||
1878: ' AND ('||p_restrict_sql||'))' ||
1879: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1880: ' UNION ' ||
1881: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22'||
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: ' AND ('||p_restrict_sql||'))' ||
1879: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1880: ' UNION ' ||
1881: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22'||
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 1897: ' FROM HZ_STAGED_PARTY_SITES stage'||

1893: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
1894: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
1895: ELSE
1896: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, 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 1914: ' FROM HZ_STAGED_PARTY_SITES stage'||

1910: ,p_dup_party_id, p_dup_party_id;
1911: END IF;
1912: ELSE
1913: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22'||
1914: ' FROM HZ_STAGED_PARTY_SITES stage'||
1915: ' WHERE contains( concat_col, :cont)>0'||
1916: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1917: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1918: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||