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.POS_SUP_PROF_PRG_GRP dependencies on AP_SUPPLIERS

Line 7: -- delete pending suppliser user registration of vendors no longer in ap_suppliers table

3:
4: procedure handle_purge(x_return_status OUT NOCOPY VARCHAR2)
5: IS
6: BEGIN
7: -- delete pending suppliser user registration of vendors no longer in ap_suppliers table
8: DELETE FROM fnd_registrations
9: WHERE registration_id IN
10: (SELECT registration_id
11: FROM fnd_registration_details frd

Line 14: (select vendor_id from ap_suppliers where vendor_id= frd.field_value_number) )

10: (SELECT registration_id
11: FROM fnd_registration_details frd
12: WHERE field_name = 'Supplier Number'
13: AND not exists
14: (select vendor_id from ap_suppliers where vendor_id= frd.field_value_number) )
15: AND registration_status <> 'APPROVED';
16:
17: -- Remove all the registrations details that dont have a parent
18: DELETE FROM fnd_registration_details