APPS.AP_PURGE_PKG dependencies on MRP_RECOMMENDATIONS

Line 6751: update mrp_recommendations mr

6747: and msso.sr_receipt_id = msro.sr_receipt_id
6748: and msro.sourcing_rule_id = msr.sourcing_rule_id
6749: and pvl.double_check_flag = 'Y');
6750:
6751: update mrp_recommendations mr
6752: set source_vendor_id = null, source_vendor_site_id = null
6753: where exists (select null
6754: from po_purge_vendor_list pvl
6755: where pvl.vendor_id = mr.source_vendor_id