SELECT GPS_EWKS_NODE_PROPS_VW.application_name, GPS_EWKS_NODE_PROPS_VW.application_id, GPS_EWKS_NODE_PROPS_VW.set_name, GPS_EWKS_NODE_PROPS_VW.set_id, GPS_EWKS_NODE_PROPS_VW.form_name, GPS_EWKS_NODE_PROPS_VW.role_app_id, GPS_EWKS_NODE_PROPS_VW.role_name, GPS_EWKS_NODE_PROPS_VW.role_id, GPS_EWKS_NODE_PROPS_VW.class_id, GPS_EWKS_NODE_PROPS_VW.class_name, GPS_EWKS_NODE_PROPS_VW.property_id, GPS_EWKS_NODE_PROPS_VW.property_name, GPS_EWKS_NODE_PROPS_VW.alias_name, GPS_EWKS_NODE_PROPS_VW.display, t_gps_role_node_prop_acl.prop_acl_id, nvl(t_gps_role_node_prop_acl.read_access, 'true') AS visiblity, nvl(t_gps_role_node_prop_acl.read_access, GPS_EWKS_NODE_PROPS_VW.display) AS read_access, nvl(t_gps_role_node_prop_acl.insert_access, GPS_EWKS_NODE_PROPS_VW.insert_flag) AS insert_access, nvl(t_gps_role_node_prop_acl.update_access, GPS_EWKS_NODE_PROPS_VW.edit) AS update_access FROM GPS_EWKS_NODE_PROPS_VW GPS_EWKS_NODE_PROPS_VW LEFT JOIN t_gps_role_node_prop_acl t_gps_role_node_prop_acl ON GPS_EWKS_NODE_PROPS_VW.application_name = t_gps_role_node_prop_acl.application_name AND GPS_EWKS_NODE_PROPS_VW.role_name = t_gps_role_node_prop_acl.role_name AND GPS_EWKS_NODE_PROPS_VW.class_name = t_gps_role_node_prop_acl.class_name AND GPS_EWKS_NODE_PROPS_VW.property_name = t_gps_role_node_prop_acl.property_name