How to Find the Lookup Both Functional and Technical level

Lookups are an approach of creating a configurable “list of values” in E-Business Suite. The main purpose of a lookup is to keep programs flexible and easier to configure.

Finding the Lookups in back end

Select * from Fnd_Lookup_Values;

For example my lookups is 'XXTC_MODEL_ATTRIBUTES'

Select Application_Id, Meaning,Lookup_Type  From Fnd_Lookup_Values where Lookup_Type      ='XXTC_MODEL_ATTRIBUTES';

Now you can find the this lookups comes under in which module

Take application id , query the below query 

SELECT   application_name,  Application_Short_Name,  FAN.application_id

FROM   Fnd_Application FAN,   Fnd_Application_Tl FAT

              WHERE  FAN.application_id   = 401 AND FAN.Application_Id = FAT.Application_Id

ORDER BY   FAN.application_id;

Now you can get Your lookups comes under in which module .

Now you can log on EBS .

Goto particular Module Responsibility 

 

  Then click the Lookups

 

Then query your lookups name in type field ,then you find the lookups details and meaning,if you want update or changes means please update and save it