Attribute Launch Point:
Object: WPMATERIAL
Itemnum: ITEMNUM
Events: Retrieve list
Source Code:
VLOC = mbo.getString("LOCATION")
domainid = 'WPMITEM'
if VLOC is None or VLOC == "":
vlocnull = "status = 'ACTIVE'"
else:
vlocnull = "itemnum in (select itemnum from inventory where location='"+ mbo.getString('LOCATION') +"' AND ITEMSETID = 'ITEMSET' AND SITEID = 'BEDFORD' AND REORDER='1' AND STATUS = 'ACTIVE')"
listWhere = vlocnull
# listWhere = "itemnum in (select itemnum from inventory where location='"+ mbo.getString('LOCATION') +"' AND ITEMSETID = 'SET1' AND SITEID = 'BEDFORD' AND REORDER='1' AND STATUS = 'ACTIVE')"
No comments:
Post a Comment