Record Group Query statement not customizable on R12.
I am doing a forms customization for Apps R12. I am using Forms Builder version 10.1.2.0.2.
What I need is to customize is the LOV ITEMS on the form OEXOEORD.frm for Oder Management Module. Based on the client requirement I need to modify the Record Group Query statement so that the LOV ITEMS returns only certain items. I have successfully modified the sql statement and tested it using SQL developer and it does what is expected.
I have successfuly compiled the new form(XXOEXOEORD), registered it on the apps, created a function to run the form and created a Menu to run the new form. Problem is, when I run my new form(on apps front end), the results that comes from the LOV ITEMS are not what I expected. It is as if the Record Group query statement is still firing the old one. Just to make sure I was in the correct place, I swaped around the field items and that customization happens as expected. It is only the SQL statement that seems to be firing the old