| Steps To Reproduce | When installing module, ORA-00936: missing expression on VIEW OBARCNT_RESERVATION_V
[java] 386606 WARN - SQL Command failed with: ORA-00936: missing expression
[java]
[java] 386639 WARN - -- END
[java] -- -----------------------------------------------------------------------
[java] -- VIEW OBARCNT_RESERVATION_V
[java] -- -----------------------------------------------------------------------
[java] CREATE OR REPLACE FORCE VIEW OBARCNT_RESERVATION_V AS SELECT get_uuid() AS obarcnt_reservation_v_id, resource.ad_client_id, resource.ad_org_id, resource.created, resource.createdby, resource.updated, resource.updatedby, resource.isactive, enquiry.obarcnt_enquiry_id, enquiry.startdate, enquiry.enddate, resource.obre_resource_id, resource.value, resource.name, resource.resource_type, resource.obre_resource_category_id, resource.obre_resource_group_id, resource.c_location_id, resource.m_product_category_id, resource.hascapacity, resource.capacity_default, resource.capacity_max, resource.m_product_id, obarcnt_isreserved(resource.obre_resource_id, enquiry.startdate, enquiry.enddate) AS isbooked, obarcnt_isenquiry(resource.obre_resource_id, enquiry.startdate, enquiry.enddate) AS isenquiry, resource.em_obarcnt_owner_id, resource.em_obarcnt_subway, resource.em_obarcnt_bedroom, resource.em_obarcnt_livingroom, resource.em_obarcnt_wc, resource.em_obarcnt_bathroom, resource.em_obarcnt_garbage_location, resource.em_obarcnt_area FROM obre_resource resource CROSS JOIN obarcnt_enquiry enquiry WHERE resource.ad_client_id = enquiry.ad_client_id AND NOT (EXISTS (SELECT 1 FROM obarcnt_enquiryline eline WHERE eline.obarcnt_enquiry_id = enquiry.obarcnt_enquiry_id AND eline.obre_resource_id = resource.obre_resource_id)) AND resource.isactive = 'Y' AND (enquiry.docstatus NOT IN ('BOOKED', 'REFUSED')) |
Relationships [ Relation Graph ]
[ Dependency Graph ]
Relationships 