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

Line 2385: SELECT /+ INDEX(stage HZ_STAGED_CONTACTS_N1) / ORG_CONTACT_ID, PARTY_ID, TX2, TX156, TX6, TX5

2381: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2382: 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);
2383: END IF;
2384: OPEN x_cursor FOR
2385: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID, TX2, TX156, TX6, TX5
2386: FROM HZ_STAGED_CONTACTS stage
2387: WHERE contains( concat_col, p_contains_str)>0
2388: AND EXISTS (
2389: SELECT 1 FROM HZ_STAGED_PARTIES p

Line 2386: FROM HZ_STAGED_CONTACTS stage

2382: 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);
2383: END IF;
2384: OPEN x_cursor FOR
2385: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID, TX2, TX156, TX6, TX5
2386: FROM HZ_STAGED_CONTACTS stage
2387: WHERE contains( concat_col, p_contains_str)>0
2388: AND EXISTS (
2389: SELECT 1 FROM HZ_STAGED_PARTIES p
2390: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2409: FROM HZ_STAGED_CONTACTS stage

2405: 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);
2406: END IF;
2407: OPEN x_cursor FOR
2408: SELECT ORG_CONTACT_ID, PARTY_ID, TX2, TX156, TX6, TX5
2409: FROM HZ_STAGED_CONTACTS stage
2410: WHERE contains( concat_col, p_contains_str)>0
2411: AND EXISTS (
2412: SELECT 1 FROM HZ_STAGED_PARTIES p
2413: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2427: SELECT /+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) / ORG_CONTACT_ID, stage.PARTY_ID, TX2, TX156, TX6, TX5

2423: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2424: 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);
2425: END IF;
2426: OPEN x_cursor FOR
2427: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID, TX2, TX156, TX6, TX5
2428: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
2429: WHERE contains( concat_col, p_contains_str)>0
2430: AND d.search_context_id = p_search_ctx_id
2431: AND d.party_id = stage.party_id

Line 2428: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

2424: 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);
2425: END IF;
2426: OPEN x_cursor FOR
2427: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID, TX2, TX156, TX6, TX5
2428: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
2429: WHERE contains( concat_col, p_contains_str)>0
2430: AND d.search_context_id = p_search_ctx_id
2431: AND d.party_id = stage.party_id
2432: AND( (l_search_merged ='Y' )

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

2443: IF (l_check_dt > 0 ) THEN
2444: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2445: 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);
2446: END IF;
2447: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */';
2448: ELSIF (l_check > 0 ) THEN
2449: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2450: 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);
2451: END IF;

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

2448: ELSIF (l_check > 0 ) THEN
2449: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2450: 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);
2451: END IF;
2452: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */';
2453: END IF;
2454: IF l_search_merged = 'Y' THEN
2455: l_status_sql := ' ' ;
2456: ELSIF l_search_merged = 'I' THEN

Line 2462: ' FROM HZ_STAGED_CONTACTS stage'||

2458: ELSE
2459: l_status_sql := ' AND nvl(p.status,''A'') in (''A'')';
2460: END IF;
2461: l_sqlstr := 'SELECT ' || l_hint || ' ORG_CONTACT_ID, PARTY_ID , TX2, TX156, TX6, TX5'||
2462: ' FROM HZ_STAGED_CONTACTS stage'||
2463: ' WHERE contains( concat_col, :cont)>0'||
2464: ' AND EXISTS ('||
2465: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2466: ' WHERE p.party_id = stage.party_id ' ||

Line 4095: SELECT /+ INDEX(stage HZ_STAGED_CONTACTS_U1) / ORG_CONTACT_ID, PARTY_ID, TX2, TX156, TX6, TX5

4091: p_search_ctx_id NUMBER,
4092: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
4093: BEGIN
4094: OPEN x_cursor FOR
4095: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX2, TX156, TX6, TX5
4096: FROM HZ_STAGED_CONTACTS stage
4097: WHERE contains( concat_col, p_contains_str)>0
4098: AND ORG_CONTACT_ID in (
4099: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/

Line 4096: FROM HZ_STAGED_CONTACTS stage

4092: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
4093: BEGIN
4094: OPEN x_cursor FOR
4095: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID, TX2, TX156, TX6, TX5
4096: FROM HZ_STAGED_CONTACTS stage
4097: WHERE contains( concat_col, p_contains_str)>0
4098: AND ORG_CONTACT_ID in (
4099: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
4100: org_contact_id

APPS.HZ_MATCH_RULE_32 dependencies on HZ_STAGED_CONTACTS

Line 2385: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID, TX2, TX156, TX6, TX5