Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Bind Parameter to Custom IN Operator in Jdev 12.2.1.4

848013Feb 11 2022

Hi
On my ADF Page, i have Master Form, Detail Table. In My detail form, i have an LOV. In this LOV, I a custom IN Operator based on a view object . Question is How can i pass the value from MASTER form attribute (VendorSiteId) to the bind variable in this subquery?
My Master VO based on EO:
image.pngMy Detail VO based on EO:
image.pngThis is my LOV VO Criteria with IN operator. enabled for ChargeAccount attribute in my Detail VO
image.pngI replaced bind variable with a constant value. eg: 108708. All Works as expected
Based on some blogs, i used a Transient attribute (SiteId) to make the bind variable recognized as below and passed constant value 108708 to the bind variable. All Works as
image.pngPlease suggest how i can pass the value from MASTER form attribute (VendorSiteId) to the bind variable in this subquery?
Thanks
Lakshmi

Comments
Post Details
Added on Feb 11 2022
11 comments
752 views