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 data type of lexical parameter?

5 Answers   Wipro,

---

What are triggers?

3 Answers  

---

what are the error tables in OM

2 Answers   Fujitsu,

---

What is OM Cycle and What do u mean by Alternate Item

3 Answers   IBM,

---

What will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?

2 Answers   TCS,

---

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

0 Answers   Satyam,

---

Hi Experts How to Create a purchase order without a requisition ?

6 Answers   Amdocs, KPMG, Oracle,

---

How many phases of implementation and what are those.

2 Answers   Accenture,

---

I want to develop a oracle applications report using report builder 6i. I have two user parameters. How to provide list of values to parameters, which should show me at the time of submitting concurrent program.

1 Answers   Genpact, Y3K Imaginations,

---

Tell me some interface tables on ordermangement.

1 Answers   Zensar,

---

What are the Major differences between appcore.pll and appcore2.pll

5 Answers   Infosys, Sierra Atlantica,

---

mention the interface tables for item open interface and open transaction interface and also their respective production tables.

1 Answers   Scan Steel,

---