APPS.AP_PURGE_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 1532: ap_supplier_sites_all pvs

1528: where ai.vendor_id = pvl.vendor_id)
1529: or exists
1530: (select null
1531: from ap_selected_invoices_all asi,
1532: ap_supplier_sites_all pvs
1533: where asi.vendor_site_id =
1534: pvs.vendor_site_id
1535: and pvs.vendor_id = pvl.vendor_id)
1536: or exists

Line 1637: ap_supplier_sites_all pvs

1633: from ap_invoices_all ai
1634: where ai.vendor_id = pvl.vendor_id)
1635: or exists (select null
1636: from ap_selected_invoices_all asi,
1637: ap_supplier_sites_all pvs
1638: where asi.vendor_site_id =
1639: pvs.vendor_site_id
1640: and pvs.vendor_id = pvl.vendor_id)
1641: or exists (select null

Line 1700: ap_supplier_sites_all pvs

1696:
1697: delete from po_purge_vendor_list pvl
1698: where exists (select null
1699: from ece_tp_details etd,
1700: ap_supplier_sites_all pvs
1701: where etd.tp_header_id = pvs.tp_header_id
1702: and pvs.vendor_id = pvl.vendor_id
1703: and etd.last_update_date > g_activity_date);
1704: --Bug 1781451 Remove from purge list all vendors with last_update_date

Line 2138: FROM ap_invoices_all i, ap_supplier_sites_all v, ap_batches_all b

2134: doc_sequence_value,org_id)
2135: SELECT i.invoice_id, i.vendor_id, v.vendor_site_code, i.invoice_num,
2136: i.invoice_date, i.invoice_amount, b.batch_name, p_purge_name,
2137: i.doc_sequence_id, i.doc_sequence_value,i.org_id
2138: FROM ap_invoices_all i, ap_supplier_sites_all v, ap_batches_all b
2139: WHERE i.vendor_site_id = v.vendor_site_id
2140: AND i.batch_id = b.batch_id (+)
2141: AND i.invoice_id IN (SELECT PL.invoice_id
2142: FROM ap_purge_invoice_list PL

Line 3520: ap_supplier_sites_all pvs

3516: where ai.vendor_id = pvl.vendor_id)
3517: or
3518: exists (select null
3519: from ap_selected_invoices_all asi,
3520: ap_supplier_sites_all pvs
3521: where asi.vendor_site_id = pvs.vendor_site_id
3522: and pvs.vendor_id = pvl.vendor_id)
3523: or
3524: exists (select null

Line 3618: ap_supplier_sites_all pvs

3614: set double_check_flag = 'N'
3615: where pvl.double_check_flag = 'Y'
3616: and (exists (select null
3617: from ece_tp_details etd,
3618: ap_supplier_sites_all pvs
3619: where etd.tp_header_id = pvs.tp_header_id
3620: and pvs.vendor_id = pvl.vendor_id
3621: and etd.last_update_date > g_activity_date));
3622: --Bug 1781451 Update purge list to include only vendors with last_update_date

Line 6028: delete from ap_supplier_sites_all vnd

6024: END LOOP;
6025: */
6026:
6027: -- delete_ap_supplier_sites
6028: delete from ap_supplier_sites_all vnd
6029: where exists
6030: (select null
6031: from po_purge_vendor_list pvl
6032: where pvl.vendor_id = vnd.vendor_id

Line 6044: from ap_supplier_sites_all ps

6040: -- delete_ap_supplier_contacts
6041: delete from ap_supplier_contacts pc
6042: where not exists
6043: (select null
6044: from ap_supplier_sites_all ps
6045: where ps.vendor_site_id = pc.vendor_site_id);
6046:
6047: -- bug 5008627. ap_bank_account_uses is obsolete
6048: /*