1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Value Sets and Lookup_Type used in Value Set Form

Discussion in 'Oracle Apps Technical' started by pratikbhopal, Jul 18, 2013.

  1. pratikbhopal

    pratikbhopal Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Value sets table uses codes (U P I D Y X N F) to identify validation types. Can someone tell me which lookup is used to identify these codes?
     

    Attached Files:

  2. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi

    Check the below query.

    select * from fnd_lookup_values where lookup_type = 'SEG_VAL_TYPES'


    Regards
    Sambasiva Reddy.K
     
    pratikbhopal likes this.
  3. pratikbhopal

    pratikbhopal Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Thanks Sambasiva...it worked. :hurray

    I tried hard but couldn't find it :(...

    Is there any way to see what value sets or lookups are being used in a form?
     
  4. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi

    Already you know I - Independent right?

    Now you can go by reverse way.

    that means

    select * from fnd_lookup_values where lookup_code = 'I' and meaning like 'Independent' ;

    like this you can check.


    Regards
    Sambasiva Reddy.K