Manage Order Extensible Flexfields - Filtering condition to Table type Valueset
We have a requirement to capture soldto site at order line level. User should be able to select sold to site at Sales order line level for the selected customer in Order Header.
Issue facing - trying is to use DOO_FULFILL_LINES_ADD_INFO EFF and created value set for custom field. This is displaying soldto for all customers.
How to add filtering condition to valueset of EFF field so that it displays only for selected customer?
Can we get value of customer selected in Orders Page in context. Is it possible to use in valueset SQL.