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 1742: 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

1738: 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);
1739: END IF;
1740: IF p_search_rel_sites = 'N' THEN
1741: OPEN x_cursor FOR
1742: 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
1743: FROM HZ_STAGED_PARTY_SITES stage
1744: WHERE contains( concat_col, p_contains_str)>0
1745: AND( (l_search_merged ='Y' )
1746: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1743: FROM HZ_STAGED_PARTY_SITES stage

1739: END IF;
1740: IF p_search_rel_sites = 'N' THEN
1741: OPEN x_cursor FOR
1742: 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
1743: FROM HZ_STAGED_PARTY_SITES stage
1744: WHERE contains( concat_col, p_contains_str)>0
1745: AND( (l_search_merged ='Y' )
1746: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1747: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1747: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1748: AND stage.party_id = p_party_id;
1749: ELSE
1750: OPEN x_cursor FOR
1751: 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
1752: FROM HZ_STAGED_PARTY_SITES stage
1753: WHERE contains( concat_col, p_contains_str)>0
1754: AND( (l_search_merged ='Y' )
1755: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1752: FROM HZ_STAGED_PARTY_SITES stage

1748: AND stage.party_id = p_party_id;
1749: ELSE
1750: OPEN x_cursor FOR
1751: 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
1752: FROM HZ_STAGED_PARTY_SITES stage
1753: WHERE contains( concat_col, p_contains_str)>0
1754: AND( (l_search_merged ='Y' )
1755: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1756: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1755: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1756: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1757: AND stage.party_id = p_party_id
1758: UNION
1759: 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
1760: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
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, hz_relationships r, hz_org_contacts oc

1756: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1757: AND stage.party_id = p_party_id
1758: UNION
1759: 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
1760: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
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 1782: FROM HZ_STAGED_PARTY_SITES stage

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

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

1797: 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);
1798: END IF;
1799: IF p_person_api = 'Y' THEN
1800: OPEN x_cursor FOR
1801: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1802: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1803: WHERE contains( concat_col, p_contains_str)>0
1804: AND( (l_search_merged ='Y' )
1805: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1802: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

1807: AND d.search_context_id = p_search_ctx_id
1808: AND d.party_id = stage.party_id
1809: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1810: UNION
1811: 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
1812: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1813: WHERE contains( concat_col, p_contains_str)>0
1814: AND( (l_search_merged ='Y' )
1815: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1808: AND d.party_id = stage.party_id
1809: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1810: UNION
1811: 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
1812: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1813: WHERE contains( concat_col, p_contains_str)>0
1814: AND( (l_search_merged ='Y' )
1815: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1816: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1820: AND oc.org_contact_id = stage.org_contact_id
1821: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1822: ELSE
1823: OPEN x_cursor FOR
1824: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1825: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1826: WHERE contains( concat_col, p_contains_str)>0
1827: AND( (l_search_merged ='Y' )
1828: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1825: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

1821: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
1822: ELSE
1823: OPEN x_cursor FOR
1824: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, TX22
1825: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
1826: WHERE contains( concat_col, p_contains_str)>0
1827: AND( (l_search_merged ='Y' )
1828: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1829: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

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

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

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

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

1865: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
1866: ELSE
1867: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1868: END IF;
1869: 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'||
1870: ' FROM HZ_STAGED_PARTY_SITES stage'||
1871: ' WHERE contains( concat_col, :cont)>0'||
1872: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1873: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1870: ' FROM HZ_STAGED_PARTY_SITES stage'||

1866: ELSE
1867: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
1868: END IF;
1869: 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'||
1870: ' FROM HZ_STAGED_PARTY_SITES stage'||
1871: ' WHERE contains( concat_col, :cont)>0'||
1872: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1873: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1874: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

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

1875: ' AND (ORG_CONTACT_ID IS NULL ' ||
1876: ' AND ('||p_restrict_sql||'))' ||
1877: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1878: ' UNION ' ||
1879: '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'||
1880: ' FROM HZ_STAGED_PARTY_SITES stage'||
1881: ' WHERE contains( concat_col, :cont)>0'||
1882: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1883: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 1880: ' FROM HZ_STAGED_PARTY_SITES stage'||

1876: ' AND ('||p_restrict_sql||'))' ||
1877: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
1878: ' UNION ' ||
1879: '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'||
1880: ' FROM HZ_STAGED_PARTY_SITES stage'||
1881: ' WHERE contains( concat_col, :cont)>0'||
1882: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1883: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1884: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 1895: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

1908: ,p_dup_party_id, p_dup_party_id;
1909: END IF;
1910: ELSE
1911: l_sqlstr := 'SELECT ' || l_hint ||' PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX20, TX21, 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'') ) '||

APPS.HZ_MATCH_RULE_38 dependencies on HZ_STAGED_PARTY_SITES

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