Business Case:
It is tedious to check values of a lookup from the application.
Use this query to find the values to find out from database.
Queries:
Lookup Information:
select *
from fnd_lookup_types_VL
Where lookup_type = '&Enter_lookup_type';
=> Tip:You can use the above table to find lookups available in the system
Values of a lookup:
select *
from fnd_lookup_values
Where lookup_type = '&Enter_lookup_type';
If you need any other information. Comment on this post. I will answer you.
It is tedious to check values of a lookup from the application.
Use this query to find the values to find out from database.
Queries:
Lookup Information:
select *
from fnd_lookup_types_VL
Where lookup_type = '&Enter_lookup_type';
=> Tip:You can use the above table to find lookups available in the system
Values of a lookup:
select *
from fnd_lookup_values
Where lookup_type = '&Enter_lookup_type';
If you need any other information. Comment on this post. I will answer you.
PLEASE UPDATE EXAMPLE WITH SCREEN SHOTS..........
ReplyDeleteI simply recognized your site the previous week and that i continues to be learning which it normally. You’ll be able to loads of tips there and i also relish your look around the rrnternet site to boot. Stick to the excellent show results! great post to read
ReplyDelete