View HLPDTEST.STATEGPS.GPS_EWKS_NODE_PROPS_CONFIG_V | Generated by SchemaSpy |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Wed May 25 01:05 IST 2022 |
View Definition:
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
Possibly Referenced Tables/Views:
![]() ![]() |