EBS Customizations (MOSC)

MOSC Banner

How to validate a profile based on the LEVEL_VALUE of the current record?

edited Sep 9, 2015 1:45AM in EBS Customizations (MOSC) Question

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).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center