Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
How to write the where clause for a table-based value set, to extract the data based on the item num — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to write the where clause for a table-based value set, to extract the data based on the item num

Received Response
49
Views
4
Comments
edited Jul 30, 2019 5:34PM in Purchasing 4 comments

Summary

How to write the where clause for a table-based value set, to extract the data based on the item number in the current object

Content

A DFF segment "Package String" is created under PO_ATTRIBUTE_VALUES, which is agreement additional line level.
The value set is expected to be a table based value set, which shall extract the list of value based on the item id at the current agreement line. For example, when the agreement line item is "500018", then the lov of that DFF should be all UOM conversion rates defined for that item.

The question is, how to identify the item number (or item id) in the where clause of the sql? We did try to use "

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!