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_MERGE_DUP_PVT dependencies on HZ_MERGE_PARTIES_S

Line 288: -- to temp table HZ_MERGE_PARTIES_SUGG and HZ_MERGE_PARTYDTLS_SUGG

284: END IF;
285: if p_default_mapping = 'Y'
286: then
287: -- call suggested default to populate suggested default mapping
288: -- to temp table HZ_MERGE_PARTIES_SUGG and HZ_MERGE_PARTYDTLS_SUGG
289: suggested_defaults(l_batch_id, x_return_status, x_msg_count, x_msg_data);
290:
291: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
292: ROLLBACK to create_merge_batch;

Line 2184: FROM HZ_MERGE_PARTIES_SUGG

2180: -- clean up temporary table for suggested defaults
2181: DELETE FROM HZ_MERGE_PARTYDTLS_SUGG
2182: WHERE batch_party_id in
2183: ( SELECT batch_party_id
2184: FROM HZ_MERGE_PARTIES_SUGG
2185: WHERE batch_id = p_batch_id );
2186:
2187: DELETE FROM HZ_MERGE_PARTIES_SUGG
2188: WHERE batch_id = p_batch_id;

Line 2187: DELETE FROM HZ_MERGE_PARTIES_SUGG

2183: ( SELECT batch_party_id
2184: FROM HZ_MERGE_PARTIES_SUGG
2185: WHERE batch_id = p_batch_id );
2186:
2187: DELETE FROM HZ_MERGE_PARTIES_SUGG
2188: WHERE batch_id = p_batch_id;
2189:
2190: INSERT INTO HZ_MERGE_PARTIES_SUGG
2191: (

Line 2190: INSERT INTO HZ_MERGE_PARTIES_SUGG

2186:
2187: DELETE FROM HZ_MERGE_PARTIES_SUGG
2188: WHERE batch_id = p_batch_id;
2189:
2190: INSERT INTO HZ_MERGE_PARTIES_SUGG
2191: (
2192: batch_party_id
2193: ,batch_id
2194: ,merge_type

Line 2250: FROM HZ_MERGE_PARTIES_SUGG

2246: ,object_version_number
2247: FROM HZ_MERGE_PARTY_DETAILS
2248: WHERE batch_party_id IN
2249: ( SELECT batch_party_id
2250: FROM HZ_MERGE_PARTIES_SUGG
2251: WHERE batch_id = p_batch_id );
2252:
2253: -- get match_rule_id from profile
2254:

Line 2320: , HZ_MERGE_PARTIES_SUGG mp

2316: -- merge party details table, the merge_type is 'SAME_PARTY_MERGE'
2317: cursor not_mandatory_sites_mp is
2318: select merge_from_entity_id
2319: from HZ_MERGE_PARTYDTLS_SUGG mpd
2320: , HZ_MERGE_PARTIES_SUGG mp
2321: , hz_party_sites ps
2322: where mpd.batch_party_id = mp.batch_party_id
2323: and mp.batch_id = p_batch_id
2324: and ps.party_id = mp.from_party_id

Line 2333: from HZ_MERGE_PARTIES_SUGG

2329:
2330: -- this is for cleanse single party, find out the batch_party_id
2331: cursor get_merge_party_id is
2332: select batch_party_id, from_party_id
2333: from HZ_MERGE_PARTIES_SUGG
2334: where batch_id = p_batch_id
2335: and merge_type = 'SAME_PARTY_MERGE';
2336:
2337: -- this is for cleanse single party, get all sites which are not mandatory merge

Line 2345: from HZ_MERGE_PARTIES_SUGG mp

2341: where party_id = l_master_party
2342: and status in ('A','I')
2343: and not exists
2344: ( select 1
2345: from HZ_MERGE_PARTIES_SUGG mp
2346: , HZ_MERGE_PARTYDTLS_SUGG mpd
2347: where mp.batch_id = p_batch_id
2348: and mp.batch_party_id = mpd.batch_party_id
2349: and mpd.entity_name = 'HZ_PARTY_SITES'

Line 2357: from HZ_MERGE_PARTIES_SUGG mp

2353: -- for merge multiple parties
2354: -- check if the site is already mapped to some other site
2355: cursor check_mapped_sites_mp(l_from_site_id NUMBER) is
2356: select 'X'
2357: from HZ_MERGE_PARTIES_SUGG mp
2358: , HZ_MERGE_PARTYDTLS_SUGG mpd
2359: where mpd.merge_from_entity_id = l_from_site_id
2360: and mpd.merge_from_entity_id <> mpd.merge_to_entity_id
2361: and mpd.batch_party_id = mp.batch_party_id

Line 2377: from HZ_MERGE_PARTIES_SUGG mp

2373: where mps.search_context_id = l_search_ctx_id
2374: and mps.party_site_id <> l_master_site
2375: and not exists
2376: ( select 1
2377: from HZ_MERGE_PARTIES_SUGG mp
2378: , HZ_MERGE_PARTYDTLS_SUGG mpd
2379: where mpd.merge_to_entity_id = mps.party_site_id
2380: and mpd.batch_party_id = mp.batch_party_id
2381: and mp.batch_id = p_batch_id

Line 2390: from HZ_MERGE_PARTIES_SUGG mp

2386: -- only mapped sites appear in HZ_MERGE_PARTYDTLS_SUGG, therefore if
2387: -- merge_from_entity_id = pass in site_id, then this site is mapped
2388: cursor check_mapped_sites_sp(l_from_site_id NUMBER) is
2389: select 'X'
2390: from HZ_MERGE_PARTIES_SUGG mp
2391: , HZ_MERGE_PARTYDTLS_SUGG mpd
2392: where mpd.merge_from_entity_id = l_from_site_id
2393: and mpd.batch_party_id = mp.batch_party_id
2394: and mp.batch_id = p_batch_id

Line 2480: ' FROM HZ_MERGE_PARTYDTLS_SUGG mpd, HZ_MERGE_PARTIES_SUGG mp' ||

2476: ,p_rule_id => p_rule_id
2477: ,p_party_site_id => l_master_site
2478: ,p_party_id => NULL
2479: ,p_restrict_sql => ' PARTY_SITE_ID IN (SELECT /*+ SELECTIVE_PS */ MERGE_FROM_ENTITY_ID' ||
2480: ' FROM HZ_MERGE_PARTYDTLS_SUGG mpd, HZ_MERGE_PARTIES_SUGG mp' ||
2481: ' WHERE mpd.MERGE_TO_ENTITY_ID = mpd.MERGE_FROM_ENTITY_ID' ||
2482: ' AND mpd.BATCH_PARTY_ID = mp.BATCH_PARTY_ID' ||
2483: ' AND mpd.ENTITY_NAME = ''HZ_PARTY_SITES''' ||
2484: ' AND mp.BATCH_ID = '|| p_batch_id ||')'

Line 2581: FROM HZ_MERGE_PARTIES_SUGG

2577: , last_updated_by = hz_utility_v2pub.last_updated_by
2578: , last_update_login = hz_utility_v2pub.last_update_login
2579: WHERE batch_party_id IN
2580: ( SELECT batch_party_id
2581: FROM HZ_MERGE_PARTIES_SUGG
2582: WHERE batch_id = p_batch_id )
2583: AND merge_from_entity_id IN
2584: ( SELECT party_site_id
2585: FROM HZ_MATCHED_PARTY_SITES_GT matchps

Line 2587: , HZ_MERGE_PARTIES_SUGG mps

2583: AND merge_from_entity_id IN
2584: ( SELECT party_site_id
2585: FROM HZ_MATCHED_PARTY_SITES_GT matchps
2586: , HZ_MERGE_PARTYDTLS_SUGG mpd
2587: , HZ_MERGE_PARTIES_SUGG mps
2588: WHERE matchps.search_context_id = l_search_ctx_id
2589: AND matchps.party_site_id = mpd.merge_from_entity_id
2590: AND mpd.entity_name = 'HZ_PARTY_SITES'
2591: AND mpd.merge_to_entity_id = mpd.merge_from_entity_id

Line 2760: , HZ_MERGE_PARTIES_SUGG mp

2756: -- Oracle Corp and Oracle Inc
2757: cursor not_mandatory_reln_mp is
2758: select rel.relationship_id, rel.relationship_type, rel.relationship_code, rel.object_id, rel.subject_id, rel.subject_type, rel.object_type
2759: from HZ_MERGE_PARTYDTLS_SUGG mpd
2760: , HZ_MERGE_PARTIES_SUGG mp
2761: , HZ_RELATIONSHIPS rel
2762: where mpd.batch_party_id = mp.batch_party_id
2763: and mp.batch_id = p_batch_id
2764: and mpd.entity_name = 'HZ_PARTY_RELATIONSHIPS'

Line 2782: from HZ_MERGE_PARTIES_SUGG mp

2778: from HZ_RELATIONSHIPS rel
2779: where subject_id = l_master_party_id
2780: and not exists
2781: ( select 1
2782: from HZ_MERGE_PARTIES_SUGG mp
2783: , HZ_MERGE_PARTYDTLS_SUGG mpd
2784: , HZ_RELATIONSHIPS rel2
2785: where mp.batch_id = p_batch_id
2786: and mp.batch_party_id = mpd.batch_party_id

Line 2801: from HZ_MERGE_PARTIES_SUGG

2797: -- corresponding party sites to merge. Those batch_party_id will be different. Therefore, we need to filter
2798: -- by merge_type = 'SAME_PARTY_MERGE'
2799: cursor get_merge_party_id is
2800: select batch_party_id, from_party_id
2801: from HZ_MERGE_PARTIES_SUGG
2802: where batch_id = p_batch_id
2803: and merge_type = 'SAME_PARTY_MERGE';
2804:
2805: -- this is for cleanse single party, check if the matched parties is already mapped

Line 2819: from HZ_MERGE_PARTIES_SUGG mp

2815: and rel.relationship_code = l_reln_code
2816: and rel.relationship_type = l_reln_type
2817: and not exists
2818: ( select 1
2819: from HZ_MERGE_PARTIES_SUGG mp
2820: , HZ_MERGE_PARTYDTLS_SUGG mpd
2821: where mpd.merge_to_entity_id = rel.relationship_id
2822: and mpd.batch_party_id = mp.batch_party_id
2823: and mp.batch_id = p_batch_id

Line 2829: from HZ_MERGE_PARTIES_SUGG mp

2825:
2826: -- need to check if relationship is already mapped as merge_from_entity_id
2827: cursor check_mapped_reln(l_from_rel_id NUMBER) is
2828: select 'X'
2829: from HZ_MERGE_PARTIES_SUGG mp
2830: , HZ_MERGE_PARTYDTLS_SUGG mpd
2831: where mpd.merge_from_entity_id = l_from_rel_id
2832: and mpd.batch_party_id = mp.batch_party_id
2833: and mp.batch_id = p_batch_id

Line 2960: FROM HZ_MERGE_PARTIES_SUGG

2956: , last_updated_by = hz_utility_v2pub.last_updated_by
2957: , last_update_login = hz_utility_v2pub.last_update_login
2958: WHERE batch_party_id in
2959: ( SELECT batch_party_id
2960: FROM HZ_MERGE_PARTIES_SUGG
2961: WHERE batch_id = p_batch_id )
2962: AND merge_from_entity_id IN
2963: ( SELECT rel.relationship_id
2964: FROM HZ_MATCHED_PARTIES_GT matchpty

Line 2966: , HZ_MERGE_PARTIES_SUGG mps

2962: AND merge_from_entity_id IN
2963: ( SELECT rel.relationship_id
2964: FROM HZ_MATCHED_PARTIES_GT matchpty
2965: , HZ_MERGE_PARTYDTLS_SUGG mpd
2966: , HZ_MERGE_PARTIES_SUGG mps
2967: , HZ_RELATIONSHIPS rel
2968: , HZ_ORIG_SYSTEMS_B O
2969: WHERE matchpty.search_context_id = l_search_ctx_id
2970: AND matchpty.party_id = rel.object_id

Line 2985: HZ_MERGE_PARTIES_SUGG mpsi

2981: AND decode(o.orig_system_type,'PURCHASED',(decode(l_to_orig_system_type,'PURCHASED',(decode(o.orig_system,l_to_orig_system,1,0)),0)),1)= 1
2982: AND NOT EXISTS
2983: ( SELECT 1
2984: FROM HZ_MERGE_PARTYDTLS_SUGG mpdi,
2985: HZ_MERGE_PARTIES_SUGG mpsi
2986: WHERE mpdi.batch_party_id = mpsi.batch_party_id
2987: AND mpsi.batch_id = mps.batch_id
2988: AND mpdi.merge_to_entity_id = rel.relationship_id
2989: AND mpdi.merge_to_entity_id <> mpdi.merge_from_entity_id

Line 3322: select HZ_MERGE_PARTIES_S.nextval into x_batch_party_id

3318: ) IS
3319:
3320: BEGIN
3321:
3322: select HZ_MERGE_PARTIES_S.nextval into x_batch_party_id
3323: from dual;
3324:
3325: INSERT INTO HZ_MERGE_PARTIES_SUGG
3326: (

Line 3325: INSERT INTO HZ_MERGE_PARTIES_SUGG

3321:
3322: select HZ_MERGE_PARTIES_S.nextval into x_batch_party_id
3323: from dual;
3324:
3325: INSERT INTO HZ_MERGE_PARTIES_SUGG
3326: (
3327: BATCH_PARTY_ID
3328: ,BATCH_ID
3329: ,MERGE_TYPE

Line 3443: FROM HZ_MERGE_PARTIES_SUGG

3439: FROM HZ_MERGE_PARTYDTLS_SUGG
3440: WHERE entity_name = p_entity_name
3441: AND batch_party_id IN
3442: ( SELECT batch_party_id
3443: FROM HZ_MERGE_PARTIES_SUGG
3444: WHERE batch_id = p_batch_id );
3445:
3446: -- if entity is HZ_RELATIONSHIPS, insert DUPLICATE_RELN_PARTY record to
3447: -- HZ_MERGE_PARTIES table as well

Line 3483: FROM HZ_MERGE_PARTIES_SUGG mp

3479: ,creation_date
3480: ,last_update_login
3481: ,last_updated_by
3482: ,last_update_date
3483: FROM HZ_MERGE_PARTIES_SUGG mp
3484: WHERE mp.batch_id = p_batch_id
3485: AND mp.merge_reason_code = 'DUPLICATE_RELN_PARTY';
3486:
3487: END IF;

Line 3563: , HZ_MERGE_PARTIES_SUGG b

3559: CURSOR find_mand_reln IS
3560: SELECT HZ_MERGE_UTIL.get_reln_party_id(a.merge_from_entity_id)
3561: , HZ_MERGE_UTIL.get_reln_party_id(a.merge_from_entity_id)
3562: FROM HZ_MERGE_PARTYDTLS_SUGG a
3563: , HZ_MERGE_PARTIES_SUGG b
3564: WHERE b.batch_id = p_batch_id
3565: AND a.entity_name = 'HZ_PARTY_RELATIONSHIPS'
3566: AND a.batch_party_id = b.batch_party_id
3567: AND a.mandatory_merge = 'Y';

Line 3604: FROM HZ_MERGE_PARTIES_SUGG

3600: mpd.object_version_number = nvl(mpd.object_version_number,1)+1
3601: WHERE entity_name = p_entity_name
3602: AND batch_party_id IN
3603: ( SELECT batch_party_id
3604: FROM HZ_MERGE_PARTIES_SUGG
3605: WHERE batch_id = p_batch_id );
3606:
3607:
3608:

Line 3662: FROM HZ_MERGE_PARTIES_SUGG

3658: WHERE mandatory_merge = 'Y'
3659: AND entity_name = p_entity_name
3660: AND batch_party_id IN
3661: ( SELECT batch_party_id
3662: FROM HZ_MERGE_PARTIES_SUGG
3663: WHERE batch_id = p_batch_id );
3664:
3665: END IF;
3666: