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_42 dependencies on HZ_STAGED_PARTY_SITES

Line 2531: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22

2527: 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);
2528: END IF;
2529: IF p_search_rel_sites = 'N' THEN
2530: OPEN x_cursor FOR
2531: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22
2532: FROM HZ_STAGED_PARTY_SITES stage
2533: WHERE contains( concat_col, p_contains_str)>0
2534: AND( (l_search_merged ='Y' )
2535: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2532: FROM HZ_STAGED_PARTY_SITES stage

2528: END IF;
2529: IF p_search_rel_sites = 'N' THEN
2530: OPEN x_cursor FOR
2531: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22
2532: FROM HZ_STAGED_PARTY_SITES stage
2533: WHERE contains( concat_col, p_contains_str)>0
2534: AND( (l_search_merged ='Y' )
2535: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2536: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2540: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22

2536: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2537: AND stage.party_id = p_party_id;
2538: ELSE
2539: OPEN x_cursor FOR
2540: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22
2541: FROM HZ_STAGED_PARTY_SITES stage
2542: WHERE contains( concat_col, p_contains_str)>0
2543: AND( (l_search_merged ='Y' )
2544: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2541: FROM HZ_STAGED_PARTY_SITES stage

2537: AND stage.party_id = p_party_id;
2538: ELSE
2539: OPEN x_cursor FOR
2540: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22
2541: FROM HZ_STAGED_PARTY_SITES stage
2542: WHERE contains( concat_col, p_contains_str)>0
2543: AND( (l_search_merged ='Y' )
2544: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2545: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2548: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22

2544: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2545: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2546: AND stage.party_id = p_party_id
2547: UNION
2548: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22
2549: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
2550: WHERE contains( concat_col, p_contains_str)>0
2551: AND( (l_search_merged ='Y' )
2552: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2549: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc

2545: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2546: AND stage.party_id = p_party_id
2547: UNION
2548: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22
2549: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
2550: WHERE contains( concat_col, p_contains_str)>0
2551: AND( (l_search_merged ='Y' )
2552: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2553: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2571: FROM HZ_STAGED_PARTY_SITES stage

2567: 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);
2568: END IF;
2569: OPEN x_cursor FOR
2570: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22
2571: FROM HZ_STAGED_PARTY_SITES stage
2572: WHERE contains( concat_col, p_contains_str)>0
2573: AND EXISTS (
2574: SELECT 1 FROM HZ_STAGED_PARTIES p
2575: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2591: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

2587: END IF;
2588: IF p_person_api = 'Y' THEN
2589: OPEN x_cursor FOR
2590: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22
2591: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2592: WHERE contains( concat_col, p_contains_str)>0
2593: AND( (l_search_merged ='Y' )
2594: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2595: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2600: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22

2596: AND d.search_context_id = p_search_ctx_id
2597: AND d.party_id = stage.party_id
2598: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2599: UNION
2600: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22
2601: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2602: WHERE contains( concat_col, p_contains_str)>0
2603: AND( (l_search_merged ='Y' )
2604: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2601: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage

2597: AND d.party_id = stage.party_id
2598: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2599: UNION
2600: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22
2601: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2602: WHERE contains( concat_col, p_contains_str)>0
2603: AND( (l_search_merged ='Y' )
2604: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2605: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2614: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

2610: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2611: ELSE
2612: OPEN x_cursor FOR
2613: SELECT PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22
2614: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2615: WHERE contains( concat_col, p_contains_str)>0
2616: AND( (l_search_merged ='Y' )
2617: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2618: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2634: l_hint := '/+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) /';

2630: IF (l_check_dt > 0 ) THEN
2631: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2632: hz_utility_v2pub.debug(p_message=>'Restrict sql has the selective_ps hint',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2633: END IF;
2634: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
2635: ELSIF (l_check > 0 ) THEN
2636: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2637: 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);
2638: END IF;

Line 2639: l_hint := '/+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) /';

2635: ELSIF (l_check > 0 ) THEN
2636: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2637: 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);
2638: END IF;
2639: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */';
2640: END IF;
2641: IF l_search_merged = 'Y' THEN
2642: l_status_sql := ' ' ;
2643: ELSIF l_search_merged = 'I' THEN

Line 2658: l_sqlstr := 'SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22'||

2654: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2655: ELSE
2656: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2657: END IF;
2658: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22'||
2659: ' FROM HZ_STAGED_PARTY_SITES stage'||
2660: ' WHERE contains( concat_col, :cont)>0'||
2661: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2662: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2659: ' FROM HZ_STAGED_PARTY_SITES stage'||

2655: ELSE
2656: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2657: END IF;
2658: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22'||
2659: ' FROM HZ_STAGED_PARTY_SITES stage'||
2660: ' WHERE contains( concat_col, :cont)>0'||
2661: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2662: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2663: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2668: 'SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22'||

2664: ' AND (ORG_CONTACT_ID IS NULL ' ||
2665: ' AND ('||p_restrict_sql||'))' ||
2666: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2667: ' UNION ' ||
2668: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22'||
2669: ' FROM HZ_STAGED_PARTY_SITES stage'||
2670: ' WHERE contains( concat_col, :cont)>0'||
2671: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2672: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2669: ' FROM HZ_STAGED_PARTY_SITES stage'||

2665: ' AND ('||p_restrict_sql||'))' ||
2666: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2667: ' UNION ' ||
2668: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22'||
2669: ' FROM HZ_STAGED_PARTY_SITES stage'||
2670: ' WHERE contains( concat_col, :cont)>0'||
2671: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2672: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2673: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2684: ' FROM HZ_STAGED_PARTY_SITES stage'||

2680: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2681: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2682: ELSE
2683: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22'||
2684: ' FROM HZ_STAGED_PARTY_SITES stage'||
2685: ' WHERE contains( concat_col, :cont)>0'||
2686: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2687: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2688: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2701: ' FROM HZ_STAGED_PARTY_SITES stage'||

2697: ,p_dup_party_id, p_dup_party_id;
2698: END IF;
2699: ELSE
2700: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22'||
2701: ' FROM HZ_STAGED_PARTY_SITES 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'') ) '||