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_PURGE dependencies on HZ_CODE_ASSIGNMENTS

Line 641: execute immediate 'DELETE from HZ_CODE_ASSIGNMENTS where OWNER_TABLE_ID in

637: ( select PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID in
638: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED'));
639: log(' HZ_PARTY_SITE_USES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
640:
641: execute immediate 'DELETE from HZ_CODE_ASSIGNMENTS where OWNER_TABLE_ID in
642: ( select PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID in
643: (select candidate_party_id from hz_purge_candidates where batch_id=:1 and status=''IDENTIFIED''))
644: and OWNER_TABLE_NAME=''HZ_PARTY_SITES''' using batchid;
645: log(' HZ_CODE_ASSIGNMENTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);

Line 645: log(' HZ_CODE_ASSIGNMENTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);

641: execute immediate 'DELETE from HZ_CODE_ASSIGNMENTS where OWNER_TABLE_ID in
642: ( select PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID in
643: (select candidate_party_id from hz_purge_candidates where batch_id=:1 and status=''IDENTIFIED''))
644: and OWNER_TABLE_NAME=''HZ_PARTY_SITES''' using batchid;
645: log(' HZ_CODE_ASSIGNMENTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
646:
647: execute immediate 'DELETE from HZ_CONTACT_PREFERENCES where CONTACT_LEVEL_TABLE_ID in
648: ( select PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID in
649: (select candidate_party_id from hz_purge_candidates where batch_id=:1 and status=''IDENTIFIED''))

Line 745: execute immediate 'DELETE from HZ_CODE_ASSIGNMENTS where OWNER_TABLE_ID in

741: log(' HZ_EDUCATION : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
742: DELETE from HZ_INDUSTRIAL_REFERENCE where PARTY_ID in
743: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED');
744: log(' HZ_INDUSTRIAL_REFERENCE : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
745: execute immediate 'DELETE from HZ_CODE_ASSIGNMENTS where OWNER_TABLE_ID in
746: (select candidate_party_id from hz_purge_candidates where batch_id=:1 and status=''IDENTIFIED'')
747: and OWNER_TABLE_NAME=''HZ_PARTIES''' using batchid;
748: log(' HZ_CODE_ASSIGNMENTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
749: execute immediate 'DELETE from HZ_CONTACT_PREFERENCES where CONTACT_LEVEL_TABLE_ID in

Line 748: log(' HZ_CODE_ASSIGNMENTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);

744: log(' HZ_INDUSTRIAL_REFERENCE : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
745: execute immediate 'DELETE from HZ_CODE_ASSIGNMENTS where OWNER_TABLE_ID in
746: (select candidate_party_id from hz_purge_candidates where batch_id=:1 and status=''IDENTIFIED'')
747: and OWNER_TABLE_NAME=''HZ_PARTIES''' using batchid;
748: log(' HZ_CODE_ASSIGNMENTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
749: execute immediate 'DELETE from HZ_CONTACT_PREFERENCES where CONTACT_LEVEL_TABLE_ID in
750: (select candidate_party_id from hz_purge_candidates where batch_id=:1 and status=''IDENTIFIED'')
751: and CONTACT_LEVEL_TABLE=''HZ_PARTIES''' using batchid;
752: log(' HZ_CONTACT_PREFERENCES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);

Line 816: from hz_code_assignments HCA

812: from ZX_REPORT_CODES_ASSOC assoc
813: where assoc.entity_code = 'ZX_PARTY_TAX_PROFILE'
814: and assoc.ENTITY_ID = ptp.party_tax_profile_id)
815: and not exists (Select 'x'
816: from hz_code_assignments HCA
817: where HCA.OWNER_TABLE_NAME = 'ZX_PARTY_TAX_PROFILE'
818: AND HCA.OWNER_TABLE_ID = PTP.PARTY_TAX_PROFILE_ID);
819:
820: DELETE from HZ_PARTIES where party_id in

Line 961: execute immediate 'DELETE from HZ_CODE_ASSIGNMENTS where OWNER_TABLE_ID in

957:
958: DELETE from HZ_PARTY_SITE_USES where PARTY_SITE_ID in
959: ( select PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID = p_party_id);
960:
961: execute immediate 'DELETE from HZ_CODE_ASSIGNMENTS where OWNER_TABLE_ID in
962: ( select PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID = :1) and OWNER_TABLE_NAME=''HZ_PARTY_SITES''' using p_party_id;
963:
964: execute immediate 'DELETE from HZ_CONTACT_PREFERENCES where CONTACT_LEVEL_TABLE_ID in
965: ( select PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID = :1) and CONTACT_LEVEL_TABLE=''HZ_PARTY_SITES''' using p_party_id;

Line 1025: execute immediate 'DELETE from HZ_CODE_ASSIGNMENTS where OWNER_TABLE_ID = :1 and OWNER_TABLE_NAME=''HZ_PARTIES''' using p_party_id;

1021: DELETE from HZ_EDUCATION where PARTY_ID = p_party_id;
1022:
1023: DELETE from HZ_INDUSTRIAL_REFERENCE where PARTY_ID = p_party_id;
1024:
1025: execute immediate 'DELETE from HZ_CODE_ASSIGNMENTS where OWNER_TABLE_ID = :1 and OWNER_TABLE_NAME=''HZ_PARTIES''' using p_party_id;
1026:
1027: execute immediate 'DELETE from HZ_CONTACT_PREFERENCES where CONTACT_LEVEL_TABLE_ID = :1 and CONTACT_LEVEL_TABLE=''HZ_PARTIES''' using p_party_id;
1028:
1029: execute immediate 'DELETE from HZ_ORIG_SYS_REFERENCES where party_id = :1' using p_party_id;

Line 1068: from hz_code_assignments HCA

1064: from ZX_REPORT_CODES_ASSOC assoc
1065: where assoc.entity_code = 'ZX_PARTY_TAX_PROFILE'
1066: and assoc.ENTITY_ID = ptp.party_tax_profile_id)
1067: and not exists (Select 'x'
1068: from hz_code_assignments HCA
1069: where HCA.OWNER_TABLE_NAME = 'ZX_PARTY_TAX_PROFILE'
1070: AND HCA.OWNER_TABLE_ID = PTP.PARTY_TAX_PROFILE_ID);
1071:
1072: DELETE from HZ_PARTIES where party_id = p_party_id;