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

Line 2516: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22

2512: 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);
2513: END IF;
2514: IF p_search_rel_sites = 'N' THEN
2515: OPEN x_cursor FOR
2516: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22
2517: FROM HZ_STAGED_PARTY_SITES stage
2518: WHERE contains( concat_col, p_contains_str)>0
2519: AND( (l_search_merged ='Y' )
2520: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2517: FROM HZ_STAGED_PARTY_SITES stage

2513: END IF;
2514: IF p_search_rel_sites = 'N' THEN
2515: OPEN x_cursor FOR
2516: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22
2517: FROM HZ_STAGED_PARTY_SITES stage
2518: WHERE contains( concat_col, p_contains_str)>0
2519: AND( (l_search_merged ='Y' )
2520: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2521: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2525: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22

2521: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2522: AND stage.party_id = p_party_id;
2523: ELSE
2524: OPEN x_cursor FOR
2525: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22
2526: FROM HZ_STAGED_PARTY_SITES stage
2527: WHERE contains( concat_col, p_contains_str)>0
2528: AND( (l_search_merged ='Y' )
2529: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2526: FROM HZ_STAGED_PARTY_SITES stage

2522: AND stage.party_id = p_party_id;
2523: ELSE
2524: OPEN x_cursor FOR
2525: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22
2526: FROM HZ_STAGED_PARTY_SITES stage
2527: WHERE contains( concat_col, p_contains_str)>0
2528: AND( (l_search_merged ='Y' )
2529: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2530: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2533: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22

2529: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2530: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2531: AND stage.party_id = p_party_id
2532: UNION
2533: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22
2534: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
2535: WHERE contains( concat_col, p_contains_str)>0
2536: AND( (l_search_merged ='Y' )
2537: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2530: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2531: AND stage.party_id = p_party_id
2532: UNION
2533: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22
2534: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
2535: WHERE contains( concat_col, p_contains_str)>0
2536: AND( (l_search_merged ='Y' )
2537: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2538: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2556: FROM HZ_STAGED_PARTY_SITES stage

2552: 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);
2553: END IF;
2554: OPEN x_cursor FOR
2555: SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22
2556: FROM HZ_STAGED_PARTY_SITES stage
2557: WHERE contains( concat_col, p_contains_str)>0
2558: AND EXISTS (
2559: SELECT 1 FROM HZ_STAGED_PARTIES p
2560: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2575: SELECT /+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22

2571: 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);
2572: END IF;
2573: IF p_person_api = 'Y' THEN
2574: OPEN x_cursor FOR
2575: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22
2576: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2577: WHERE contains( concat_col, p_contains_str)>0
2578: AND( (l_search_merged ='Y' )
2579: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2576: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

2572: END IF;
2573: IF p_person_api = 'Y' THEN
2574: OPEN x_cursor FOR
2575: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22
2576: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage
2577: WHERE contains( concat_col, p_contains_str)>0
2578: AND( (l_search_merged ='Y' )
2579: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2580: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2585: SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22

2581: AND d.search_context_id = p_search_ctx_id
2582: AND d.party_id = stage.party_id
2583: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2584: UNION
2585: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22
2586: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2587: WHERE contains( concat_col, p_contains_str)>0
2588: AND( (l_search_merged ='Y' )
2589: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2582: AND d.party_id = stage.party_id
2583: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2584: UNION
2585: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22
2586: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2587: WHERE contains( concat_col, p_contains_str)>0
2588: AND( (l_search_merged ='Y' )
2589: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2590: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2598: SELECT /+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22

2594: AND oc.org_contact_id = stage.org_contact_id
2595: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2596: ELSE
2597: OPEN x_cursor FOR
2598: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22
2599: FROM HZ_DQM_PARTIES_GT d, 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_STAGED_PARTY_SITES stage

2595: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2596: ELSE
2597: OPEN x_cursor FOR
2598: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, stage.PARTY_ID, ORG_CONTACT_ID, TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22
2599: FROM HZ_DQM_PARTIES_GT d, 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 2619: l_hint := '/+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) /';

2615: IF (l_check_dt > 0 ) THEN
2616: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2617: 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);
2618: END IF;
2619: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_U1) */';
2620: ELSIF (l_check > 0 ) THEN
2621: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2622: 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);
2623: END IF;

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

2620: ELSIF (l_check > 0 ) THEN
2621: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2622: 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);
2623: END IF;
2624: l_hint := '/*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */';
2625: END IF;
2626: IF l_search_merged = 'Y' THEN
2627: l_status_sql := ' ' ;
2628: ELSIF l_search_merged = 'I' THEN

Line 2643: l_sqlstr := 'SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22'||

2639: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2640: ELSE
2641: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2642: END IF;
2643: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22'||
2644: ' FROM HZ_STAGED_PARTY_SITES stage'||
2645: ' WHERE contains( concat_col, :cont)>0'||
2646: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2647: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2644: ' FROM HZ_STAGED_PARTY_SITES stage'||

2640: ELSE
2641: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2642: END IF;
2643: l_sqlstr := 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22'||
2644: ' FROM HZ_STAGED_PARTY_SITES stage'||
2645: ' WHERE contains( concat_col, :cont)>0'||
2646: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2647: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2648: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2653: 'SELECT /+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) / PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22'||

2649: ' AND (ORG_CONTACT_ID IS NULL ' ||
2650: ' AND ('||p_restrict_sql||'))' ||
2651: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2652: ' UNION ' ||
2653: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22'||
2654: ' FROM HZ_STAGED_PARTY_SITES stage'||
2655: ' WHERE contains( concat_col, :cont)>0'||
2656: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2657: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2654: ' FROM HZ_STAGED_PARTY_SITES stage'||

2650: ' AND ('||p_restrict_sql||'))' ||
2651: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2652: ' UNION ' ||
2653: 'SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22'||
2654: ' FROM HZ_STAGED_PARTY_SITES stage'||
2655: ' WHERE contains( concat_col, :cont)>0'||
2656: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2657: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2658: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2669: ' FROM HZ_STAGED_PARTY_SITES stage'||

2665: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2666: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2667: ELSE
2668: l_sqlstr := 'SELECT ' || l_hint ||' PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, 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 2686: ' FROM HZ_STAGED_PARTY_SITES stage'||

2682: ,p_dup_party_id, p_dup_party_id;
2683: END IF;
2684: ELSE
2685: l_sqlstr := 'SELECT ' || l_hint ||' PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22'||
2686: ' FROM HZ_STAGED_PARTY_SITES stage'||
2687: ' WHERE contains( concat_col, :cont)>0'||
2688: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2689: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2690: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

APPS.HZ_MATCH_RULE_34 dependencies on HZ_STAGED_PARTY_SITES

Line 2516: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID, TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22