APPS.AP_PURGE_PKG dependencies on MRP_SR_SOURCE_ORG

Line 1725: from mrp_sr_source_org msso

1721: --vendor if it is tied to an inactive rule
1722:
1723: delete from po_purge_vendor_list pvl
1724: where exists (select null
1725: from mrp_sr_source_org msso
1726: where msso.vendor_id = pvl.vendor_id);
1727:
1728: end if;
1729:

Line 3597: from mrp_sr_source_org msso

3593: update po_purge_vendor_list pvl
3594: set double_check_flag = 'N'
3595: where pvl.double_check_flag = 'Y'
3596: and (exists (select null
3597: from mrp_sr_source_org msso
3598: where msso.vendor_id = pvl.vendor_id));
3599:
3600: end if;
3601:

Line 6168: mrp_sr_source_org msso,

6164: update mrp_sourcing_rules msr
6165: set planning_active = 2
6166: where exists (select null
6167: from po_purge_vendor_list pvl,
6168: mrp_sr_source_org msso,
6169: mrp_sr_receipt_org msro
6170: where pvl.vendor_id = msso.vendor_id
6171: and msso.sr_receipt_id = msro.sr_receipt_id
6172: and msro.sourcing_rule_id = msr.sourcing_rule_id

Line 6182: delete from mrp_sr_source_org msso

6178: from po_purge_vendor_list pvl
6179: where pvl.vendor_id = mr.source_vendor_id
6180: and pvl.double_check_flag = 'Y');
6181:
6182: delete from mrp_sr_source_org msso
6183: where exists (select null
6184: from po_purge_vendor_list pvl
6185: where pvl.vendor_id = msso.vendor_id
6186: and pvl.double_check_flag = 'Y');