Lookups

[vamsioracle]

Hi

I have created a lookup in apps with two values. now can i use this directly to a parmeter for report or do i need to create a value set and attach to report parameter.

what are the steps to do

please help me out

vamsi

[amitpatel66]

Hi

I have created a lookup in apps with two values. now can i use this directly to a parmeter for report or do i need to create a value set and attach to report parameter.

what are the steps to do

please help me out

vamsi

You need to go for second option.

Create a value set of the validation type as required.
Attach this valueset to your report parameter.

[vamsioracle]

hi

please tell me the steps in apps to create a valueset for this lookup. i want to attach thsi lookup to a valueset.

thank u

[amitpatel66]

hi

please tell me the steps in apps to create a valueset for this lookup. i want to attach thsi lookup to a valueset.

thank u

You can do that by creating a value set of validation type as table, and then in the LOV query, write a query to select the list from the fnd_lookup_valu es table.

Use Application Developer ersponsibility for achiveing this task.