APPS.AP_AUTOSELECT_PKG dependencies on AP_SUPPLIERS

Line 895: ' ap_suppliers suppliers, '||

891: ' ps.discount_date '||
892: ' FROM ap_supplier_sites_all sites, '||
893: ' ap_invoices ai, '|| /* inv, '|| Commented for bug#9182499 GSCC Error File.Sql.6 Bug6040657. Changed from ap_invoices_all to ap_invoices */
894: ' ap_payment_schedules ps, '||
895: ' ap_suppliers suppliers, '||
896: ' hz_parties hz '||
897: ' where ai.invoice_id = ps.invoice_id '||
898: ' AND sites.vendor_site_id(+) = ai.vendor_site_id '||
899: ' AND suppliers.vendor_id(+) = ai.vendor_id '||

Line 2964: ' ap_suppliers suppliers, '||

2960: ' ,ps.remit_to_supplier_site remit_to_supplier_site '||
2961: ' ,ps.remit_to_supplier_site_id remit_to_supplier_site_id '||
2962: --End 8217641
2963: ' FROM ap_supplier_sites_all sites, '||
2964: ' ap_suppliers suppliers, '||
2965: ' ap_invoices ai, '|| /* inv, '||Commented for bug#9182499 --Bug6040657. Changed from ap_invoices_all to ap_invoices */
2966: ' ap_payment_schedules_all ps, '||
2967: ' ap_system_parameters_all asp, '||
2968: ' hz_parties hzp, '||

Line 3787: ' ap_suppliers suppliers, '||

3783: ' ,ps.remit_to_supplier_site remit_to_supplier_site '||
3784: ' ,ps.remit_to_supplier_site_id remit_to_supplier_site_id '||
3785: --End 8217641
3786: ' FROM ap_supplier_sites_all sites, '||
3787: ' ap_suppliers suppliers, '||
3788: ' ap_invoices ai, '|| /* inv, '|| Commented for bug#9182499 GSCC Error File.Sql.6 --Bug6040657. Changed from ap_invoices_all to ap_invoices */
3789: ' ap_payment_schedules_all ps, '||
3790: ' ap_system_parameters_all asp, '||
3791: ' hz_parties hzp, '||

Line 4532: from ap_suppliers

4528: AND NOT EXISTS
4529: (SELECT NULL
4530: FROM iby_ext_payee_relationships irel
4531: WHERE irel.party_id = (select party_id
4532: from ap_suppliers
4533: where vendor_id = ASI2.vendor_id)
4534: AND irel.supplier_site_id =ASI2.vendor_site_id
4535: AND irel.remit_party_id = (select party_id
4536: from ap_suppliers

Line 4536: from ap_suppliers

4532: from ap_suppliers
4533: where vendor_id = ASI2.vendor_id)
4534: AND irel.supplier_site_id =ASI2.vendor_site_id
4535: AND irel.remit_party_id = (select party_id
4536: from ap_suppliers
4537: where vendor_id = ASI2.remit_to_supplier_id)
4538: AND irel.remit_supplier_site_id = ASI2.remit_to_supplier_site_id
4539: AND irel.active = 'Y'
4540: AND to_char(l_check_date,'YYYY-MM-DD HH24:MI:SS')