Beth AP Supplier label list

Description
Columns: Vendor Site Id, Last Update Date, Last Updated By, Vendor Id, Vendor Site Code, Vendor Site Code Alt, Last Update Login, Creation Date, Created By, Purchasing Site Flag ...
Beth AP supplier list for Labels
select
*					    
From
AP_SUPPLIER_SITES_ALL assa,
ap_suppliers asu 
where
assa.Vendor_ID=asu.Vendor_ID
and
1=1
Parameter Name SQL text Validation
Supplier Number
asu.segment1=:supplier_number
LOV
Country
assa.country=:country
LOV