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.

How to compile the Forms & Reports in Linux Apps Server which are created in WindowsXP client?

1 Answers  

---

what is the defference between credit memo and debit memo

3 Answers   Wipro,

---

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,

---

suppose you want to use a trigger in existing standard apps form and its not available in personalization neither in custom.pll. How you will address the issue ?

3 Answers   Oracle,

---

What is ment by Global Templates in Oracle.

1 Answers   IBM,

---

what are the difference between 11.5.7 and 11.5.9 in oracle apps

4 Answers  

---

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

0 Answers  

---

what are the different transaction clauses in AR?

0 Answers   BirlaSoft,

---

How do you register report in oracle apps?

0 Answers  

---

How to pass data into EXECUTE_IMMEDIATE statement in plsql body ?

2 Answers   Oracle,

---

differentiate between intra & inter UOM class conversion with examples.

1 Answers   Scan Steel,

---

What should be the batch size (number of customer records) general guidelines for optimal performance?

1 Answers  

---