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_53 dependencies on HZ_STAGED_CONTACTS

Line 1998: SELECT /+ INDEX(stage HZ_STAGED_CONTACTS_N1) / ORG_CONTACT_ID, PARTY_ID

1994: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
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: OPEN x_cursor FOR
1998: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID
1999: FROM HZ_STAGED_CONTACTS stage
2000: WHERE contains( concat_col, p_contains_str)>0
2001: AND EXISTS (
2002: SELECT 1 FROM HZ_STAGED_PARTIES p

Line 1999: FROM HZ_STAGED_CONTACTS stage

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: OPEN x_cursor FOR
1998: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID
1999: FROM HZ_STAGED_CONTACTS stage
2000: WHERE contains( concat_col, p_contains_str)>0
2001: AND EXISTS (
2002: SELECT 1 FROM HZ_STAGED_PARTIES p
2003: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2022: FROM HZ_STAGED_CONTACTS stage

2018: 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);
2019: END IF;
2020: OPEN x_cursor FOR
2021: SELECT ORG_CONTACT_ID, PARTY_ID
2022: FROM HZ_STAGED_CONTACTS stage
2023: WHERE contains( concat_col, p_contains_str)>0
2024: AND EXISTS (
2025: SELECT 1 FROM HZ_STAGED_PARTIES p
2026: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2040: SELECT /+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) / ORG_CONTACT_ID, stage.PARTY_ID

2036: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2037: 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);
2038: END IF;
2039: OPEN x_cursor FOR
2040: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID
2041: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
2042: WHERE contains( concat_col, p_contains_str)>0
2043: AND d.search_context_id = p_search_ctx_id
2044: AND d.party_id = stage.party_id

Line 2041: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

2037: 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);
2038: END IF;
2039: OPEN x_cursor FOR
2040: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID
2041: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
2042: WHERE contains( concat_col, p_contains_str)>0
2043: AND d.search_context_id = p_search_ctx_id
2044: AND d.party_id = stage.party_id
2045: AND( (l_search_merged ='Y' )

Line 2060: l_hint := '/+ INDEX(stage HZ_STAGED_CONTACTS_U1) /';

2056: IF (l_check_dt > 0 ) THEN
2057: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2058: hz_utility_v2pub.debug(p_message=>'Restrict sql has the selective_ct hint',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2059: END IF;
2060: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */';
2061: ELSIF (l_check > 0 ) THEN
2062: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2063: 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);
2064: END IF;

Line 2065: l_hint := '/+ INDEX(stage HZ_STAGED_CONTACTS_N1) /';

2061: ELSIF (l_check > 0 ) THEN
2062: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2063: 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);
2064: END IF;
2065: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */';
2066: END IF;
2067: IF l_search_merged = 'Y' THEN
2068: l_status_sql := ' ' ;
2069: ELSIF l_search_merged = 'I' THEN

Line 2075: ' FROM HZ_STAGED_CONTACTS stage'||

2071: ELSE
2072: l_status_sql := ' AND nvl(p.status,''A'') in (''A'')';
2073: END IF;
2074: l_sqlstr := 'SELECT ' || l_hint || ' ORG_CONTACT_ID, PARTY_ID '||
2075: ' FROM HZ_STAGED_CONTACTS stage'||
2076: ' WHERE contains( concat_col, :cont)>0'||
2077: ' AND EXISTS ('||
2078: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2079: ' WHERE p.party_id = stage.party_id ' ||

Line 3694: SELECT /+ INDEX(stage HZ_STAGED_CONTACTS_U1) / ORG_CONTACT_ID, PARTY_ID

3690: p_search_ctx_id NUMBER,
3691: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
3692: BEGIN
3693: OPEN x_cursor FOR
3694: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3695: FROM HZ_STAGED_CONTACTS stage
3696: WHERE contains( concat_col, p_contains_str)>0
3697: AND ORG_CONTACT_ID in (
3698: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/

Line 3695: FROM HZ_STAGED_CONTACTS stage

3691: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
3692: BEGIN
3693: OPEN x_cursor FOR
3694: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3695: FROM HZ_STAGED_CONTACTS stage
3696: WHERE contains( concat_col, p_contains_str)>0
3697: AND ORG_CONTACT_ID in (
3698: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3699: org_contact_id

APPS.HZ_MATCH_RULE_53 dependencies on HZ_STAGED_CONTACTS

Line 1998: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID