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 2770: exists (select 'Y' from FND_USER xx where xx.CUSTOMER_ID = temp.party_id

2766: if(regid_proc = true) then
2767: insert into hz_application_trans_gt(app_id,party_id) select 0, temp.party_id from hz_purge_gt temp where
2768:
2769:
2770: exists (select 'Y' from FND_USER xx where xx.CUSTOMER_ID = temp.party_id
2771: )
2772:
2773: or exists (select 'Y' from FND_USER xx where xx.PERSON_PARTY_ID = temp.party_id
2774: )

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

2769:
2770: exists (select 'Y' from FND_USER xx where xx.CUSTOMER_ID = temp.party_id
2771: )
2772:
2773: or exists (select 'Y' from FND_USER xx where xx.PERSON_PARTY_ID = temp.party_id
2774: )
2775:
2776: or exists (select 'Y' from UMX_REG_REQUESTS xx where xx.REQUESTED_FOR_PARTY_ID = temp.party_id
2777: and (ROWNUM < 2));

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

2778: else
2779: delete from hz_purge_gt temp where
2780:
2781:
2782: exists (select 'Y' from FND_USER xx where xx.CUSTOMER_ID = temp.party_id
2783: )
2784:
2785: or exists (select 'Y' from FND_USER xx where xx.PERSON_PARTY_ID = temp.party_id
2786: )

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

2781:
2782: exists (select 'Y' from FND_USER xx where xx.CUSTOMER_ID = temp.party_id
2783: )
2784:
2785: or exists (select 'Y' from FND_USER xx where xx.PERSON_PARTY_ID = temp.party_id
2786: )
2787:
2788: or exists (select 'Y' from UMX_REG_REQUESTS xx where xx.REQUESTED_FOR_PARTY_ID = temp.party_id
2789: and (ROWNUM < 2));