How to get the value from the UDT for the Position DFF?
Hello experts,
We have this requirement where we need to get the values from UDT for the Position DFF. When this DFF Field 'Department' has a value of 'Norca', the LOV for the 'Subdivision' should show the following values from the UDT, but it's not showing any values.
This is the query that we used for the Table value set:
From ff_user_tables t, ff_user_columns c, ff_user_column_instances_f v, fnd_lookup_values_vl lkup
Value Column Name: substr(v.value, 1, 100)
Where Clause: t.base_user_table_name = 'SUBDIVISIONS'-- (name of the UDT)
AND t.user_table_id = c.user_table_id