Requirement: Restrict the Supplier Name LOV, Restrict supplier which are present in lookup (XXSUPPLIER RESTRICTION AP), restrict for user which are present in lookup. Highlighted LOV field personalization required.
Step1: Create new sequence 19 and put description of personalization, select on condition tab
Trigger Event: WHEN-NEW-FORM-INSTANCE
Condition Query: this sql will fetch the current login user_id and will check whether that user exist in lookup or not.
1 = (SELECT count(meaning) MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = XX SUPPLIER RESTRICTION AP' AND language = 'US' AND UPPER(tag) LIKE '%USER%' AND UPPER(meaning) = (select user_name from fnd_user where user_id= fnd_profile.value('user_id')))