View HLPDTEST.STATEGPS.ISSUE_TESTCASE_VW 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
CASE_ID number 22  √  null
REPLAY_SEQUENCE number 22  √  null
INSTANCE_ID number 22
T_GPS_WORKFLOW_INSTANCES.INSTANCE_ID Implied Constraint R
CASE_NUMBER varchar2 1000

Analyzed at Sun Oct 18 01:05 IST 2020

View Definition:
select max(maxtc.case_id) case_id,bsm.replay_sequence,inp.instance_id,tc.case_number from t_gps_instance_properties inp ,tri2gps_dev.issues iss, tri2gps_dev.links links,tri2gps_dev.test_cases tc,tri2gps_dev.test_cases maxtc, tri2gps_dev.bsm_main bsm where inp.property_value = iss.issue_number and inp.property_name = 'tri2.SG_TRI2_ENTITY.IA_ISSUE_NUMBER' and iss.issue_id = links.entity_id and links.link_type = 'ISS' and links.reference_type='TC' and links.reference_identifier = tc.case_id and maxtc.bsm_number = tc.bsm_number and maxtc.bsm_number = bsm.bsm_number and (bsm.active_flag is null or bsm.active_flag = 'true') --and inp.instance_id=186103 group by bsm.replay_sequence,maxtc.bsm_number,inp.instance_id,tc.case_number
 
Possibly Referenced Tables/Views:


Close relationships: