SELECT gps_node_props_vw.application_name, gps_node_props_vw.application_id, gps_node_props_vw.role_app_id, gps_node_props_vw.role_name, gps_node_props_vw.role_id, gps_node_props_vw.role_nodetype_id, gps_node_props_vw.nodetype, gps_node_props_vw.nodetype_id, gps_node_props_vw.nodetype_state_id, gps_node_props_vw.class_id, gps_node_props_vw.class_name, gps_node_props_vw.class_alias_name, gps_node_props_vw.property_id, gps_node_props_vw.property_name, gps_node_props_vw.property_alias_name, gps_node_props_vw.property_display_value, gps_node_props_vw.property_tab_name, gps_node_props_vw.mandatory, gps_node_props_vw.override, gps_node_props_vw.update_if_query, gps_node_props_vw.update_if_not_query, t_gps_role_node_prop_acl.prop_acl_id, nvl(t_gps_role_node_prop_acl.read_access, 'true') AS read_access, nvl(t_gps_role_node_prop_acl.insert_access, gps_node_props_vw.update_if_not_qry_with_overide) AS insert_access, nvl(t_gps_role_node_prop_acl.update_access, gps_node_props_vw.update_if_qry_with_override) AS update_access, gps_node_props_vw.update_if_qry_with_override, gps_node_props_vw.update_if_not_qry_with_overide FROM gps_node_props_vw gps_node_props_vw LEFT JOIN t_gps_role_node_prop_acl t_gps_role_node_prop_acl ON gps_node_props_vw.application_name = t_gps_role_node_prop_acl.application_name AND gps_node_props_vw.role_name = t_gps_role_node_prop_acl.role_name AND gps_node_props_vw.nodetype = t_gps_role_node_prop_acl.nodetype AND gps_node_props_vw.class_name = t_gps_role_node_prop_acl.class_name AND gps_node_props_vw.property_name = t_gps_role_node_prop_acl.property_name