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_CONTACTS

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

2231: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2232: 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);
2233: END IF;
2234: OPEN x_cursor FOR
2235: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID
2236: FROM HZ_STAGED_CONTACTS stage
2237: WHERE contains( concat_col, p_contains_str)>0
2238: AND EXISTS (
2239: SELECT 1 FROM HZ_STAGED_PARTIES p

Line 2236: FROM HZ_STAGED_CONTACTS stage

2232: 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);
2233: END IF;
2234: OPEN x_cursor FOR
2235: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, PARTY_ID
2236: FROM HZ_STAGED_CONTACTS stage
2237: WHERE contains( concat_col, p_contains_str)>0
2238: AND EXISTS (
2239: SELECT 1 FROM HZ_STAGED_PARTIES p
2240: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2259: FROM HZ_STAGED_CONTACTS stage

2255: 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);
2256: END IF;
2257: OPEN x_cursor FOR
2258: SELECT ORG_CONTACT_ID, PARTY_ID
2259: FROM HZ_STAGED_CONTACTS stage
2260: WHERE contains( concat_col, p_contains_str)>0
2261: AND EXISTS (
2262: SELECT 1 FROM HZ_STAGED_PARTIES p
2263: WHERE p.PARTY_ID = stage.PARTY_ID

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

2273: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2274: 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);
2275: END IF;
2276: OPEN x_cursor FOR
2277: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID
2278: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
2279: WHERE contains( concat_col, p_contains_str)>0
2280: AND d.search_context_id = p_search_ctx_id
2281: AND d.party_id = stage.party_id

Line 2278: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage

2274: 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);
2275: END IF;
2276: OPEN x_cursor FOR
2277: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACTS_N1) */ ORG_CONTACT_ID, stage.PARTY_ID
2278: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACTS stage
2279: WHERE contains( concat_col, p_contains_str)>0
2280: AND d.search_context_id = p_search_ctx_id
2281: AND d.party_id = stage.party_id
2282: AND( (l_search_merged ='Y' )

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

2293: IF (l_check_dt > 0 ) THEN
2294: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2295: 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);
2296: END IF;
2297: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */';
2298: ELSIF (l_check > 0 ) THEN
2299: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2300: 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);
2301: END IF;

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

2298: ELSIF (l_check > 0 ) THEN
2299: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2300: 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);
2301: END IF;
2302: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACTS_N1) */';
2303: END IF;
2304: IF l_search_merged = 'Y' THEN
2305: l_status_sql := ' ' ;
2306: ELSIF l_search_merged = 'I' THEN

Line 2312: ' FROM HZ_STAGED_CONTACTS stage'||

2308: ELSE
2309: l_status_sql := ' AND nvl(p.status,''A'') in (''A'')';
2310: END IF;
2311: l_sqlstr := 'SELECT ' || l_hint || ' ORG_CONTACT_ID, PARTY_ID '||
2312: ' FROM HZ_STAGED_CONTACTS stage'||
2313: ' WHERE contains( concat_col, :cont)>0'||
2314: ' AND EXISTS ('||
2315: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2316: ' WHERE p.party_id = stage.party_id ' ||

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

3941: p_search_ctx_id NUMBER,
3942: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
3943: BEGIN
3944: OPEN x_cursor FOR
3945: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3946: FROM HZ_STAGED_CONTACTS stage
3947: WHERE contains( concat_col, p_contains_str)>0
3948: AND ORG_CONTACT_ID in (
3949: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/

Line 3946: FROM HZ_STAGED_CONTACTS stage

3942: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
3943: BEGIN
3944: OPEN x_cursor FOR
3945: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
3946: FROM HZ_STAGED_CONTACTS stage
3947: WHERE contains( concat_col, p_contains_str)>0
3948: AND ORG_CONTACT_ID in (
3949: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3950: org_contact_id

APPS.HZ_MATCH_RULE_62 dependencies on HZ_STAGED_CONTACTS

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