How to validate a profile based on the LEVEL_VALUE of the current record?
My question is specific to the POR_DEFAULT_SUBINVENTORY profile in E-Business suite version 11i.
The profile has the below validation query:
SQL="select secondary_inventory_name, secondary_inventory_name \"SubInventory\"
into :profile_option_value, :visible_option_value
from mtl_secondary_inventories where sysdate < nvl(disable_date, sysdate + 1) "
Column="\"SubInventory\"(*)"
The problem with the above validation is that it lists all active subinventories of all active organizations. I want to restrict the list to subinventories belonging to one inventory organization. The inventory organization in question is the one linked to the location selected in the profile "POR : Preferences - Deliver to Location" for the same level_id and same level_value (say for the same user).