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_CONTACT_POINTS

Line 2534: SELECT /+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) / CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5

2530: END IF;
2531: IF p_restrict_entity = 'CONTACTS'
2532: THEN
2533: OPEN x_cursor FOR
2534: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2535: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2536: WHERE contains( concat_col, p_contains_str)>0
2537: AND d.search_context_id = p_search_ctx_id
2538: AND( (l_search_merged ='Y' )

Line 2535: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2531: IF p_restrict_entity = 'CONTACTS'
2532: THEN
2533: OPEN x_cursor FOR
2534: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2535: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2536: WHERE contains( concat_col, p_contains_str)>0
2537: AND d.search_context_id = p_search_ctx_id
2538: AND( (l_search_merged ='Y' )
2539: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2546: SELECT /+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N3) / CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5

2542: END IF;
2543: IF p_restrict_entity = 'PARTY_SITES'
2544: THEN
2545: OPEN x_cursor FOR
2546: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N3) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2547: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2548: WHERE contains( concat_col, p_contains_str)>0
2549: AND d.search_context_id = p_search_ctx_id
2550: AND( (l_search_merged ='Y' )

Line 2547: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2543: IF p_restrict_entity = 'PARTY_SITES'
2544: THEN
2545: OPEN x_cursor FOR
2546: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N3) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2547: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2548: WHERE contains( concat_col, p_contains_str)>0
2549: AND d.search_context_id = p_search_ctx_id
2550: AND( (l_search_merged ='Y' )
2551: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2563: SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) / CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5

2559: 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);
2560: END IF;
2561: IF p_search_rel_cpts = 'N' THEN
2562: OPEN x_cursor FOR
2563: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2564: FROM HZ_STAGED_CONTACT_POINTS stage
2565: WHERE contains( concat_col, p_contains_str)>0
2566: AND( (l_search_merged ='Y' )
2567: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2564: FROM HZ_STAGED_CONTACT_POINTS stage

2560: END IF;
2561: IF p_search_rel_cpts = 'N' THEN
2562: OPEN x_cursor FOR
2563: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2564: FROM HZ_STAGED_CONTACT_POINTS stage
2565: WHERE contains( concat_col, p_contains_str)>0
2566: AND( (l_search_merged ='Y' )
2567: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2568: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2572: SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) / CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5

2568: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2569: AND stage.party_id = p_party_id;
2570: ELSE
2571: OPEN x_cursor FOR
2572: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2573: FROM HZ_STAGED_CONTACT_POINTS stage
2574: WHERE contains( concat_col, p_contains_str)>0
2575: AND( (l_search_merged ='Y' )
2576: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2573: FROM HZ_STAGED_CONTACT_POINTS stage

2569: AND stage.party_id = p_party_id;
2570: ELSE
2571: OPEN x_cursor FOR
2572: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2573: FROM HZ_STAGED_CONTACT_POINTS stage
2574: WHERE contains( concat_col, p_contains_str)>0
2575: AND( (l_search_merged ='Y' )
2576: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2577: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2580: SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) / stage.CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , TX1, TX6, TX5

2576: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2577: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2578: AND stage.party_id = p_party_id
2579: UNION
2580: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ stage.CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , TX1, TX6, TX5
2581: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2582: WHERE contains( concat_col, p_contains_str)>0
2583: AND r.object_id = p_party_id
2584: AND( (l_search_merged ='Y' )

Line 2581: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc

2577: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2578: AND stage.party_id = p_party_id
2579: UNION
2580: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ stage.CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , TX1, TX6, TX5
2581: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2582: WHERE contains( concat_col, p_contains_str)>0
2583: AND r.object_id = p_party_id
2584: AND( (l_search_merged ='Y' )
2585: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2603: FROM HZ_STAGED_CONTACT_POINTS stage

2599: hz_utility_v2pub.debug(p_message=>'Either 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);
2600: END IF;
2601: OPEN x_cursor FOR
2602: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2603: FROM HZ_STAGED_CONTACT_POINTS stage
2604: WHERE contains( concat_col, p_contains_str)>0
2605: AND EXISTS (
2606: SELECT 1 FROM HZ_STAGED_PARTIES p
2607: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2623: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2619: END IF;
2620: IF p_person_api = 'Y' THEN
2621: OPEN x_cursor FOR
2622: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2623: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2624: WHERE contains( concat_col, p_contains_str)>0
2625: AND d.search_context_id = p_search_ctx_id
2626: AND d.party_id = stage.party_id
2627: AND( (l_search_merged ='Y' )

Line 2632: SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) / CONTACT_POINT_ID, stage.contact_point_type, r.subject_id, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , TX1, TX6, TX5

2628: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2629: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2630: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2631: UNION
2632: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, r.subject_id, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , TX1, TX6, TX5
2633: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2634: WHERE contains( concat_col, p_contains_str)>0
2635: AND d.search_context_id = p_search_ctx_id
2636: AND d.party_id = r.subject_id

Line 2633: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage

2629: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2630: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2631: UNION
2632: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, r.subject_id, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , TX1, TX6, TX5
2633: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2634: WHERE contains( concat_col, p_contains_str)>0
2635: AND d.search_context_id = p_search_ctx_id
2636: AND d.party_id = r.subject_id
2637: AND r.relationship_id = oc.party_relationship_id

Line 2646: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2642: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2643: ELSE
2644: OPEN x_cursor FOR
2645: SELECT CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2646: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2647: WHERE contains( concat_col, p_contains_str)>0
2648: AND d.search_context_id = p_search_ctx_id
2649: AND d.party_id = stage.party_id
2650: AND( (l_search_merged ='Y' )

Line 2666: l_hint := '/+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) /';

2662: IF (l_check_dt > 0 ) THEN
2663: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2664: hz_utility_v2pub.debug(p_message=>'Restrict Sql has the selective_cpt hint',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2665: END IF;
2666: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
2667: ELSIF (l_check > 0 ) THEN
2668: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2669: 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);
2670: END IF;

Line 2671: l_hint := '/+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) /';

2667: ELSIF (l_check > 0 ) THEN
2668: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2669: 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);
2670: END IF;
2671: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */';
2672: END IF;
2673: IF l_search_merged = 'Y' THEN
2674: l_status_sql := ' ' ;
2675: ELSIF l_search_merged = 'I' THEN

Line 2690: l_sqlstr := ' SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) / CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||

2686: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2687: ELSE
2688: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2689: END IF;
2690: l_sqlstr := ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2691: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2692: ' WHERE contains( concat_col, :cont)>0 '||
2693: ' AND (stage.org_contact_id is null '||
2694: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 2691: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2687: ELSE
2688: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2689: END IF;
2690: l_sqlstr := ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2691: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2692: ' WHERE contains( concat_col, :cont)>0 '||
2693: ' AND (stage.org_contact_id is null '||
2694: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2695: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2700: ' SELECT /+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) / CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||

2696: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
2697: ' AND ('||p_restrict_sql||'))' ||
2698: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2699: ' UNION ' ||
2700: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2701: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2702: ' WHERE contains( concat_col, :cont)>0 '||
2703: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2704: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2701: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2697: ' AND ('||p_restrict_sql||'))' ||
2698: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2699: ' UNION ' ||
2700: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2701: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2702: ' WHERE contains( concat_col, :cont)>0 '||
2703: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2704: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2705: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2716: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2712: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2713: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2714: ELSE
2715: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2716: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2717: ' WHERE contains( concat_col, :cont)>0'||
2718: ' AND EXISTS ('||
2719: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2720: ' WHERE p.party_id = stage.party_id ' ||

Line 2733: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2729: ,p_dup_party_id, p_dup_party_id;
2730: END IF;
2731: ELSE
2732: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2733: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2734: ' WHERE contains( concat_col, :cont)>0'||
2735: ' AND EXISTS ('||
2736: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2737: ' WHERE p.party_id = stage.party_id ' ||