DBA Data[Home] [Help]

APPS.PO_VENDORMERGE_GRP dependencies on PO_RFQ_VENDORS

Line 177: UPDATE po_rfq_vendors

173: WHERE pods.style_id = ph.style_id
174: AND NVL(pods.CLM_FLAG,'N') = 'Y');
175:
176:
177: UPDATE po_rfq_vendors
178: SET vendor_id = p_vendor_id,
179: vendor_site_id = p_vendor_site_id,
180: last_updated_by = l_last_updated_by,
181: last_update_date = sysdate

Line 185: DELETE from po_rfq_vendors prv

181: last_update_date = sysdate
182: WHERE vendor_id = p_dup_vendor_id
183: AND vendor_site_id = p_dup_vendor_site_id ;
184:
185: DELETE from po_rfq_vendors prv
186: WHERE vendor_id = p_dup_vendor_id
187: AND vendor_site_id = p_dup_vendor_site_id;
188:
189: