[Home] [Help]
105: --
106: --Since in CLM we have Multi-Mod for Supplier Change, Supplier Merge is not required.
107: --therefore ignore CLM documents
108: --update Commercial Modifications
109: UPDATE po_headers_draft_all pohd
110: SET pohd.vendor_id = p_vendor_id,
111: pohd.vendor_site_id = p_vendor_site_id,
112: pohd.vendor_contact_id = (SELECT vendor_contact_id
113: FROM ap_supplier_contacts