Our apps version is 11.5.10. Our requirement is using web adi we need to populate the value in current field depending on Previous Field. How to specify the bind variable in VAL_ADDL_W_C clause in Update statement of bne_interface_cols_b to fetch the required results ?
For Eg. If we're having Operating Unit and Inventory field in Web-ADI ,the Values shown in Inventory field are based on Values Selected in Operating Unit .
so VAL_ADDL_W_C will be something like 'operating_unit = bind variable' . How to specify the same.
I'm not sure you can reference other fields in the VAL_ADDL_W_C, while you can include reference to profiles like $PROFILES$.PER_RI_WEBADI_BG_ID or environment variables like $env$.appid or $env$.respid.
If you want to achieve your goal modifying the VAL_ADDL_W_C field, maybe you can consider having different integrators for each Operating unit.
Using FNDLoad you can copy several times the same integrator and change only the name and the VAL_ADDL_W_C field, or maybe use the same within different responsibilities each with different profile option value.
Another option would be the group validation, which would prevent uploading rows where the inventory item is not in line with the operating unit. But the LOV would show all the values.
To have "real" dependent LOV, you need to extend a class called BneBaseSQL.
Unfortunately I'm not a Java expert, and can guide you only a little in this area.