APPS.AP_PURGE_PKG dependencies on MRP_SR_SOURCE_ORG

Line 1967: from mrp_sr_source_org msso

1963: --vendor if it is tied to an inactive rule
1964:
1965: delete from po_purge_vendor_list pvl
1966: where exists (select null
1967: from mrp_sr_source_org msso
1968: where msso.vendor_id = pvl.vendor_id);
1969:
1970: end if;
1971:

Line 4101: from mrp_sr_source_org msso

4097: update po_purge_vendor_list pvl
4098: set double_check_flag = 'N'
4099: where pvl.double_check_flag = 'Y'
4100: and (exists (select null
4101: from mrp_sr_source_org msso
4102: where msso.vendor_id = pvl.vendor_id));
4103:
4104: end if;
4105:

Line 6744: mrp_sr_source_org msso,

6740: update mrp_sourcing_rules msr
6741: set planning_active = 2
6742: where exists (select null
6743: from po_purge_vendor_list pvl,
6744: mrp_sr_source_org msso,
6745: mrp_sr_receipt_org msro
6746: where pvl.vendor_id = msso.vendor_id
6747: and msso.sr_receipt_id = msro.sr_receipt_id
6748: and msro.sourcing_rule_id = msr.sourcing_rule_id

Line 6758: delete from mrp_sr_source_org msso

6754: from po_purge_vendor_list pvl
6755: where pvl.vendor_id = mr.source_vendor_id
6756: and pvl.double_check_flag = 'Y');
6757:
6758: delete from mrp_sr_source_org msso
6759: where exists (select null
6760: from po_purge_vendor_list pvl
6761: where pvl.vendor_id = msso.vendor_id
6762: and pvl.double_check_flag = 'Y');