Query to Define Value Set for Customer

Query to Define Value Set for Customer

select RTRIM (RPAD (SUBSTRB (party_name, 1, 50), 36)) customer_name from hz_parties
where
party_type = 'ORGANIZATION'
and party_name <> '%'
and party_name not like 'cancel%'
Order by party_name