618: , 1 tp_type
619: , 'Supplier' party_type
620: FROM po_vendors pv
621: , po_vendor_sites_all pvs
622: , org_organization_definitions ood
623: WHERE pv.vendor_id = pvs.vendor_id
624: AND pvs.org_id = ood.organization_id (+)
625: AND pv.vendor_name || '-' || pvs.vendor_site_code LIKE p_vendor
626: AND (p_vendor_site_id IS NULL OR pvs.vendor_site_id = p_vendor_site_id)