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

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

2006: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2007: 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);
2008: END IF;
2009: OPEN x_cursor FOR
2010: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID, TX22
2011: FROM HZ_STAGED_CONTACTS stage
2012: WHERE contains( concat_col, p_contains_str)>0
2013: AND EXISTS (
2014: SELECT 1 FROM HZ_STAGED_PARTIES p

Line 2011: FROM HZ_STAGED_CONTACTS stage

2007: 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);
2008: END IF;
2009: OPEN x_cursor FOR
2010: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID, TX22
2011: FROM HZ_STAGED_CONTACTS stage
2012: WHERE contains( concat_col, p_contains_str)>0
2013: AND EXISTS (
2014: SELECT 1 FROM HZ_STAGED_PARTIES p
2015: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2034: FROM HZ_STAGED_CONTACTS stage

2030: 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);
2031: END IF;
2032: OPEN x_cursor FOR
2033: SELECT ORG_CONTACT_ID, PARTY_ID, TX22
2034: FROM HZ_STAGED_CONTACTS stage
2035: WHERE contains( concat_col, p_contains_str)>0
2036: AND EXISTS (
2037: SELECT 1 FROM HZ_STAGED_PARTIES p
2038: WHERE p.PARTY_ID = stage.PARTY_ID

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

2048: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2049: 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);
2050: END IF;
2051: OPEN x_cursor FOR
2052: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID, TX22
2053: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
2054: WHERE contains( concat_col, p_contains_str)>0
2055: AND d.search_context_id = p_search_ctx_id
2056: AND d.party_id = stage.party_id

Line 2053: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

2049: 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);
2050: END IF;
2051: OPEN x_cursor FOR
2052: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID, TX22
2053: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
2054: WHERE contains( concat_col, p_contains_str)>0
2055: AND d.search_context_id = p_search_ctx_id
2056: AND d.party_id = stage.party_id
2057: AND( (l_search_merged ='Y' )

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

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

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

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

Line 2087: ' FROM HZ_STAGED_CONTACTS stage'||

2083: ELSE
2084: l_status_sql := ' AND nvl(p.status,''A'') in (''A'')';
2085: END IF;
2086: l_sqlstr := 'SELECT ' || l_hint || ' ORG_CONTACT_ID, PARTY_ID , TX22'||
2087: ' FROM HZ_STAGED_CONTACTS stage'||
2088: ' WHERE contains( concat_col, :cont)>0'||
2089: ' AND EXISTS ('||
2090: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2091: ' WHERE p.party_id = stage.party_id ' ||

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

3704: p_search_ctx_id NUMBER,
3705: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
3706: BEGIN
3707: OPEN x_cursor FOR
3708: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX22
3709: FROM HZ_STAGED_CONTACTS stage
3710: WHERE contains( concat_col, p_contains_str)>0
3711: AND ORG_CONTACT_ID in (
3712: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/

Line 3709: FROM HZ_STAGED_CONTACTS stage

3705: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
3706: BEGIN
3707: OPEN x_cursor FOR
3708: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX22
3709: FROM HZ_STAGED_CONTACTS stage
3710: WHERE contains( concat_col, p_contains_str)>0
3711: AND ORG_CONTACT_ID in (
3712: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3713: org_contact_id

APPS.HZ_MATCH_RULE_99 dependencies on HZ_STAGED_CONTACTS

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