APPS.AP_PURGE_PKG dependencies on MRP_RECOMMENDATIONS

Line 6175: update mrp_recommendations mr

6171: and msso.sr_receipt_id = msro.sr_receipt_id
6172: and msro.sourcing_rule_id = msr.sourcing_rule_id
6173: and pvl.double_check_flag = 'Y');
6174:
6175: update mrp_recommendations mr
6176: set source_vendor_id = null, source_vendor_site_id = null
6177: where exists (select null
6178: from po_purge_vendor_list pvl
6179: where pvl.vendor_id = mr.source_vendor_id