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

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

1995: 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);
1996: END IF;
1997: IF p_search_rel_sites = 'N' THEN
1998: OPEN x_cursor FOR
1999: 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, TX22
2000: FROM HZ_STAGED_PARTY_SITES stage
2001: WHERE contains( concat_col, p_contains_str)>0
2002: AND( (l_search_merged ='Y' )
2003: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2000: FROM HZ_STAGED_PARTY_SITES stage

1996: END IF;
1997: IF p_search_rel_sites = 'N' THEN
1998: OPEN x_cursor FOR
1999: 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, TX22
2000: FROM HZ_STAGED_PARTY_SITES stage
2001: WHERE contains( concat_col, p_contains_str)>0
2002: AND( (l_search_merged ='Y' )
2003: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2004: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2004: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2005: AND stage.party_id = p_party_id;
2006: ELSE
2007: OPEN x_cursor FOR
2008: 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, TX22
2009: FROM HZ_STAGED_PARTY_SITES stage
2010: WHERE contains( concat_col, p_contains_str)>0
2011: AND( (l_search_merged ='Y' )
2012: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2009: FROM HZ_STAGED_PARTY_SITES stage

2005: AND stage.party_id = p_party_id;
2006: ELSE
2007: OPEN x_cursor FOR
2008: 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, TX22
2009: FROM HZ_STAGED_PARTY_SITES stage
2010: WHERE contains( concat_col, p_contains_str)>0
2011: AND( (l_search_merged ='Y' )
2012: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2013: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2012: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2013: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2014: AND stage.party_id = p_party_id
2015: UNION
2016: 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, TX22
2017: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
2018: WHERE contains( concat_col, p_contains_str)>0
2019: AND( (l_search_merged ='Y' )
2020: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2013: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2014: AND stage.party_id = p_party_id
2015: UNION
2016: 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, TX22
2017: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
2018: WHERE contains( concat_col, p_contains_str)>0
2019: AND( (l_search_merged ='Y' )
2020: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2021: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2039: FROM HZ_STAGED_PARTY_SITES stage

2035: 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);
2036: END IF;
2037: OPEN x_cursor FOR
2038: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX22
2039: FROM HZ_STAGED_PARTY_SITES stage
2040: WHERE contains( concat_col, p_contains_str)>0
2041: AND EXISTS (
2042: SELECT 1 FROM HZ_STAGED_PARTIES p
2043: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2059: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

2055: END IF;
2056: IF p_person_api = 'Y' THEN
2057: OPEN x_cursor FOR
2058: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX22
2059: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2060: WHERE contains( concat_col, p_contains_str)>0
2061: AND( (l_search_merged ='Y' )
2062: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2063: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2064: AND d.search_context_id = p_search_ctx_id
2065: AND d.party_id = stage.party_id
2066: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2067: UNION
2068: 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, TX22
2069: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2070: WHERE contains( concat_col, p_contains_str)>0
2071: AND( (l_search_merged ='Y' )
2072: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2065: AND d.party_id = stage.party_id
2066: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2067: UNION
2068: 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, TX22
2069: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2070: WHERE contains( concat_col, p_contains_str)>0
2071: AND( (l_search_merged ='Y' )
2072: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2073: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2082: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

2078: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2079: ELSE
2080: OPEN x_cursor FOR
2081: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX22
2082: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2083: WHERE contains( concat_col, p_contains_str)>0
2084: AND( (l_search_merged ='Y' )
2085: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2086: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2098: IF (l_check_dt > 0 ) THEN
2099: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2100: 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);
2101: END IF;
2102: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
2103: ELSIF (l_check > 0 ) THEN
2104: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2105: 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);
2106: END IF;

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

2103: ELSIF (l_check > 0 ) THEN
2104: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2105: 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);
2106: END IF;
2107: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */';
2108: END IF;
2109: IF l_search_merged = 'Y' THEN
2110: l_status_sql := ' ' ;
2111: ELSIF l_search_merged = 'I' THEN

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

2122: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2123: ELSE
2124: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2125: END IF;
2126: 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, TX22'||
2127: ' FROM HZ_STAGED_PARTY_SITES stage'||
2128: ' WHERE contains( concat_col, :cont)>0'||
2129: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2130: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2127: ' FROM HZ_STAGED_PARTY_SITES stage'||

2123: ELSE
2124: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2125: END IF;
2126: 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, TX22'||
2127: ' FROM HZ_STAGED_PARTY_SITES stage'||
2128: ' WHERE contains( concat_col, :cont)>0'||
2129: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2130: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2131: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

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

2132: ' AND (ORG_CONTACT_ID IS NULL ' ||
2133: ' AND ('||p_restrict_sql||'))' ||
2134: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2135: ' UNION ' ||
2136: '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, TX22'||
2137: ' FROM HZ_STAGED_PARTY_SITES stage'||
2138: ' WHERE contains( concat_col, :cont)>0'||
2139: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2140: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2137: ' FROM HZ_STAGED_PARTY_SITES stage'||

2133: ' AND ('||p_restrict_sql||'))' ||
2134: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2135: ' UNION ' ||
2136: '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, TX22'||
2137: ' FROM HZ_STAGED_PARTY_SITES stage'||
2138: ' WHERE contains( concat_col, :cont)>0'||
2139: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2140: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2141: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2152: ' FROM HZ_STAGED_PARTY_SITES stage'||

2148: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2149: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2150: ELSE
2151: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX22'||
2152: ' FROM HZ_STAGED_PARTY_SITES stage'||
2153: ' WHERE contains( concat_col, :cont)>0'||
2154: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2155: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2156: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2169: ' FROM HZ_STAGED_PARTY_SITES stage'||

2165: ,p_dup_party_id, p_dup_party_id;
2166: END IF;
2167: ELSE
2168: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX22'||
2169: ' FROM HZ_STAGED_PARTY_SITES stage'||
2170: ' WHERE contains( concat_col, :cont)>0'||
2171: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2172: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2173: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||