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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

DFF value set to get values for each item at PO line level

edited May 6, 2025 9:31PM in Purchasing 1 comment

I have 2 lines for PO.
Each line has different Item associated to it.
Requirement is to get the HS Code(DFF) Value linked to each item only and not other other items.
Ex: If PO Line 1 has Item=ABC, only HS DFF Value for 'ABC' should be visible in DFF
If PO Line 2 has Item=LMN, only HS DFF Value for 'LMN' should be visible in DFF

Logic used while creating Table Valueset:

FROM: egp_system_items esi,ego_item_eff_b eieb

VALUE: SUBSTR(eieb.attribute_char2,0,30)
Description: eieb.attribute_char3

WHERE:

esi.inventory_item_id = eieb.inventory_item_id

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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