100: WHERE attribute_code = 'ICX_SUPPLIER_ORG_ID'
101: AND attribute_application_id = 177
102: AND number_value = p_old_vendor_id;
103:
104: UPDATE fnd_registration_details
105: SET field_value_string = (SELECT vendor_name FROM po_vendors WHERE vendor_id = p_new_vendor_id)
106: WHERE field_name = 'Supplier Name'
107: AND registration_id IN
108: (SELECT DISTINCT registration_id
105: SET field_value_string = (SELECT vendor_name FROM po_vendors WHERE vendor_id = p_new_vendor_id)
106: WHERE field_name = 'Supplier Name'
107: AND registration_id IN
108: (SELECT DISTINCT registration_id
109: FROM fnd_registration_details WHERE field_name = 'Supplier Number'
110: AND field_value_number = p_old_vendor_id
111: );
112:
113: UPDATE fnd_registration_details
109: FROM fnd_registration_details WHERE field_name = 'Supplier Number'
110: AND field_value_number = p_old_vendor_id
111: );
112:
113: UPDATE fnd_registration_details
114: SET field_value_number = p_new_vendor_id
115: WHERE field_name = 'Supplier Number'
116: AND registration_id IN
117: (SELECT DISTINCT registration_id
114: SET field_value_number = p_new_vendor_id
115: WHERE field_name = 'Supplier Number'
116: AND registration_id IN
117: (SELECT DISTINCT registration_id
118: FROM fnd_registration_details WHERE field_name = 'Supplier Number'
119: AND field_value_number = p_old_vendor_id
120: );
121:
122: END IF;