The ticket has been resolved, and a batch will be released for it.
Please find the script below to apply.

Best regards,
Nouha
INSERT INTO DB_VIEW_CONF (VIEW_NAME, ATTRIBUTE_NAME, VALUE) VALUES ('REDLINE_VIEW','VERSION_NAME','put your version');

--------------------------------------------------------------------------------------------------------------------------
CREATE OR REPLACE FORCE EDITIONABLE VIEW REDLINE_VIEW ( "VENDOR", "IDU_NAME", "LABEL", "IDU_ID", "LOCATION", "IDU_TYPE", "NE_ID", "SITE_ID", "SITE_NAME", "LOCATION_REGION","LOCATION_CITY")
AS WITH SELECTED_VERSION
AS (SELECT VERSIONID VERSION_ID FROM VERSION
WHERE NAME = (SELECT VALUE FROM DB_VIEW_CONF WHERE VIEW_NAME = 'REDLINE_VIEW' AND ATTRIBUTE_NAME = 'VERSION_NAME'))
select m.name vendor,
i.name IDU_NAME,
i.name || ' '||i.objectid LABEL,
i.objectid IDU_ID,
c.wilayah_name LOCATION,
type.name IDU_TYPE,
i.neid NE_ID,
s.objectid SITE_ID,
s.name SITE_NAME,

c.governate_name LOCATION_REGION,
c.city_name LOCATION_CITY

FROM IDU i
left join SELECTED_VERSION v on v.VERSION_ID=i.versionid
left join site s on s.siteid=i.siteid
left join FN_CITY_VIEW c on c.city_id=s.zone_id
left join IduType type on i.IduTypeID=type.IduTypeID
left join Manufacturer m on m.ManufacturerID=type.ManufacturerID
where m.name='REDLINE';

DB view delivered