WMS Rules Engine SQL EXpressions self referal

Hi,

I am trying to create a SQL Expression for a Pick Rule to find the largest UOM Conversion for an Item that will satisfy the requested qty (in eaches) for a transaction at Pick Release.

My quandary is how to reference the inventory_item_id of the item in the transaction in the SQL expression.

I have found some examples that use "base." and 'mptdtv.' as the table reference, but those are generating syntax errors when I try to enable the rule.

Anyone know what table reference to use when creating SQL expressions in the Rules Engine for objects that are part of the transaction?