APPS.POS_VENDOR_UTIL_PKG dependencies on FND_REGISTRATIONS

Line 51: (select fr.registration_id from fnd_registrations fr,

47: , last_updated_by = 1, last_update_date = sysdate
48: where application_id = 177
49: and field_name = 'Supplier Name'
50: and registration_id in
51: (select fr.registration_id from fnd_registrations fr,
52: fnd_registration_details frd
53: where registration_status IN ('INVITED', 'REGISTERED')
54: and frd.registration_id = fr.registration_id
55: and frd.field_name = 'Supplier Number'

Line 67: (select registration_id from fnd_registrations

63: where field_value_number = p_dup_vendor_id
64: and application_id = 177
65: and field_name = 'Supplier Number'
66: and registration_id in
67: (select registration_id from fnd_registrations
68: where registration_status IN ('INVITED', 'REGISTERED')
69: );
70: EXCEPTION
71: WHEN OTHERS THEN