I have a form that uses Cascading LOV's which are based on the Web Source Module (REST calls).
The first item selects the Department and the second one needs to bring "Aliases" based on the department selected. I tried many variations and cannot get it to work properly. It seems like I cannot reference an item (in this case P11_ORG_NUMBER) within the "Post Processing SQL Query". If I hard code the "org number" to specific value it works fine but adding "org = :P11_ORG_NUMBER" results in no data at all. I tried various options to reference an item "&P11_ORG_NUMBER." or V('P11_ORG_NUMBER') and nothing seems to be working.
Am I doing something wrong or is it a bug in 19.2.
Here is my setup:
LOV setup based on Web Source:
An page item setting to use the LOV
