how to get current org_id in value set?
I created a value-set based on a field of a table.
I want to add (in the Where/Order By zone) the condition:
where current value's org_id equals the current responsibility's org_id
(so that only relevent values for the current responsibility would appear in the value set)
I tried the following code in the value set declaration:
(Where/order by) curr_column.org_id = :$Profiles$.org_id
This code returns error.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Its related e-business suite customisation question.
People should know how to ask questions so they can entice people to answer
Click Here to Expand Forum to Full Width