Vendor Sites Active/InActive PLSQL Query & Supplier Query

http://aporaclepayables.blogspot.com/2016/01/vendor-sites-activeinactive-plsql-query.htm

select asa.vendor_name,pvsa.VENDOR_SITE_ID, pvsa.VENDOR_SITE_CODE, pvsa.ORG_ID from po_vendor_sites_all pvsa, ap_suppliers asa
where asa.vendor_id=pvsa.VENDOR_ID
and asa.vendor_name like '3%'
for update

update po_vendor_sites_all pvsa
set inactive_date=''
where pvsa.VENDOR_SITE_ID=539

select hps.party_site_id, asa.vendor_name, pvsa.VENDOR_SITE_CODE, pvsa.ORG_ID, hps.status from hz_party_sites hps, po_vendor_sites_all pvsa, ap_suppliers asa
where hps.party_site_id=pvsa.PARTY_SITE_ID
and asa.vendor_id=pvsa.VENDOR_ID
and asa.vendor_name like '7%'

update hz_party_sites hps
set hps.status='I'

where hps.party_site_id=81418


Supplier Query

select asa.vendor_id, asa.vendor_name, asa.creation_date, pvsa.VENDOR_SITE_ID, pvsa.VENDOR_SITE_CODE, pvsa.ADDRESS_LINE1
,pvsa.ORG_ID, hp.party_id, hp.party_name, hps.party_site_id, hps.party_site_name, hl.location_id, hl.address1
 from hz_party_sites hps, hz_parties hp, hz_locations hl, po_vendor_sites_all pvsa, ap_suppliers asa
where hps.party_id=hp.party_id
and hps.location_id=hl.location_id
and hps.party_site_id=pvsa.PARTY_SITE_ID
and asa.vendor_id=pvsa.VENDOR_ID

and hp.party_name = '?'