Answer Posted / 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..........

How to create a purchase order without a requisition?

1203

---

how to print multi lay outs,muti currency,muti language in xml publisher

12301

---

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2618

---

List the various types of value set.

1085

---

How many schemas we have? how many you have used?

2069

---

What are the Standard Reports and Forms in HRMS?

2320

---

What is count(*) from po_vendors(any table)?

1089

---

What do you understand by soa and what are the benefits of using this architecture?

1095

---

What is a value set? List its various types.

1102

---

What are the different components you should consider while defining a responsibility in oracle apps?

1087

---

What is instead of trigger in where we will use?

1179

---

What are file in oracle.

2241

---

What are the different components of soa suite?

1211

---

In oracle application how do you debug or trace errors?

1125

---

List the types of flexfield?

1045

---