Allocation Picking Rules use LPN expression not work

Hi Guru,

i'm using expression in wms picking rules like this :

ALlocation Mode : Allocate Entire LPN Only

Object : License Plate

Parameter : License Plate Number / License Plate Identifier

Operatior : IN

Object : Expression

Value :

select wlpn.license_plate_number from WMS_LPN_CONTENTS wlc, wms_license_plate_numbers wlpn where wlpn.LPN_ID = wlc.parent_lpn_id and wlc.attribute1 is not null and wlc.attribute1 = '1'

or

select wlpn.lpn_id from WMS_LPN_CONTENTS wlc, wms_license_plate_numbers wlpn where wlpn.LPN_ID = wlc.parent_lpn_id and wlc.attribute1 is not null and wlc.attribute1 = '1'