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 287: -- to temp table HZ_MERGE_PARTIES_SUGG and HZ_MERGE_PARTYDTLS_SUGG

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

Line 2183: FROM HZ_MERGE_PARTIES_SUGG

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

Line 2186: DELETE FROM HZ_MERGE_PARTIES_SUGG

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

Line 2189: INSERT INTO HZ_MERGE_PARTIES_SUGG

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

Line 2249: FROM HZ_MERGE_PARTIES_SUGG

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

Line 2319: , HZ_MERGE_PARTIES_SUGG mp

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

Line 2332: from HZ_MERGE_PARTIES_SUGG

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

Line 2344: from HZ_MERGE_PARTIES_SUGG mp

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

Line 2356: from HZ_MERGE_PARTIES_SUGG mp

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

Line 2376: from HZ_MERGE_PARTIES_SUGG mp

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

Line 2389: from HZ_MERGE_PARTIES_SUGG mp

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

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

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

Line 2580: FROM HZ_MERGE_PARTIES_SUGG

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

Line 2586: , HZ_MERGE_PARTIES_SUGG mps

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

Line 2759: , HZ_MERGE_PARTIES_SUGG mp

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

Line 2780: from HZ_MERGE_PARTIES_SUGG mp

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

Line 2799: from HZ_MERGE_PARTIES_SUGG

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

Line 2817: from HZ_MERGE_PARTIES_SUGG mp

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

Line 2827: from HZ_MERGE_PARTIES_SUGG mp

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

Line 2958: FROM HZ_MERGE_PARTIES_SUGG

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

Line 2964: , HZ_MERGE_PARTIES_SUGG mps

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

Line 2983: HZ_MERGE_PARTIES_SUGG mpsi

2979: 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
2980: AND NOT EXISTS
2981: ( SELECT 1
2982: FROM HZ_MERGE_PARTYDTLS_SUGG mpdi,
2983: HZ_MERGE_PARTIES_SUGG mpsi
2984: WHERE mpdi.batch_party_id = mpsi.batch_party_id
2985: AND mpsi.batch_id = mps.batch_id
2986: AND mpdi.merge_to_entity_id = rel.relationship_id
2987: AND mpdi.merge_to_entity_id <> mpdi.merge_from_entity_id

Line 3320: select HZ_MERGE_PARTIES_S.nextval into x_batch_party_id

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

Line 3323: INSERT INTO HZ_MERGE_PARTIES_SUGG

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

Line 3441: FROM HZ_MERGE_PARTIES_SUGG

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

Line 3481: FROM HZ_MERGE_PARTIES_SUGG mp

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

Line 3561: , HZ_MERGE_PARTIES_SUGG b

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

Line 3602: FROM HZ_MERGE_PARTIES_SUGG

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

Line 3660: FROM HZ_MERGE_PARTIES_SUGG

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