DBA Data[Home] [Help]

APPS.AP_PURGE_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 1774: ap_supplier_sites_all pvs

1770: where ai.vendor_id = pvl.vendor_id)
1771: or exists
1772: (select null
1773: from ap_selected_invoices_all asi,
1774: ap_supplier_sites_all pvs
1775: where asi.vendor_site_id =
1776: pvs.vendor_site_id
1777: and pvs.vendor_id = pvl.vendor_id)
1778: or exists

Line 1879: ap_supplier_sites_all pvs

1875: from ap_invoices_all ai
1876: where ai.vendor_id = pvl.vendor_id)
1877: or exists (select null
1878: from ap_selected_invoices_all asi,
1879: ap_supplier_sites_all pvs
1880: where asi.vendor_site_id =
1881: pvs.vendor_site_id
1882: and pvs.vendor_id = pvl.vendor_id)
1883: or exists (select null

Line 1942: ap_supplier_sites_all pvs

1938:
1939: delete from po_purge_vendor_list pvl
1940: where exists (select null
1941: from ece_tp_details etd,
1942: ap_supplier_sites_all pvs
1943: where etd.tp_header_id = pvs.tp_header_id
1944: and pvs.vendor_id = pvl.vendor_id
1945: and etd.last_update_date > g_activity_date);
1946: --Bug 1781451 Remove from purge list all vendors with last_update_date

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

2389: doc_sequence_value,org_id)
2390: SELECT i.invoice_id, i.vendor_id, v.vendor_site_code, i.invoice_num,
2391: i.invoice_date, i.invoice_amount, b.batch_name, p_purge_name,
2392: i.doc_sequence_id, i.doc_sequence_value,i.org_id
2393: FROM ap_invoices_all i, ap_supplier_sites_all v, ap_batches_all b
2394: WHERE i.vendor_site_id = v.vendor_site_id
2395: AND i.batch_id = b.batch_id (+)
2396: AND i.invoice_id IN (SELECT PL.invoice_id
2397: FROM ap_purge_invoice_list PL

Line 4024: ap_supplier_sites_all pvs

4020: where ai.vendor_id = pvl.vendor_id)
4021: or
4022: exists (select null
4023: from ap_selected_invoices_all asi,
4024: ap_supplier_sites_all pvs
4025: where asi.vendor_site_id = pvs.vendor_site_id
4026: and pvs.vendor_id = pvl.vendor_id)
4027: or
4028: exists (select null

Line 4122: ap_supplier_sites_all pvs

4118: set double_check_flag = 'N'
4119: where pvl.double_check_flag = 'Y'
4120: and (exists (select null
4121: from ece_tp_details etd,
4122: ap_supplier_sites_all pvs
4123: where etd.tp_header_id = pvs.tp_header_id
4124: and pvs.vendor_id = pvl.vendor_id
4125: and etd.last_update_date > g_activity_date));
4126: --Bug 1781451 Update purge list to include only vendors with last_update_date

Line 6593: FROM ap_supplier_sites_all vnd

6589: DELETE
6590: FROM ap_supplier_contacts pc
6591: WHERE pc.org_party_site_id IN
6592: ( SELECT vnd.party_site_id
6593: FROM ap_supplier_sites_all vnd
6594: , po_purge_vendor_list pvl
6595: WHERE pvl.vendor_id = vnd.vendor_id
6596: AND pvl.double_check_flag = 'Y'
6597: );

Line 6601: delete from ap_supplier_sites_all vnd

6597: );
6598: /* Commented for bug#9645593 End */
6599:
6600: -- delete_ap_supplier_sites
6601: delete from ap_supplier_sites_all vnd
6602: where exists
6603: (select null
6604: from po_purge_vendor_list pvl
6605: where pvl.vendor_id = vnd.vendor_id

Line 6619: from ap_supplier_sites_all ps

6615: -- delete_ap_supplier_contacts
6616: delete from ap_supplier_contacts pc
6617: where not exists
6618: (select null
6619: from ap_supplier_sites_all ps
6620: where ps.vendor_site_id = pc.vendor_site_id);
6621: Commented for bug#9645593 End */
6622:
6623: -- bug 5008627. ap_bank_account_uses is obsolete