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_GEN dependencies on FND_USER

Line 2677: exists (select 'Y' from FND_USER xx where xx.CUSTOMER_ID = temp.party_id

2673: if(regid_proc = true) then
2674: insert into hz_application_trans_gt(app_id,party_id) select 0, temp.party_id from hz_purge_gt temp where
2675:
2676:
2677: exists (select 'Y' from FND_USER xx where xx.CUSTOMER_ID = temp.party_id
2678: )
2679:
2680: or exists (select 'Y' from FND_USER xx where xx.PERSON_PARTY_ID = temp.party_id
2681: )

Line 2680: or exists (select 'Y' from FND_USER xx where xx.PERSON_PARTY_ID = temp.party_id

2676:
2677: exists (select 'Y' from FND_USER xx where xx.CUSTOMER_ID = temp.party_id
2678: )
2679:
2680: or exists (select 'Y' from FND_USER xx where xx.PERSON_PARTY_ID = temp.party_id
2681: )
2682:
2683: or exists (select 'Y' from UMX_REG_REQUESTS xx where xx.REQUESTED_FOR_PARTY_ID = temp.party_id
2684: and (ROWNUM < 2));

Line 2689: exists (select 'Y' from FND_USER xx where xx.CUSTOMER_ID = temp.party_id

2685: else
2686: delete from hz_purge_gt temp where
2687:
2688:
2689: exists (select 'Y' from FND_USER xx where xx.CUSTOMER_ID = temp.party_id
2690: )
2691:
2692: or exists (select 'Y' from FND_USER xx where xx.PERSON_PARTY_ID = temp.party_id
2693: )

Line 2692: or exists (select 'Y' from FND_USER xx where xx.PERSON_PARTY_ID = temp.party_id

2688:
2689: exists (select 'Y' from FND_USER xx where xx.CUSTOMER_ID = temp.party_id
2690: )
2691:
2692: or exists (select 'Y' from FND_USER xx where xx.PERSON_PARTY_ID = temp.party_id
2693: )
2694:
2695: or exists (select 'Y' from UMX_REG_REQUESTS xx where xx.REQUESTED_FOR_PARTY_ID = temp.party_id
2696: and (ROWNUM < 2));