Form Personalisation; Using fnd_lookup in CONDITION
Is it possible when creating a forms personalisation to use a select query in the CONDITION section of the form.
For instance, this is what i am wanting to do:
${item.inv_sum_folder.vendor_name.value} not in (select lookup_code from fnd_lookup_values where lookup_type = 'INV_EVAL_NOT_REQUIRED')
and ${item.inv_sum_folder.vendor_id.value} is not null
and ${item.inv_sum_folder.attribute12.value} is null
and ${item.inv_sum_folder.attribute13.value} is null
and ${item.inv_sum_folder.approval_status_display.value} != 'Cancelled'
I've validated the code within the form, and it validates, but it isn't working.