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 2529: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22

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

Line 2530: FROM HZ_STAGED_PARTY_SITES stage

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

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

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

Line 2539: FROM HZ_STAGED_PARTY_SITES stage

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

Line 2546: 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

2542: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2543: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2544: AND stage.party_id = p_party_id
2545: UNION
2546: 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
2547: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
2548: WHERE contains( concat_col, p_contains_str)>0
2549: AND( (l_search_merged ='Y' )
2550: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2543: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2544: AND stage.party_id = p_party_id
2545: UNION
2546: 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
2547: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
2548: WHERE contains( concat_col, p_contains_str)>0
2549: AND( (l_search_merged ='Y' )
2550: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2551: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2569: FROM HZ_STAGED_PARTY_SITES stage

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

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

2584: 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);
2585: END IF;
2586: IF p_person_api = 'Y' THEN
2587: OPEN x_cursor FOR
2588: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22
2589: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2590: WHERE contains( concat_col, p_contains_str)>0
2591: AND( (l_search_merged ='Y' )
2592: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2589: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

Line 2598: 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

2594: AND d.search_context_id = p_search_ctx_id
2595: AND d.party_id = stage.party_id
2596: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2597: UNION
2598: 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
2599: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2600: WHERE contains( concat_col, p_contains_str)>0
2601: AND( (l_search_merged ='Y' )
2602: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2595: AND d.party_id = stage.party_id
2596: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2597: UNION
2598: 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
2599: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2600: WHERE contains( concat_col, p_contains_str)>0
2601: AND( (l_search_merged ='Y' )
2602: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2603: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2607: AND oc.org_contact_id = stage.org_contact_id
2608: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2609: ELSE
2610: OPEN x_cursor FOR
2611: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22
2612: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2613: WHERE contains( concat_col, p_contains_str)>0
2614: AND( (l_search_merged ='Y' )
2615: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2612: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

2628: IF (l_check_dt > 0 ) THEN
2629: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2630: 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);
2631: END IF;
2632: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
2633: ELSIF (l_check > 0 ) THEN
2634: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2635: 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);
2636: END IF;

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

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

Line 2656: 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'||

2652: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2653: ELSE
2654: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2655: END IF;
2656: 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'||
2657: ' FROM HZ_STAGED_PARTY_SITES stage'||
2658: ' WHERE contains( concat_col, :cont)>0'||
2659: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2660: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2657: ' FROM HZ_STAGED_PARTY_SITES stage'||

2653: ELSE
2654: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2655: END IF;
2656: 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'||
2657: ' FROM HZ_STAGED_PARTY_SITES stage'||
2658: ' WHERE contains( concat_col, :cont)>0'||
2659: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2660: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2661: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

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

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

Line 2667: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 2682: ' FROM HZ_STAGED_PARTY_SITES stage'||

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

Line 2699: ' FROM HZ_STAGED_PARTY_SITES stage'||

2695: ,p_dup_party_id, p_dup_party_id;
2696: END IF;
2697: ELSE
2698: l_sqlstr := 'SELECT ' || l_hint ||' PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX3, TX4, TX9, TX11, TX12, TX14, TX20, TX22'||
2699: ' FROM HZ_STAGED_PARTY_SITES stage'||
2700: ' WHERE contains( concat_col, :cont)>0'||
2701: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2702: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2703: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

APPS.HZ_MATCH_RULE_42 dependencies on HZ_STAGED_PARTY_SITES

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