View HLPDTEST.STATEGPS.T_INSTANCE_DOCUMENTS_V | Generated by SchemaSpy |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Tue Jan 26 01:06 IST 2021 |
View Definition:
SELECT ISSUES.ISSUE_NUMBER,
ISSUES.PARENT_ISSUE_NUMBER,
STATE_TYPE,
STATE_NAME,
T_INSTANCE_DOCUMENTS.DOCUMENT || '/' || T_INSTANCE_CHILD_DOCS.DOCUMENT_NAME AS DOCUMENT,
T_INSTANCE_CHILD_DOCS.STATE_ID
FROM TRI2GPS_DEV.ISSUES ISSUES,
STATEGPS.T_INSTANCE_DOCUMENTS T_INSTANCE_DOCUMENTS,
TRI2GPS_DEV.ISSUES ISSUES1,
STATEGPS.T_GPS_WORKFLOW_STATES T_GPS_WORKFLOW_STATES RIGHT OUTER JOIN
STATEGPS.T_INSTANCE_CHILD_DOCS T_INSTANCE_CHILD_DOCS ON
T_INSTANCE_CHILD_DOCS.STATE_ID = T_GPS_WORKFLOW_STATES.STATE_ID
WHERE T_INSTANCE_DOCUMENTS.DOCUMENT_ID = T_INSTANCE_CHILD_DOCS.DOCUMENT_ID
AND ((ISSUES.INSTANCE_ID = T_INSTANCE_DOCUMENTS.INSTANCE_ID) OR
(ISSUES1.INSTANCE_ID = T_INSTANCE_DOCUMENTS.INSTANCE_ID))
AND ISSUES.PARENT_ISSUE_NUMBER = ISSUES1.ISSUE_NUMBER
AND ISSUES.ISSUE_NUMBER IS NOT NULL
Possibly Referenced Tables/Views:
![]() ![]() |