SELECT NSCP.FDT_FILE FDT_FILE, NSCP.FDT_PARAMETER FDT_PARAMETER, A.APPLICATION_NAME APPLICATION, WT.WORKFLOW_TYPE_NAME WORKFLOW, WS.STATE_NAME STATE, N.NODETYPE NODETYPE, NSC.CLASS_NAME CLASS_NAME, NSC.ALIAS_NAME CLASS_ALIAS, NSCP.PROPERTY_NAME PROPERTY_NAME, NSCP.ALIAS_NAME PROPERTY_ALIAS, NULL VIEWER_SET, NULL VIEWER, NULL VIEWER_PROPERTY, NULL VIEWER_PROPERTY_ALIAS, A.LAST_UPDATED_BY UPDATED_BY, NS.UPDATED_AT UPDATED_DATE, NULL QUERYTEMPLATE, NULL QUERY_PROPERTY_NAME, NULL QUERY_PROPERTY_ALIAS FROM T_GPS_NT_ST_CLASS_PROPS NSCP, T_GPS_NT_STATE_CLASSES NSC, T_GPS_NODETYPE_STATES NS, T_GPS_NODETYPES N, T_GPS_WORKFLOW_STATES WS, T_GPS_WORKFLOW_TYPES WT, T_GPS_APPLICATIONS A WHERE NSCP.CLASS_ID = NSC.CLASS_ID AND NSC.NODETYPE_STATE_ID = NS.NODETYPE_STATE_ID AND NS.NODETYPE_ID = N.NODETYPE_ID AND NS.STATE_ID = WS.STATE_ID AND WS.WORKFLOW_TYPE_ID = WT.WORKFLOW_TYPE_ID AND WT.APPLICATION_ID = A.APPLICATION_ID AND NS.STATE_ID IS NOT NULL AND UPPER(A.VISIBLE_FLAG) = 'TRUE' AND UPPER(WT.VISIBLE_FLAG) = 'TRUE' AND UPPER(NS.VISIBLE_FLAG) = 'TRUE' UNION SELECT NSCP.FDT_FILE FDT_FILE, NSCP.FDT_PARAMETER FDT_PARAMETER, A.APPLICATION_NAME APPLICATION, NULL WORKFLOW, NULL STATE, N.NODETYPE NODETYPE, NSC.CLASS_NAME CLASS_NAME, NSC.ALIAS_NAME CLASS_ALIAS, NSCP.PROPERTY_NAME PROPERTY_NAME, NSCP.ALIAS_NAME PROPERTY_ALIAS, NULL VIEWER_SET, NULL VIEWER, NULL VIEWER_PROPERTY, NULL VIEWER_PROPERTY_ALIAS, A.LAST_UPDATED_BY UPDATED_BY, NS.UPDATED_AT UPDATED_DATE, NULL QUERYTEMPLATE, NULL QUERY_PROPERTY_NAME, NULL QUERY_PROPERTY_ALIAS FROM T_GPS_NT_ST_CLASS_PROPS NSCP, T_GPS_NT_STATE_CLASSES NSC, T_GPS_NODETYPE_STATES NS, T_GPS_NODETYPES N, T_GPS_APPLICATIONS A WHERE NSCP.CLASS_ID = NSC.CLASS_ID AND NSC.NODETYPE_STATE_ID = NS.NODETYPE_STATE_ID AND NS.NODETYPE_ID = N.NODETYPE_ID AND NS.APPLICATION_ID = A.APPLICATION_ID AND NS.STATE_ID IS NULL AND UPPER(A.VISIBLE_FLAG) = 'TRUE' AND UPPER(NS.VISIBLE_FLAG) = 'TRUE' UNION SELECT VLI.FDT_FILE FDT_FILE, VLI.FDT_PARAMETER, A.APPLICATION_NAME APPLICATION, NULL WORKFLOW, NULL STATE, NULL NODETYPE, NULL CLASS_NAME, NULL CLASS_ALIAS, NULL PROPERTY_NAME, NULL PROPERTY_ALIAS, VIS.SET_NAME VIEWER_SET, VI.FORM_NAME VIEWER, VICP.PROPERTY_NAME VIEWER_PROPERTY, VICP.ALIAS_NAME VIEWER_PROPERTY_ALIAS, VI.FORM_CREATED_BY UPDATE_BY, VI.UPDATED_AT OBJECT_UPDATED_DATE, NULL QUERYTEMPLATE, NULL QUERY_PROPERTY_NAME, NULL QUERY_PROPERTY_ALIAS FROM T_GPS_VIEWER_LOV_INFO VLI, T_GPS_VIEWER_INST_CLASS_PROPS VICP, T_GPS_VIEWER_INSTANCES_CLASSES VIC, T_GPS_VIEWER_INSTANCES VI, T_GPS_VIEWER_INSTANCES_SET VIS, T_GPS_APPLICATIONS A WHERE VLI.PROPERTY_ID = VICP.PROPERTY_ID AND VICP.CLASS_ID = VIC.CLASS_ID AND VIC.VIEWER_INSTANCES_ID = VI.VIEWER_INSTANCES_ID AND VI.SET_ID = VIS.SET_ID AND VIS.APPLICATION_ID = A.APPLICATION_ID AND UPPER(A.VISIBLE_FLAG) = 'TRUE' AND UPPER(VIS.VISIBLE_FLAG) = 'TRUE' AND UPPER(VI.VISIBLE_FLAG) = 'TRUE' UNION SELECT SUBSTR(WICP.EXTRA_INFO, 1, INSTR(WICP.EXTRA_INFO, '@') - 1) FDT_FILE, SUBSTR(WICP.EXTRA_INFO, INSTR(WICP.EXTRA_INFO, '@') + 1) FDT_PARAMETER, A.APPLICATION_NAME APPLICATION, WT. WORKFLOW_TYPE_NAME WORKFLOW, NULL STATE, NULL NODETYPE, NULL CLASS_NAME, NULL CLASS_ALIAS, NULL PROPERTY_NAME, NULL PROPERTY_ALIAS, NULL VIEWER_SET, NULL VIEWER, NULL VIEWER_PROPERTY, NULL VIEWER_PROPERTY_ALIAS, A.LAST_UPDATED_BY UPDATE_BY, A.LAST_UPDATED_DATE UPDATED_DATE, WI.INSTANCE_NAME QUERYTEMPLATE, WICP.PROPERTY_NAME QUERY_PROPERTY_NAME, WICP.ALIAS_NAME QUERY_PROPERTY_ALIAS FROM T_GPS_WORKFLOW_INSTANCES WI, T_GPS_WF_INSTANCE_CLASSES WIC, T_GPS_WF_INST_CLASS_PROPS WICP, T_GPS_WORKFLOW_TYPES WT, T_GPS_APPLICATIONS A WHERE WT.WORKFLOW_TYPE_ID = WI.WORKFLOW_TYPE_ID AND WI.INSTANCE_ID = WIC.INSTANCE_ID AND WIC.CLASS_ID = WICP.CLASS_ID AND WT.APPLICATION_ID = A.APPLICATION_ID AND UPPER(A.VISIBLE_FLAG) = 'TRUE' AND UPPER(WT.VISIBLE_FLAG) = 'TRUE' AND WICP.EXTRA_INFO IS NOT NULL UNION SELECT SUBSTR(WICP.EXTRA_INFO, 1, INSTR(WICP.EXTRA_INFO, '@') - 1) FDT_FILE, SUBSTR(WICP.EXTRA_INFO, INSTR(WICP.EXTRA_INFO, '@') + 1) FDT_PARAMETER, A.APPLICATION_NAME APPLICATION, NULL WORKFLOW, NULL STATE, NULL NODETYPE, NULL CLASS_NAME, NULL CLASS_ALIAS, NULL PROPERTY_NAME, NULL PROPERTY_ALIAS, NULL VIEWER_SET, NULL VIEWER, NULL VIEWER_PROPERTY, NULL VIEWER_PROPERTY_ALIAS, A.LAST_UPDATED_BY UPDATE_BY, A.LAST_UPDATED_DATE UPDATED_DATE, WI.INSTANCE_NAME QUERYTEMPLATE, WICP.PROPERTY_NAME QUERY_PROPERTY_NAME, WICP.ALIAS_NAME QUERY_PROPERTY_ALIAS FROM T_GPS_WORKFLOW_INSTANCES WI, T_GPS_WF_INSTANCE_CLASSES WIC, T_GPS_WF_INST_CLASS_PROPS WICP, T_GPS_APPLICATIONS A WHERE A.APPLICATION_ID = WI.APPLICATION_ID AND WI.INSTANCE_ID = WIC.INSTANCE_ID AND WIC.CLASS_ID = WICP.CLASS_ID AND UPPER(A.VISIBLE_FLAG) = 'TRUE' AND WICP.EXTRA_INFO IS NOT NULL AND INSTR(WICP.EXTRA_INFO, '@') > 1