Update Column value in View object (OAF)

Dears,

Good day.

Kindly be informed that we need to make a small update in view object for a page.

For example the old SQL query is:

SELECT MIL.SEGMENT1 || '.' || MIL.segment2 FROM Mtl_Item_Locations_KFV Mil

 WHERE Mil.Disable_Date IS NULL;

The new desired SQL to be reflected on the web page is as following:

SELECT MIL.concatenated_segments FROM Mtl_Item_Locations_KFV Mil

 WHERE Mil.Disable_Date IS NULL;

We changed this in the XML file and upload it to the server but nothing still the old query fetched.

Can you please helps with the actual steps and if we are missing something? knowing that this is the first time we deal with OAF.