Attaching an LOV to a column in a custom WebADI integrator

Inorder to provide a list of values when one is connected with Oracle Apps,i followed these steps to get it done :-

1. Created a lookup/flex field where the values will be stored or which will act as a source for the values when you double click the column.

2. I used the api bne_integrator_utils.create_table_lov. You can get the parameters for this api using the all_sources table. I am highlighting some specific parameter which needs to be considered carefully. For example p_interface_code should have your intergrator interface code,p_interface_col_name should be the field name with which you want to associate the LOV,p_id_col and p_mean_col will be 'LOOKUP_CODE'  or 'FLEX_VALUE' depending on whether you are using fnd_lookups or fnd_flex_values,p_desc_col can be null,p_table should be the table FND_LOOKUP_VALUES or FND_FLEX_VALUES and p_addl_w_c will be the "where clause" which you will apply on FND_LOOKUP_VALUES  or FND_FLEX_VALUES to filter your values,p_windows_width and p_windows height can be chosen as 400 and 300 respectively.