View HLPDTEST.STATEGPS.T_GPS_VIEWER_CONFIGURATION_V Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
APPLICATION_NAME varchar2 255  √  null
SET_NAME varchar2 255  √  null
FORM_NAME varchar2 255  √  null
VIEWER_INSTANCES_ID number 22
T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID Implied Constraint R
REPORT_TYPE varchar2 9  √  null
TRANSPOSE_VIEW varchar2 5  √  null
OLAP_VIEW varchar2 5  √  null
QUER_CRITERIA varchar2 5  √  null
FILTER_CONFIG varchar2 5  √  null
FORMAT varchar2 5  √  null
SORT_ORDER varchar2 5  √  null
COLUMN_WIDTH varchar2 5  √  null
EDIT varchar2 5  √  null
ENABLE_LOV_EDIT varchar2 5  √  null
MANDATORY_FOR_EDIT varchar2 5  √  null
INSERT_FLAG varchar2 5  √  null
ENABLE_LOV_INSERT varchar2 5  √  null
MANDATORY_FOR_INSERT varchar2 5  √  null
CONDITIONAL_FORMATTING varchar2 5  √  null
DOCUMENT_FIELD varchar2 5  √  null
PASSWORD_FIELD varchar2 5  √  null
MULTILINE varchar2 5  √  null
BLOB_DOWNLOAD varchar2 5  √  null
PIVOT varchar2 5  √  null
QUERY_DEFAULT_VALUE varchar2 5  √  null
LOV varchar2 5  √  null
LOV_DEPENDON varchar2 5  √  null
DRILLDOWN varchar2 5  √  null
GRAPH_CONFIG varchar2 5  √  null

Analyzed at Sat Oct 31 01:06 IST 2020

View Definition:
SELECT T_GPS_APPLICATIONS.APPLICATION_NAME, T_GPS_VIEWER_INSTANCES_SET.SET_NAME, T_GPS_VIEWER_INSTANCES.FORM_NAME, T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID, DECODE(T_GPS_VIEWER_INSTANCES.POST_INSTANCE_NAME, NULL, 'Report', 'Worksheet') REPORT_Type, DECODE(T_GPS_VIEWER_INSTANCES.FORM_VIEW, 'Transpose View', 'true', 'false') Transpose_View, DECODE(T_GPS_VIEWER_INSTANCES.FORM_VIEW_TYPE, 'OLAP View', 'true', 'false') OLAP_View, CLASS_PROPS.QUER_CRITERIA, CLASS_PROPS.FILTER_CONFIG, CLASS_PROPS.FORMAT, CLASS_PROPS.SORT_ORDER, CLASS_PROPS.COLUMN_WIDTH, CLASS_PROPS.EDIT, CLASS_PROPS.ENABLE_LOV_EDIT, CLASS_PROPS.MANDATORY_FOR_EDIT, CLASS_PROPS.INSERT_FLAG, CLASS_PROPS.ENABLE_LOV_INSERT, CLASS_PROPS.MANDATORY_FOR_INSERT, CLASS_PROPS.CONDITIONAL_FORMATTING, CLASS_PROPS.DOCUMENT_FIELD, CLASS_PROPS.PASSWORD_FIELD, CLASS_PROPS.MULTILINE, CLASS_PROPS.BLOB_DOWNLOAD, CLASS_PROPS.PIVOT, CLASS_PROPS.QUERY_DEFAULT_VALUE, CLASS_PROPS.LOV, CLASS_PROPS.LOV_DEPENDON, CLASS_PROPS.DRILLDOWN, DECODE((SELECT DISTINCT 'true' FROM T_GPS_VIEWER_GRAPH_DETAILS WHERE GRAPH_TYPE IS NOT NULL AND VIEWER_INSTANCES_ID = T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID), 'true', 'true', 'false') GRAPH_CONFIG FROM T_GPS_APPLICATIONS T_GPS_APPLICATIONS, T_GPS_VIEWER_INSTANCES_SET T_GPS_VIEWER_INSTANCES_SET, T_GPS_VIEWER_INSTANCES T_GPS_VIEWER_INSTANCES, T_GPS_VIEWER_INSTANCES_CLASSES T_GPS_VIEWER_INSTANCES_CLASSES, (select T_GPS_VIEWER_INST_CLASS_PROPS.Class_Id, MAX(DECODE(QUERY_CRITERIA, 'true', 'true', 'false')) QUER_CRITERIA, MAX(DECODE(QUERY_RESULTS, 'true', 'true', 'false')) FILTER_CONFIG, MAX(DECODE(FORMAT, null, 'false', 'true')) FORMAT, MAX(DECODE(SORT_ORDER, null, 'false', 'true')) SORT_ORDER, MAX(DECODE(COLUMN_WIDTH, null, 'false', 'true')) COLUMN_WIDTH, MAX(DECODE(EDIT, 'true', 'true', 'false')) EDIT, MAX(DECODE(ENABLE_LOV_EDIT, 'true', 'true', 'false')) ENABLE_LOV_EDIT, MAX(DECODE(MANDATORY_FOR_EDIT, 'true', 'true', 'false')) MANDATORY_FOR_EDIT, MAX(DECODE(INSERT_FLAG, 'true', 'true', 'false')) INSERT_FLAG, MAX(DECODE(ENABLE_LOV_INSERT, 'true', 'true', 'false')) ENABLE_LOV_INSERT, MAX(DECODE(MANDATORY_FOR_INSERT, 'true', 'true', 'false')) MANDATORY_FOR_INSERT, MAX(DECODE(COLOURING, 'true', 'true', 'false')) CONDITIONAL_FORMATTING, MAX(DECODE(PROPERTY_TYPE, 'Document', 'true', 'false')) Document_Field, MAX(DECODE(PROPERTY_TYPE, 'Password Field', 'true', 'false')) Password_Field, MAX(DECODE(PROPERTY_TYPE, 'MultiLine', 'true', 'false')) MultiLine, MAX(DECODE(PROPERTY_TYPE, 'File Blob', 'true', 'false')) Blob_download, /*MAX(DECODE(BUSINESS_KEY,'true','true','false')) WORKBENCH_LINK,*/ MAX(DECODE(QUERY_DEFAULT, NULL, 'false', 'true')) QUERY_DEFAULT_VALUE, MIN(DECODE(PIVOT, null, 'false', 'true')) PIVOT, MAX(DECODE((SELECT DISTINCT 'true' FROM T_GPS_VIEWER_LOV_INFO WHERE PROPERTY_ID IN (SELECT PROPERTY_ID FROM T_GPS_VIEWER_INST_CLASS_PROPS P1 WHERE P1.CLASS_ID = T_GPS_VIEWER_INST_CLASS_PROPS.CLASS_ID)), 'true', 'true', 'false')) LOV, MAX(DECODE((SELECT DISTINCT 'true' FROM T_GPS_VIEWER_LOV_INFO WHERE PROPERTY_ID = T_GPS_VIEWER_INST_CLASS_PROPS.PROPERTY_ID AND LOV_ID IN (SELECT D.LOV_ID FROM T_GPS_VIEWER_LOV_DEPENDONS D)), 'true', 'true', 'false')) LOV_DEPENDON, MAX(DECODE((SELECT DISTINCT 'true' FROM T_GPS_DRILL_DOWN_PROPERTIES WHERE PROPERTY_ID = T_GPS_VIEWER_INST_CLASS_PROPS.PROPERTY_ID), 'true', 'true', 'false')) DRILLDOWN FROM T_GPS_VIEWER_INST_CLASS_PROPS T_GPS_VIEWER_INST_CLASS_PROPS group by class_id) CLASS_PROPS where T_GPS_VIEWER_INSTANCES.VISIBLE_FLAG = 'true' and T_GPS_VIEWER_INSTANCES_SET.VISIBLE_FLAG = 'true' AND T_GPS_APPLICATIONS.VISIBLE_FLAG = 'true' AND T_GPS_APPLICATIONS.APPLICATION_ID = T_GPS_VIEWER_INSTANCES_SET.APPLICATION_ID AND T_GPS_VIEWER_INSTANCES_SET.SET_ID = T_GPS_VIEWER_INSTANCES.SET_ID AND T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID = T_GPS_VIEWER_INSTANCES_CLASSES.VIEWER_INSTANCES_ID AND CLASS_PROPS.CLASS_ID = T_GPS_VIEWER_INSTANCES_CLASSES.CLASS_ID AND T_GPS_VIEWER_INSTANCES.USER_DEFINED_NAME IS NULL ORDER BY T_GPS_APPLICATIONS.APPLICATION_NAME, T_GPS_VIEWER_INSTANCES_SET.SET_NAME, T_GPS_VIEWER_INSTANCES.FORM_NAME
 
Possibly Referenced Tables/Views:


Close relationships: