View HLPDTEST.STATEGPS.T_FDT_PARAMETER_WHERE_USED_V | Generated by SchemaSpy |
View Definition:
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
Possibly Referenced Tables/Views:
T_GPS_APPLICATIONS T_GPS_NODETYPE_STATES T_GPS_NODETYPES T_GPS_NT_ST_CLASS_PROPS T_GPS_NT_STATE_CLASSES T_GPS_VIEWER_INST_CLASS_PROPS T_GPS_VIEWER_INSTANCES T_GPS_VIEWER_INSTANCES_CLASSES T_GPS_VIEWER_INSTANCES_SET T_GPS_VIEWER_LOV_INFO T_GPS_WF_INST_CLASS_PROPS T_GPS_WF_INSTANCE_CLASSES T_GPS_WORKFLOW_INSTANCES T_GPS_WORKFLOW_STATES T_GPS_WORKFLOW_TYPES