Answer / kranthi kumar

Lookups are referred in more locations.
instead of storing the original value,we can store the
lookup codes.
this will reduce the space that is occupied in the database.
this is one reason.

the main reason is..

take an example...

in a table xx_emp there is one column gender.

possible values are
male m
female f
other o

define the above values in a lookup.

if u want to change the male to female ..u go and update
the lookups then automatically all the records referring to
that lookup will also change dynamically...

This saves time and complexity.

hope this clears the above question..........

Answer / shagul

Lookup's are generally used to refer the values ,

assume job , Manager alias MGR assign as lookup codes,

lookups are table values , if need to change just update the
MGR it ful fill the updatation,

update the look up


it ll saves times and complicity

hope u got the answer

Answer / swarna.alizerla

Lookups are the tables where the client expected format is
found.
For example if we get the data like 'PROJECT MANAGER' and
the client wants that in the 'project manager' then these
lookups are used.

which is the table for storing organization information?

9 Answers   Infosys, Scan Steel,

---

what is the defference between credit memo and debit memo

2 Answers  

---

What is profile and what is level of profile option and it's hierarchy

1 Answers   IBM,

---

what is the use of anchors?

2 Answers   IBM,

---

Can we create tables in apps schema?

0 Answers  

---

What are the User PARAMETERS in the Reports?

6 Answers   Accenture, CTS,

---

what is difference between d2k report and oracle apps report

10 Answers   Seven Hills, Wipro,

---

Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

0 Answers  

---

What are the Import Programs We need to run after creating Interface table for all modules

1 Answers   Accenture,

---

What are the tables in GL?

3 Answers   Convergys,

---

In Oracle Apps Some tables ends with TL,VL,what is the significance of the TL and VL?

9 Answers   TCS,

---

How to move the one file from one instance to another instance? And your scripts also?

0 Answers  

---