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_DUP_PVT dependencies on HZ_MERGE_BATCH

Line 937: DELETE HZ_MERGE_BATCH WHERE batch_id = p_dup_set_id;

933: WHERE batch_party_id
934: in (select batch_party_id
935: from HZ_MERGE_PARTIES mp
936: where mp.batch_id = p_dup_set_id);
937: DELETE HZ_MERGE_BATCH WHERE batch_id = p_dup_set_id;
938: DELETE HZ_MERGE_PARTIES WHERE batch_id = p_dup_set_id;
939: DELETE HZ_MERGE_ENTITY_ATTRIBUTES WHERE merge_batch_id = p_dup_set_id;
940: EXCEPTION
941: WHEN NO_DATA_FOUND THEN

Line 1132: DELETE HZ_MERGE_BATCH WHERE batch_id = p_dup_set_id;

1128: WHERE batch_party_id
1129: in (select batch_party_id
1130: from HZ_MERGE_PARTIES mp
1131: where mp.batch_id = p_dup_set_id);
1132: DELETE HZ_MERGE_BATCH WHERE batch_id = p_dup_set_id;
1133: DELETE HZ_MERGE_PARTIES WHERE batch_id = p_dup_set_id;
1134: DELETE HZ_MERGE_ENTITY_ATTRIBUTES WHERE merge_batch_id = p_dup_set_id;
1135: EXCEPTION
1136: WHEN NO_DATA_FOUND THEN

Line 1364: DELETE HZ_MERGE_BATCH WHERE batch_id = p_dup_set_id;

1360: WHERE batch_party_id
1361: in (select batch_party_id
1362: from HZ_MERGE_PARTIES mp
1363: where mp.batch_id = p_dup_set_id);
1364: DELETE HZ_MERGE_BATCH WHERE batch_id = p_dup_set_id;
1365: DELETE HZ_MERGE_PARTIES WHERE batch_id = p_dup_set_id;
1366: DELETE HZ_MERGE_ENTITY_ATTRIBUTES WHERE merge_batch_id = p_dup_set_id;
1367: EXCEPTION
1368: WHEN NO_DATA_FOUND THEN

Line 1629: from HZ_MERGE_BATCH mb, HZ_MERGE_PARTIES mp

1625: l_default_mapping VARCHAR2(1) DEFAULT 'Y';--Bug 5635453
1626:
1627: cursor check_merge_batch is
1628: select 'X'
1629: from HZ_MERGE_BATCH mb, HZ_MERGE_PARTIES mp
1630: where mb.batch_id = mp.batch_id
1631: and mb.batch_id = p_dup_set_id;
1632:
1633: cursor get_dup_set_obj_version is

Line 2137: DELETE HZ_MERGE_BATCH WHERE batch_id = p_dup_set_id;

2133: WHERE batch_party_id
2134: in (select batch_party_id
2135: from HZ_MERGE_PARTIES mp
2136: where mp.batch_id = p_dup_set_id);
2137: DELETE HZ_MERGE_BATCH WHERE batch_id = p_dup_set_id;
2138: DELETE HZ_MERGE_PARTIES WHERE batch_id = p_dup_set_id;
2139: DELETE HZ_MERGE_ENTITY_ATTRIBUTES WHERE merge_batch_id = p_dup_set_id;
2140: EXCEPTION
2141: WHEN NO_DATA_FOUND THEN

Line 2201: from HZ_MERGE_BATCH mb,

2197: update hz_dup_sets
2198: set status = 'ERROR'
2199: where dup_set_id in
2200: (select dup_set_id
2201: from HZ_MERGE_BATCH mb,
2202: HZ_DUP_SETS ds,
2203: Fnd_Concurrent_Requests r,
2204: FND_CONCURRENT_PROGRAMS cp
2205: where

Line 2222: from HZ_MERGE_BATCH mb,

2218: update hz_dup_sets
2219: set status = 'ERROR'
2220: where dup_set_id in
2221: (select dup_set_id
2222: from HZ_MERGE_BATCH mb,
2223: HZ_DUP_SETS ds,
2224: Fnd_Concurrent_Requests r
2225: where
2226: mb.batch_id = ds.dup_set_id

Line 2287: from hz_merge_batch mb, hz_merge_parties mp

2283: x_overlap_merge_req_id out nocopy number) is
2284:
2285: cursor validate_master_party_id_csr is
2286: select to_party_id, mb.batch_id
2287: from hz_merge_batch mb, hz_merge_parties mp
2288: where mb.batch_id = mp.batch_id
2289: and mp.from_party_id = px_party_id
2290: and mp.to_party_id <> px_party_id
2291: and mb.batch_status <> 'COMPLETED' and rownum = 1;