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

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

1962: 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);
1963: END IF;
1964: IF p_search_rel_sites = 'N' THEN
1965: OPEN x_cursor FOR
1966: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22
1967: FROM HZ_STAGED_PARTY_SITES stage
1968: WHERE contains( concat_col, p_contains_str)>0
1969: AND( (l_search_merged ='Y' )
1970: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1967: FROM HZ_STAGED_PARTY_SITES stage

1963: END IF;
1964: IF p_search_rel_sites = 'N' THEN
1965: OPEN x_cursor FOR
1966: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22
1967: FROM HZ_STAGED_PARTY_SITES stage
1968: WHERE contains( concat_col, p_contains_str)>0
1969: AND( (l_search_merged ='Y' )
1970: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1971: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1971: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1972: AND stage.party_id = p_party_id;
1973: ELSE
1974: OPEN x_cursor FOR
1975: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22
1976: FROM HZ_STAGED_PARTY_SITES stage
1977: WHERE contains( concat_col, p_contains_str)>0
1978: AND( (l_search_merged ='Y' )
1979: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1976: FROM HZ_STAGED_PARTY_SITES stage

1972: AND stage.party_id = p_party_id;
1973: ELSE
1974: OPEN x_cursor FOR
1975: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22
1976: FROM HZ_STAGED_PARTY_SITES stage
1977: WHERE contains( concat_col, p_contains_str)>0
1978: AND( (l_search_merged ='Y' )
1979: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1980: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1979: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1980: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1981: AND stage.party_id = p_party_id
1982: UNION
1983: 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, TX17, TX22
1984: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1985: WHERE contains( concat_col, p_contains_str)>0
1986: AND( (l_search_merged ='Y' )
1987: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

1980: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1981: AND stage.party_id = p_party_id
1982: UNION
1983: 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, TX17, TX22
1984: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1985: WHERE contains( concat_col, p_contains_str)>0
1986: AND( (l_search_merged ='Y' )
1987: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1988: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2006: FROM HZ_STAGED_PARTY_SITES stage

2002: 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);
2003: END IF;
2004: OPEN x_cursor FOR
2005: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22
2006: FROM HZ_STAGED_PARTY_SITES stage
2007: WHERE contains( concat_col, p_contains_str)>0
2008: AND EXISTS (
2009: SELECT 1 FROM HZ_STAGED_PARTIES p
2010: WHERE p.PARTY_ID = stage.PARTY_ID

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

2021: 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);
2022: END IF;
2023: IF p_person_api = 'Y' THEN
2024: OPEN x_cursor FOR
2025: 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, TX17, TX22
2026: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2027: WHERE contains( concat_col, p_contains_str)>0
2028: AND( (l_search_merged ='Y' )
2029: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2026: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

2022: END IF;
2023: IF p_person_api = 'Y' THEN
2024: OPEN x_cursor FOR
2025: 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, TX17, TX22
2026: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2027: WHERE contains( concat_col, p_contains_str)>0
2028: AND( (l_search_merged ='Y' )
2029: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2030: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2031: AND d.search_context_id = p_search_ctx_id
2032: AND d.party_id = stage.party_id
2033: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2034: UNION
2035: 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, TX17, TX22
2036: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2037: WHERE contains( concat_col, p_contains_str)>0
2038: AND( (l_search_merged ='Y' )
2039: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2032: AND d.party_id = stage.party_id
2033: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2034: UNION
2035: 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, TX17, TX22
2036: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2037: WHERE contains( concat_col, p_contains_str)>0
2038: AND( (l_search_merged ='Y' )
2039: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2040: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2044: AND oc.org_contact_id = stage.org_contact_id
2045: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2046: ELSE
2047: OPEN x_cursor FOR
2048: 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, TX17, TX22
2049: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2050: WHERE contains( concat_col, p_contains_str)>0
2051: AND( (l_search_merged ='Y' )
2052: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2049: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

2045: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2046: ELSE
2047: OPEN x_cursor FOR
2048: 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, TX17, TX22
2049: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2050: WHERE contains( concat_col, p_contains_str)>0
2051: AND( (l_search_merged ='Y' )
2052: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2053: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2065: IF (l_check_dt > 0 ) THEN
2066: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2067: 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);
2068: END IF;
2069: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
2070: ELSIF (l_check > 0 ) THEN
2071: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2072: 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);
2073: END IF;

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

2070: ELSIF (l_check > 0 ) THEN
2071: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2072: 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);
2073: END IF;
2074: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */';
2075: END IF;
2076: IF l_search_merged = 'Y' THEN
2077: l_status_sql := ' ' ;
2078: ELSIF l_search_merged = 'I' THEN

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

2089: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2090: ELSE
2091: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2092: END IF;
2093: 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, TX17, TX22'||
2094: ' FROM HZ_STAGED_PARTY_SITES stage'||
2095: ' WHERE contains( concat_col, :cont)>0'||
2096: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2097: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2094: ' FROM HZ_STAGED_PARTY_SITES stage'||

2090: ELSE
2091: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2092: END IF;
2093: 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, TX17, TX22'||
2094: ' FROM HZ_STAGED_PARTY_SITES stage'||
2095: ' WHERE contains( concat_col, :cont)>0'||
2096: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2097: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2098: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

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

2099: ' AND (ORG_CONTACT_ID IS NULL ' ||
2100: ' AND ('||p_restrict_sql||'))' ||
2101: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2102: ' UNION ' ||
2103: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22'||
2104: ' FROM HZ_STAGED_PARTY_SITES stage'||
2105: ' WHERE contains( concat_col, :cont)>0'||
2106: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2107: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2104: ' FROM HZ_STAGED_PARTY_SITES stage'||

2100: ' AND ('||p_restrict_sql||'))' ||
2101: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2102: ' UNION ' ||
2103: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22'||
2104: ' FROM HZ_STAGED_PARTY_SITES stage'||
2105: ' WHERE contains( concat_col, :cont)>0'||
2106: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2107: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2108: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2119: ' FROM HZ_STAGED_PARTY_SITES stage'||

2115: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2116: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2117: ELSE
2118: l_sqlstr := 'SELECT ' || l_hint ||' PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22'||
2119: ' FROM HZ_STAGED_PARTY_SITES stage'||
2120: ' WHERE contains( concat_col, :cont)>0'||
2121: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2122: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2123: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2136: ' FROM HZ_STAGED_PARTY_SITES stage'||

2132: ,p_dup_party_id, p_dup_party_id;
2133: END IF;
2134: ELSE
2135: l_sqlstr := 'SELECT ' || l_hint ||' PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX10, TX11, TX14, TX15, TX17, TX22'||
2136: ' FROM HZ_STAGED_PARTY_SITES stage'||
2137: ' WHERE contains( concat_col, :cont)>0'||
2138: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2139: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2140: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

APPS.HZ_MATCH_RULE_33 dependencies on HZ_STAGED_PARTY_SITES

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