APPS.POS_SUP_PROF_MRG_GRP dependencies on PO_VENDORS

Line 90: SET field_value_string = (SELECT vendor_name FROM po_vendors WHERE vendor_id = p_new_vendor_id)

86: AND attribute_application_id = 177
87: AND number_value = p_old_vendor_id;
88:
89: UPDATE fnd_registration_details
90: SET field_value_string = (SELECT vendor_name FROM po_vendors WHERE vendor_id = p_new_vendor_id)
91: WHERE field_name = 'Supplier Name'
92: AND registration_id IN
93: (SELECT DISTINCT registration_id
94: FROM fnd_registration_details WHERE field_name = 'Supplier Number'