View HLPDTEST.STATEGPS.GPS_NODE_PORPS_CONFIG_V | Generated by SchemaSpy |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Apr 12 01:05 IST 2021 |
View Definition:
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
Possibly Referenced Tables/Views:
![]() ![]() |