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

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

1988: 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);
1989: END IF;
1990: IF p_search_rel_sites = 'N' THEN
1991: OPEN x_cursor FOR
1992: 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
1993: FROM HZ_STAGED_PARTY_SITES stage
1994: WHERE contains( concat_col, p_contains_str)>0
1995: AND( (l_search_merged ='Y' )
1996: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1993: FROM HZ_STAGED_PARTY_SITES stage

1989: END IF;
1990: IF p_search_rel_sites = 'N' THEN
1991: OPEN x_cursor FOR
1992: 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
1993: FROM HZ_STAGED_PARTY_SITES stage
1994: WHERE contains( concat_col, p_contains_str)>0
1995: AND( (l_search_merged ='Y' )
1996: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1997: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

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

Line 2002: FROM HZ_STAGED_PARTY_SITES stage

1998: AND stage.party_id = p_party_id;
1999: ELSE
2000: OPEN x_cursor FOR
2001: 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
2002: FROM HZ_STAGED_PARTY_SITES stage
2003: WHERE contains( concat_col, p_contains_str)>0
2004: AND( (l_search_merged ='Y' )
2005: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2006: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

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

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

2006: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2007: AND stage.party_id = p_party_id
2008: UNION
2009: 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
2010: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
2011: WHERE contains( concat_col, p_contains_str)>0
2012: AND( (l_search_merged ='Y' )
2013: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2014: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2032: FROM HZ_STAGED_PARTY_SITES stage

2028: 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);
2029: END IF;
2030: OPEN x_cursor FOR
2031: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX22
2032: FROM HZ_STAGED_PARTY_SITES stage
2033: WHERE contains( concat_col, p_contains_str)>0
2034: AND EXISTS (
2035: SELECT 1 FROM HZ_STAGED_PARTIES p
2036: WHERE p.PARTY_ID = stage.PARTY_ID

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

2047: 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);
2048: END IF;
2049: IF p_person_api = 'Y' THEN
2050: OPEN x_cursor FOR
2051: 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, TX22
2052: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2053: WHERE contains( concat_col, p_contains_str)>0
2054: AND( (l_search_merged ='Y' )
2055: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2052: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

2048: END IF;
2049: IF p_person_api = 'Y' THEN
2050: OPEN x_cursor FOR
2051: 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, TX22
2052: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2053: WHERE contains( concat_col, p_contains_str)>0
2054: AND( (l_search_merged ='Y' )
2055: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2056: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2057: AND d.search_context_id = p_search_ctx_id
2058: AND d.party_id = stage.party_id
2059: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2060: UNION
2061: 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
2062: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2063: WHERE contains( concat_col, p_contains_str)>0
2064: AND( (l_search_merged ='Y' )
2065: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2058: AND d.party_id = stage.party_id
2059: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2060: UNION
2061: 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
2062: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2063: WHERE contains( concat_col, p_contains_str)>0
2064: AND( (l_search_merged ='Y' )
2065: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2066: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2070: AND oc.org_contact_id = stage.org_contact_id
2071: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2072: ELSE
2073: OPEN x_cursor FOR
2074: 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, TX22
2075: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2076: WHERE contains( concat_col, p_contains_str)>0
2077: AND( (l_search_merged ='Y' )
2078: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2075: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

2071: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2072: ELSE
2073: OPEN x_cursor FOR
2074: 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, TX22
2075: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2076: WHERE contains( concat_col, p_contains_str)>0
2077: AND( (l_search_merged ='Y' )
2078: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2079: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2091: IF (l_check_dt > 0 ) THEN
2092: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2093: 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);
2094: END IF;
2095: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
2096: ELSIF (l_check > 0 ) THEN
2097: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2098: 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);
2099: END IF;

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

2096: ELSIF (l_check > 0 ) THEN
2097: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2098: 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);
2099: END IF;
2100: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */';
2101: END IF;
2102: IF l_search_merged = 'Y' THEN
2103: l_status_sql := ' ' ;
2104: ELSIF l_search_merged = 'I' THEN

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

2115: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2116: ELSE
2117: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2118: END IF;
2119: 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'||
2120: ' FROM HZ_STAGED_PARTY_SITES stage'||
2121: ' WHERE contains( concat_col, :cont)>0'||
2122: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2123: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2120: ' FROM HZ_STAGED_PARTY_SITES stage'||

2116: ELSE
2117: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2118: END IF;
2119: 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'||
2120: ' FROM HZ_STAGED_PARTY_SITES stage'||
2121: ' WHERE contains( concat_col, :cont)>0'||
2122: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2123: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2124: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

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

2125: ' AND (ORG_CONTACT_ID IS NULL ' ||
2126: ' AND ('||p_restrict_sql||'))' ||
2127: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2128: ' UNION ' ||
2129: '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'||
2130: ' FROM HZ_STAGED_PARTY_SITES stage'||
2131: ' WHERE contains( concat_col, :cont)>0'||
2132: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2133: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2130: ' FROM HZ_STAGED_PARTY_SITES stage'||

2126: ' AND ('||p_restrict_sql||'))' ||
2127: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2128: ' UNION ' ||
2129: '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'||
2130: ' FROM HZ_STAGED_PARTY_SITES stage'||
2131: ' WHERE contains( concat_col, :cont)>0'||
2132: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2133: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2134: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2145: ' FROM HZ_STAGED_PARTY_SITES stage'||

2141: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2142: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2143: ELSE
2144: l_sqlstr := 'SELECT ' || l_hint ||' PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX22'||
2145: ' FROM HZ_STAGED_PARTY_SITES stage'||
2146: ' WHERE contains( concat_col, :cont)>0'||
2147: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2148: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2149: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2162: ' FROM HZ_STAGED_PARTY_SITES stage'||

2158: ,p_dup_party_id, p_dup_party_id;
2159: END IF;
2160: ELSE
2161: l_sqlstr := 'SELECT ' || l_hint ||' PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX12, TX13, TX14, TX15, TX22'||
2162: ' FROM HZ_STAGED_PARTY_SITES stage'||
2163: ' WHERE contains( concat_col, :cont)>0'||
2164: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2165: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2166: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

APPS.HZ_MATCH_RULE_62 dependencies on HZ_STAGED_PARTY_SITES

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