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 are the Major differences between appcore.pll and appcore2.pll

5 Answers   Infosys, Sierra Atlantica,

---

Difference between Bind and Lexical parameters?

3 Answers  

---

HOW CAN YOU KNOW UPDATE STMT IS WORKED OR NOT IN PL/SQL?

2 Answers   TCS,

---

what is the defference between credit memo and debit memo

2 Answers  

---

tell me the scenarios of the independent in reports

0 Answers   Accenture, IBM,

---

What is secuirity's in R12 features.

1 Answers   KPIT,

---

Do you know where we can check the status of po?

0 Answers  

---

i have 100 pages output. i want to print 10 records per page in Template?

2 Answers   Sierra Atlantica,

---

How does accounting occured in Expense Reporting?

1 Answers   Sapient,

---

There are set of records to be processed from staging table into interface table. If one record fails the entire set of data should be rejected.

3 Answers   Satyam,

---

Tell me where we find the status of order information?

0 Answers  

---

How to print multi currency,multi language in xml?

1 Answers  

---