Inventory Management - EBS (MOSC)

MOSC Banner

How to define SQL expression in WMS rules to reference data elements in current task

edited Sep 2, 2016 5:00AM in Inventory Management - EBS (MOSC) 7 commentsAnswered
Hi,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center