DBA Data[Home] [Help]

APPS.POS_SUP_PROF_MRG_GRP dependencies on PO_VENDORS

Line 105: SET field_value_string = (SELECT vendor_name FROM po_vendors WHERE vendor_id = p_new_vendor_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
109: FROM fnd_registration_details WHERE field_name = 'Supplier Number'