What is the Lookup's and what is the use of lookup's?
Answers were Sorted based on User's Feedback
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..........
Is This Answer Correct ? | 42 Yes | 1 No |
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
Is This Answer Correct ? | 8 Yes | 5 No |
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.
Is This Answer Correct ? | 8 Yes | 20 No |
what are the different types of triggers in reports
in sql loader,i have 100 records in my flatefile, i want to skip the 80 to 90 records .please help me
what are stock locators and how to define them? name the tables where the stock locator information is stored. at least two.
where the accounting related data is stored ? all type of accounting related data costing etc...
What are the requests groups?
Is it is necessary to create P_CONC_REQUEST_ID parameter in the development of oracle apps reports
How do u customize the Reports?
What is secuirity's in R12 features.
How to report output like below supplier name date amount abc software jan/11 10000 /* jan month total transactions*/ abc software feb/12 30000 /* feb month total transactions*/ dell computers jan/13 45000 /* jan month total transactions*/
what are the difference between 11.5.7 and 11.5.9 in oracle apps
what are centralized and decentralized level of control of item attributes?
Can u give the Documentation of Custom.pll in oracle apps