View HLPDTEST.STATEGPS.BP_BUSINESS_WORKFLOW_NON_JDDT 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
REQUIREMENT_ID number 22  √  null
REQUIREMENT_NUMBER varchar2 20  √  null
REQUIREMENT_TITLE varchar2 200  √  null

Analyzed at Thu Aug 13 01:05 IST 2020

View Definition:
Select Distinct REQ.REQUIREMENT_ID, REQ.REQUIREMENT_NUMBER, REQ.REQUIREMENT_TITLE from OBJECT_VIEWER_V OV, TRI2GPS_DEV.REQUIREMENTS REQ Where OV.property_value = REQ.REQUIREMENT_NUMBER(+) And APPLICATION_NAME = 'Business Processes' And WORKFLOW_TYPE_NAME = 'Business Workflow'
 
Possibly Referenced Tables/Views:
OBJECT_VIEWER_V