Clarity

 View Only
Expand all | Collapse all

What is the lookup used for Country in Resource Contact Information?

Jump to Best Answer
  • 1.  What is the lookup used for Country in Resource Contact Information?

    Posted Oct 07, 2014 01:22 AM
      |   view attached

    Hi team,

     

    I was unable to find the lookup used to display the list of countries as drop down list in Resource Properties.

    Home -> Resource management -> Resource -> Properties -> Contact Infomration

     

    Could u pls ur views how we can find the lookup used in such a cases??...

     

    Regards,

    Naga



  • 2.  Re: What is the lookup used for Country in Resource Contact Information?
    Best Answer

    Posted Oct 07, 2014 02:04 AM

    Hi Naga,

     

    That is a system lookup named 'Country browse' (SCH_BROWSE_COUNTRIES). It gets its data from the view 'CMN_COUNTRIES_V'.

     

    select name from CMN_COUNTRIES_V where LANGUAGE_CODE='en' order by name

     

    Normally to find the lookup of an object attribute:

    1) Goto the Object>>Attributes page

    2) Locate the attribute in the list of attributes

    3) Select the required attribute which will show you the lookup name

     

    In this case, I did not find this stock attribute in the resource object. So just did a search for '*country' in the lookups list under Data Administration to get this stock lookup.

     

    Regards,

    Georgy



  • 3.  Re: What is the lookup used for Country in Resource Contact Information?

    Posted Oct 07, 2014 02:06 AM

    Thanks Georgy