How to define SQL expression in WMS rules to reference data elements in current task
I want to define a SQL expression in WMS rule that restricts data returned based on the transaction_temp_id of the allocation for the current task - is this possible and if so what is the syntax?
I need to do this to be able to return a value from a custom table that is linked thru' a value in wip_requirement_operations DFF attribute, which in turn is linked to mtl_material_transactions_temp for allocations/WMS picking tasks generated via WIP component pick release.
My prototype SQL is as follows, but I don't know how to write the syntax for referencing the transaction_temp_id of the current task.