S Corner - Scripts Land

Hello Folks, here I will be posting some important scripts that will help you in your work.

1. List the supplier NUMBER, name, site name AND addresses OF ALL active Suppliers

SELECT aps.segment1, aps.vendor_name, apsa.vendor_site_code, apsa.address_line1,
apsa.address_line2, apsa.address_line3, apsa.city, apsa.state, apsa.zip
FROM ap_suppliers aps, ap_supplier_sites_all apsa
WHERE aps.vendor_id = apsa.vendor_id
AND aps.end_date_active IS NULL
AND apsa.inactive_date IS NULL;

2. List supplier_type='EMPLOYEE' details

SELECT aps.vendor_id,
aps.vendor_name,
apss.vendor_site_code,
apss.vendor_site_id,
apss.address_line1,
apss.city,
apss.state,
apss.zip,
aps.invoice_currency_code inv_curr_code_supp,
apss.invoice_currency_code inv_curr_cod_sup_site,
aps.payment_currency_code pay_curr_code_supp,
apss.payment_currency_code pay_curr_cod_sup_site,
apss.ORG_ID,
'Y' process_flag
FROM ap_suppliers aps,
ap_supplier_sites_all apss
WHERE aps.vendor_id = apss.vendor_id
AND aps.invoice_currency_code != apss.invoice_currency_code
AND aps.vendor_type_lookup_code = 'EMPLOYEE';