Creating an LOV against any column - Web ADI

Related Posts:

Custom Web ADI (Upload)

Custom Web ADI (Download)

We have created an upload ADI in our last post and now we will try to attach an LOV to one column (Status)

Responsibility: Desktop Integration Manager

> Manage Integrators

Search and update the Integrator

Click on Update symbol against the field you want to create an LOV

Val Type : Table
Id : LOOKUP_CODE – (This will be passed to the program)
Meaning : MEANING
Desc : DESCRIPTION
Val. Entity : FND_LOOKUP_VALUES
Where clause : lookup_type = 'ASO_ORDER_STATUSES' and enabled_flag = 'Y' and language = USERENV('LANG')

Lov Type : Pop List

Save and Submit

Run the ADI again