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 2518: 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

2514: 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);
2515: END IF;
2516: IF p_search_rel_sites = 'N' THEN
2517: OPEN x_cursor FOR
2518: 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
2519: FROM HZ_STAGED_PARTY_SITES stage
2520: WHERE contains( concat_col, p_contains_str)>0
2521: AND( (l_search_merged ='Y' )
2522: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2519: FROM HZ_STAGED_PARTY_SITES stage

2515: END IF;
2516: IF p_search_rel_sites = 'N' THEN
2517: OPEN x_cursor FOR
2518: 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
2519: FROM HZ_STAGED_PARTY_SITES stage
2520: WHERE contains( concat_col, p_contains_str)>0
2521: AND( (l_search_merged ='Y' )
2522: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2523: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2523: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2524: AND stage.party_id = p_party_id;
2525: ELSE
2526: OPEN x_cursor FOR
2527: 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
2528: FROM HZ_STAGED_PARTY_SITES stage
2529: WHERE contains( concat_col, p_contains_str)>0
2530: AND( (l_search_merged ='Y' )
2531: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2528: FROM HZ_STAGED_PARTY_SITES stage

2524: AND stage.party_id = p_party_id;
2525: ELSE
2526: OPEN x_cursor FOR
2527: 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
2528: FROM HZ_STAGED_PARTY_SITES stage
2529: WHERE contains( concat_col, p_contains_str)>0
2530: AND( (l_search_merged ='Y' )
2531: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2532: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

2531: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2532: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2533: AND stage.party_id = p_party_id
2534: UNION
2535: 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
2536: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
2537: WHERE contains( concat_col, p_contains_str)>0
2538: AND( (l_search_merged ='Y' )
2539: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2532: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2533: AND stage.party_id = p_party_id
2534: UNION
2535: 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
2536: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
2537: WHERE contains( concat_col, p_contains_str)>0
2538: AND( (l_search_merged ='Y' )
2539: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2540: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2558: FROM HZ_STAGED_PARTY_SITES stage

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

Line 2578: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

2583: AND d.search_context_id = p_search_ctx_id
2584: AND d.party_id = stage.party_id
2585: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2586: UNION
2587: 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
2588: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2589: WHERE contains( concat_col, p_contains_str)>0
2590: AND( (l_search_merged ='Y' )
2591: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2584: AND d.party_id = stage.party_id
2585: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2586: UNION
2587: 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
2588: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
2589: WHERE contains( concat_col, p_contains_str)>0
2590: AND( (l_search_merged ='Y' )
2591: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2592: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 2601: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage

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

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

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

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

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

2641: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2642: ELSE
2643: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2644: END IF;
2645: 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'||
2646: ' FROM HZ_STAGED_PARTY_SITES stage'||
2647: ' WHERE contains( concat_col, :cont)>0'||
2648: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2649: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2646: ' FROM HZ_STAGED_PARTY_SITES stage'||

2642: ELSE
2643: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2644: END IF;
2645: 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'||
2646: ' FROM HZ_STAGED_PARTY_SITES stage'||
2647: ' WHERE contains( concat_col, :cont)>0'||
2648: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2649: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2650: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

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

2651: ' AND (ORG_CONTACT_ID IS NULL ' ||
2652: ' AND ('||p_restrict_sql||'))' ||
2653: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2654: ' UNION ' ||
2655: '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'||
2656: ' FROM HZ_STAGED_PARTY_SITES stage'||
2657: ' WHERE contains( concat_col, :cont)>0'||
2658: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2659: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2656: ' FROM HZ_STAGED_PARTY_SITES stage'||

2652: ' AND ('||p_restrict_sql||'))' ||
2653: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2654: ' UNION ' ||
2655: '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'||
2656: ' FROM HZ_STAGED_PARTY_SITES stage'||
2657: ' WHERE contains( concat_col, :cont)>0'||
2658: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2659: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2660: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2671: ' FROM HZ_STAGED_PARTY_SITES stage'||

2667: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2668: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2669: ELSE
2670: l_sqlstr := 'SELECT PARTY_SITE_ID, PARTY_ID, ORG_CONTACT_ID , TX9, TX10, TX11, TX13, TX14, TX15, TX20, TX21, TX22'||
2671: ' FROM HZ_STAGED_PARTY_SITES stage'||
2672: ' WHERE contains( concat_col, :cont)>0'||
2673: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2674: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2675: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2688: ' FROM HZ_STAGED_PARTY_SITES stage'||

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