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_PARTIES

Line 935: from HZ_MERGE_PARTIES mp

931: -- clean up merge batch tables
932: DELETE HZ_MERGE_PARTY_DETAILS
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;

Line 938: DELETE HZ_MERGE_PARTIES WHERE batch_id = p_dup_set_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
942: NULL;

Line 1130: from HZ_MERGE_PARTIES mp

1126: -- clean up merge batch tables
1127: DELETE HZ_MERGE_PARTY_DETAILS
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;

Line 1133: DELETE HZ_MERGE_PARTIES WHERE batch_id = p_dup_set_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
1137: NULL;

Line 1362: from HZ_MERGE_PARTIES mp

1358: -- clean up merge batch tables
1359: DELETE HZ_MERGE_PARTY_DETAILS
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;

Line 1365: DELETE HZ_MERGE_PARTIES WHERE batch_id = p_dup_set_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
1369: NULL;

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 1992: from hz_merge_parties mp, hz_parties party

1988: x_msg_data OUT NOCOPY VARCHAR2 ) is
1989:
1990: cursor get_merge_parties_csr is
1991: select party_id
1992: from hz_merge_parties mp, hz_parties party
1993: where (party.party_id = mp.from_party_id or party.party_id = mp.to_party_id)
1994: and mp.batch_id = p_merge_batch_id;
1995:
1996: l_party_id number;

Line 2135: from HZ_MERGE_PARTIES mp

2131: -- clean up merge batch tables
2132: DELETE HZ_MERGE_PARTY_DETAILS
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;

Line 2138: DELETE HZ_MERGE_PARTIES WHERE batch_id = p_dup_set_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
2142: NULL;