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.

what is the difference between procedure and function

3 Answers   Wipro,

---

How to call oracle database stored procedure from form in form coding ?

3 Answers   Oracle,

---

i have 3 parameters like p1,p2,p3.In p1 i have 2 parameters like a,b.if pass parameter 'a' p2 should be enable and p3 should be disable then if pass parameter 'b' the vice versa.

1 Answers   IBM, Sierra Atlantica,

---

WHAT IS THE USE OF SKIP WHERE U WILL GIVE?

3 Answers  

---

What is ERP? Architecture of apps?

3 Answers   TCS,

---

what is difference between API and Interface?

2 Answers   Infogain,

---

difference between 2 way and 4 way matching

3 Answers   Convergys, TCS,

---

What are the validations you don in .CTL file in inbound interface process?

1 Answers  

---

what is pay run id ?

0 Answers  

---

is it possible to run the interface without using oracle apps?

2 Answers   Accenture,

---

Is there any limitations on responsibility assigned to a apps user?

6 Answers   ESS,

---

Can we customize a form with out template.fmb

5 Answers   Zensar,

---