View slot9.WORLD.TSTA.PROPERTY_INV_ROLE_CNT_VW
Legend:
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
MODULE varchar2 8  √  null
PROPERTY_ID number 38  √  null
COUNT number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT DISTINCT 'Business', bp.pro_property_id, COUNT (bp.pprc_role_code) FROM business_properties bp GROUP BY 1, bp.pro_property_id UNION SELECT DISTINCT 'People', pp.property_id, COUNT (pp.role_code) FROM people_properties pp GROUP BY 1, pp.property_id
 
Possibly Referenced Tables/Views:
BUSINESS_PROPERTIES PEOPLE PEOPLE_PROPERTIES