View slot9.WORLD.TSTA.BI_RECORD_COUNTS_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
TABLE_NAME varchar2 20  √  null
RECORD_COUNT number 0  √  null
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE Implied Constraint R
AGENCY_DESC varchar2 40  √  null
ORG_AGENCY_CODE varchar2 30  √  null
ORG_AGENCY_DESC varchar2 40  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT 'PEOPLE', COUNT(*), AC.AGENCY_CODE, AC.AGENCY_DESC, NVL(ROOT.AGENCY_CODE, AC.AGENCY_CODE), NVL(ROOT.AGENCY_DESC, AC.AGENCY_DESC) FROM PEOPLE TAB LEFT OUTER JOIN IJIS_USER_PROFILES IUP ON IUP.LOGIN_ID = TAB.CREATOR_ID LEFT OUTER JOIN AGENCY_CODES AC ON AC.AGENCY_CODE = IUP.AGNCY_CD_AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD ON POD.AGENCY_CODE = AC.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD2 ON POD2.STRUCTURE_ID = POD.STRUCTURE_ID AND POD2.IS_ROOT='Y' LEFT OUTER JOIN AGENCY_CODES ROOT ON ROOT.AGENCY_CODE = POD2.AGENCY_CODE WHERE TAB.CREATOR_DATE >= SYSDATE-30 GROUP BY AC.AGENCY_CODE, AC.AGENCY_DESC, ROOT.AGENCY_CODE, ROOT.AGENCY_DESC UNION SELECT 'ADDRESSES', COUNT(*), AC.AGENCY_CODE, AC.AGENCY_DESC, NVL(ROOT.AGENCY_CODE, AC.AGENCY_CODE), NVL(ROOT.AGENCY_DESC, AC.AGENCY_DESC) FROM ADDRESSES TAB LEFT OUTER JOIN IJIS_USER_PROFILES IUP ON IUP.LOGIN_ID = TAB.CREATOR_ID LEFT OUTER JOIN AGENCY_CODES AC ON AC.AGENCY_CODE = IUP.AGNCY_CD_AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD ON POD.AGENCY_CODE = AC.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD2 ON POD2.STRUCTURE_ID = POD.STRUCTURE_ID AND POD2.IS_ROOT='Y' LEFT OUTER JOIN AGENCY_CODES ROOT ON ROOT.AGENCY_CODE = POD2.AGENCY_CODE WHERE TAB.CREATOR_DATE >= SYSDATE-30 GROUP BY AC.AGENCY_CODE, AC.AGENCY_DESC, ROOT.AGENCY_CODE, ROOT.AGENCY_DESC UNION SELECT 'BUSINESSES', COUNT(*), AC.AGENCY_CODE, AC.AGENCY_DESC, NVL(ROOT.AGENCY_CODE, AC.AGENCY_CODE), NVL(ROOT.AGENCY_DESC, AC.AGENCY_DESC) FROM BUSINESSES TAB LEFT OUTER JOIN IJIS_USER_PROFILES IUP ON IUP.LOGIN_ID = TAB.CREATOR_ID LEFT OUTER JOIN AGENCY_CODES AC ON AC.AGENCY_CODE = IUP.AGNCY_CD_AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD ON POD.AGENCY_CODE = AC.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD2 ON POD2.STRUCTURE_ID = POD.STRUCTURE_ID AND POD2.IS_ROOT='Y' LEFT OUTER JOIN AGENCY_CODES ROOT ON ROOT.AGENCY_CODE = POD2.AGENCY_CODE WHERE TAB.CREATOR_DATE >= SYSDATE-30 GROUP BY AC.AGENCY_CODE, AC.AGENCY_DESC, ROOT.AGENCY_CODE, ROOT.AGENCY_DESC UNION SELECT 'VEHICLES', COUNT(*), AC.AGENCY_CODE, AC.AGENCY_DESC, NVL(ROOT.AGENCY_CODE, AC.AGENCY_CODE), NVL(ROOT.AGENCY_DESC, AC.AGENCY_DESC) FROM VEHICLES TAB LEFT OUTER JOIN IJIS_USER_PROFILES IUP ON IUP.LOGIN_ID = TAB.CREATOR_ID LEFT OUTER JOIN AGENCY_CODES AC ON AC.AGENCY_CODE = IUP.AGNCY_CD_AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD ON POD.AGENCY_CODE = AC.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD2 ON POD2.STRUCTURE_ID = POD.STRUCTURE_ID AND POD2.IS_ROOT='Y' LEFT OUTER JOIN AGENCY_CODES ROOT ON ROOT.AGENCY_CODE = POD2.AGENCY_CODE WHERE TAB.CREATOR_DATE >= SYSDATE-30 GROUP BY AC.AGENCY_CODE, AC.AGENCY_DESC, ROOT.AGENCY_CODE, ROOT.AGENCY_DESC UNION SELECT 'PROPERTIES', COUNT(*), AC.AGENCY_CODE, AC.AGENCY_DESC, NVL(ROOT.AGENCY_CODE, AC.AGENCY_CODE), NVL(ROOT.AGENCY_DESC, AC.AGENCY_DESC) FROM PROPERTIES TAB LEFT OUTER JOIN IJIS_USER_PROFILES IUP ON IUP.LOGIN_ID = TAB.CREATOR_ID LEFT OUTER JOIN AGENCY_CODES AC ON AC.AGENCY_CODE = IUP.AGNCY_CD_AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD ON POD.AGENCY_CODE = AC.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD2 ON POD2.STRUCTURE_ID = POD.STRUCTURE_ID AND POD2.IS_ROOT='Y' LEFT OUTER JOIN AGENCY_CODES ROOT ON ROOT.AGENCY_CODE = POD2.AGENCY_CODE WHERE TAB.CREATOR_DATE >= SYSDATE-30 GROUP BY AC.AGENCY_CODE, AC.AGENCY_DESC, ROOT.AGENCY_CODE, ROOT.AGENCY_DESC UNION SELECT 'GANGS', COUNT(*), AC.AGENCY_CODE, AC.AGENCY_DESC, NVL(ROOT.AGENCY_CODE, AC.AGENCY_CODE), NVL(ROOT.AGENCY_DESC, AC.AGENCY_DESC) FROM GANGS TAB LEFT OUTER JOIN IJIS_USER_PROFILES IUP ON IUP.LOGIN_ID = TAB.CREATOR_ID LEFT OUTER JOIN AGENCY_CODES AC ON AC.AGENCY_CODE = IUP.AGNCY_CD_AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD ON POD.AGENCY_CODE = AC.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD2 ON POD2.STRUCTURE_ID = POD.STRUCTURE_ID AND POD2.IS_ROOT='Y' LEFT OUTER JOIN AGENCY_CODES ROOT ON ROOT.AGENCY_CODE = POD2.AGENCY_CODE WHERE TAB.CREATOR_DATE >= SYSDATE-30 GROUP BY AC.AGENCY_CODE, AC.AGENCY_DESC, ROOT.AGENCY_CODE, ROOT.AGENCY_DESC UNION SELECT 'INCIDENTS', COUNT(*), AC.AGENCY_CODE, AC.AGENCY_DESC, NVL(ROOT.AGENCY_CODE, AC.AGENCY_CODE), NVL(ROOT.AGENCY_DESC, AC.AGENCY_DESC) FROM INCIDENTS TAB LEFT OUTER JOIN AGENCY_CODES AC ON AC.AGENCY_CODE = TAB.AGNCY_CD_AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD ON POD.AGENCY_CODE = AC.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD2 ON POD2.STRUCTURE_ID = POD.STRUCTURE_ID AND POD2.IS_ROOT='Y' LEFT OUTER JOIN AGENCY_CODES ROOT ON ROOT.AGENCY_CODE = POD2.AGENCY_CODE WHERE TAB.CREATOR_DATE >= SYSDATE-30 GROUP BY AC.AGENCY_CODE, AC.AGENCY_DESC, ROOT.AGENCY_CODE, ROOT.AGENCY_DESC UNION SELECT 'INCIDENT_SUPPLEMENTS', COUNT(*), AC.AGENCY_CODE, AC.AGENCY_DESC, NVL(ROOT.AGENCY_CODE, AC.AGENCY_CODE), NVL(ROOT.AGENCY_DESC, AC.AGENCY_DESC) FROM INCIDENT_SUPPLEMENTS TAB INNER JOIN INCIDENTS INCS ON INCS.INCIDENT_ID = TAB.INC_INCIDENT_ID LEFT OUTER JOIN AGENCY_CODES AC ON AC.AGENCY_CODE = INCS.AGNCY_CD_AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD ON POD.AGENCY_CODE = AC.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD2 ON POD2.STRUCTURE_ID = POD.STRUCTURE_ID AND POD2.IS_ROOT='Y' LEFT OUTER JOIN AGENCY_CODES ROOT ON ROOT.AGENCY_CODE = POD2.AGENCY_CODE WHERE TAB.CREATOR_DATE >= SYSDATE-30 GROUP BY AC.AGENCY_CODE, AC.AGENCY_DESC, ROOT.AGENCY_CODE, ROOT.AGENCY_DESC UNION SELECT 'INCIDENT_CASES', COUNT(*), AC.AGENCY_CODE, AC.AGENCY_DESC, NVL(ROOT.AGENCY_CODE, AC.AGENCY_CODE), NVL(ROOT.AGENCY_DESC, AC.AGENCY_DESC) FROM INCIDENT_CASES TAB LEFT OUTER JOIN AGENCY_CODES AC ON AC.AGENCY_CODE = TAB.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD ON POD.AGENCY_CODE = AC.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD2 ON POD2.STRUCTURE_ID = POD.STRUCTURE_ID AND POD2.IS_ROOT='Y' LEFT OUTER JOIN AGENCY_CODES ROOT ON ROOT.AGENCY_CODE = POD2.AGENCY_CODE WHERE TAB.CREATOR_DATE >= SYSDATE-30 GROUP BY AC.AGENCY_CODE, AC.AGENCY_DESC, ROOT.AGENCY_CODE, ROOT.AGENCY_DESC UNION SELECT 'DISPATCH_EVENTS', COUNT(*), AC.AGENCY_CODE, AC.AGENCY_DESC, NVL(ROOT.AGENCY_CODE, AC.AGENCY_CODE), NVL(ROOT.AGENCY_DESC, AC.AGENCY_DESC) FROM DISPATCH_EVENTS TAB LEFT OUTER JOIN AGENCY_CODES AC ON AC.AGENCY_CODE = TAB.AGENCY LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD ON POD.AGENCY_CODE = AC.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD2 ON POD2.STRUCTURE_ID = POD.STRUCTURE_ID AND POD2.IS_ROOT='Y' LEFT OUTER JOIN AGENCY_CODES ROOT ON ROOT.AGENCY_CODE = POD2.AGENCY_CODE WHERE TAB.CREATOR_DATE >= SYSDATE-30 GROUP BY AC.AGENCY_CODE, AC.AGENCY_DESC, ROOT.AGENCY_CODE, ROOT.AGENCY_DESC UNION SELECT 'FIELD_INTERVIEWS', COUNT(*), AC.AGENCY_CODE, AC.AGENCY_DESC, NVL(ROOT.AGENCY_CODE, AC.AGENCY_CODE), NVL(ROOT.AGENCY_DESC, AC.AGENCY_DESC) FROM FIELD_INTERVIEWS TAB LEFT OUTER JOIN AGENCY_CODES AC ON AC.AGENCY_CODE = TAB.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD ON POD.AGENCY_CODE = AC.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD2 ON POD2.STRUCTURE_ID = POD.STRUCTURE_ID AND POD2.IS_ROOT='Y' LEFT OUTER JOIN AGENCY_CODES ROOT ON ROOT.AGENCY_CODE = POD2.AGENCY_CODE WHERE TAB.CREATOR_DATE >= SYSDATE-30 GROUP BY AC.AGENCY_CODE, AC.AGENCY_DESC, ROOT.AGENCY_CODE, ROOT.AGENCY_DESC UNION SELECT 'ARRESTS', COUNT(*), AC.AGENCY_CODE, AC.AGENCY_DESC, NVL(ROOT.AGENCY_CODE, AC.AGENCY_CODE), NVL(ROOT.AGENCY_DESC, AC.AGENCY_DESC) FROM ARRESTS TAB LEFT OUTER JOIN AGENCY_CODES AC ON AC.AGENCY_CODE = TAB.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD ON POD.AGENCY_CODE = AC.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD2 ON POD2.STRUCTURE_ID = POD.STRUCTURE_ID AND POD2.IS_ROOT='Y' LEFT OUTER JOIN AGENCY_CODES ROOT ON ROOT.AGENCY_CODE = POD2.AGENCY_CODE WHERE TAB.CREATOR_DATE >= SYSDATE-30 GROUP BY AC.AGENCY_CODE, AC.AGENCY_DESC, ROOT.AGENCY_CODE, ROOT.AGENCY_DESC UNION SELECT 'E_WARRANTS', COUNT(*), AC.AGENCY_CODE, AC.AGENCY_DESC, NVL(ROOT.AGENCY_CODE, AC.AGENCY_CODE), NVL(ROOT.AGENCY_DESC, AC.AGENCY_DESC) FROM E_WARRANTS TAB LEFT OUTER JOIN AGENCY_CODES AC ON AC.AGENCY_CODE = TAB.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD ON POD.AGENCY_CODE = AC.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD2 ON POD2.STRUCTURE_ID = POD.STRUCTURE_ID AND POD2.IS_ROOT='Y' LEFT OUTER JOIN AGENCY_CODES ROOT ON ROOT.AGENCY_CODE = POD2.AGENCY_CODE WHERE TAB.CREATOR_DATE >= SYSDATE-30 GROUP BY AC.AGENCY_CODE, AC.AGENCY_DESC, ROOT.AGENCY_CODE, ROOT.AGENCY_DESC UNION SELECT 'PERMITS', COUNT(*), AC.AGENCY_CODE, AC.AGENCY_DESC, NVL(ROOT.AGENCY_CODE, AC.AGENCY_CODE), NVL(ROOT.AGENCY_DESC, AC.AGENCY_DESC) FROM PERMITS TAB LEFT OUTER JOIN AGENCY_CODES AC ON AC.AGENCY_CODE = TAB.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD ON POD.AGENCY_CODE = AC.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD2 ON POD2.STRUCTURE_ID = POD.STRUCTURE_ID AND POD2.IS_ROOT='Y' LEFT OUTER JOIN AGENCY_CODES ROOT ON ROOT.AGENCY_CODE = POD2.AGENCY_CODE WHERE TAB.CREATOR_DATE >= SYSDATE-30 GROUP BY AC.AGENCY_CODE, AC.AGENCY_DESC, ROOT.AGENCY_CODE, ROOT.AGENCY_DESC UNION SELECT 'ASSIGNMENTS', COUNT(*), AC.AGENCY_CODE, AC.AGENCY_DESC, NVL(ROOT.AGENCY_CODE, AC.AGENCY_CODE), NVL(ROOT.AGENCY_DESC, AC.AGENCY_DESC) FROM ASSIGNMENTS TAB LEFT OUTER JOIN AGENCY_CODES AC ON AC.AGENCY_CODE = TAB.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD ON POD.AGENCY_CODE = AC.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD2 ON POD2.STRUCTURE_ID = POD.STRUCTURE_ID AND POD2.IS_ROOT='Y' LEFT OUTER JOIN AGENCY_CODES ROOT ON ROOT.AGENCY_CODE = POD2.AGENCY_CODE WHERE TAB.CREATOR_DATE >= SYSDATE-30 GROUP BY AC.AGENCY_CODE, AC.AGENCY_DESC, ROOT.AGENCY_CODE, ROOT.AGENCY_DESC UNION SELECT 'CITATIONS', COUNT(*), AC.AGENCY_CODE, AC.AGENCY_DESC, NVL(ROOT.AGENCY_CODE, AC.AGENCY_CODE), NVL(ROOT.AGENCY_DESC, AC.AGENCY_DESC) FROM CITATIONS TAB LEFT OUTER JOIN AGENCY_CODES AC ON AC.AGENCY_CODE = TAB.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD ON POD.AGENCY_CODE = AC.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD2 ON POD2.STRUCTURE_ID = POD.STRUCTURE_ID AND POD2.IS_ROOT='Y' LEFT OUTER JOIN AGENCY_CODES ROOT ON ROOT.AGENCY_CODE = POD2.AGENCY_CODE WHERE TAB.CREATOR_DATE >= SYSDATE-30 GROUP BY AC.AGENCY_CODE, AC.AGENCY_DESC, ROOT.AGENCY_CODE, ROOT.AGENCY_DESC UNION SELECT 'COURT_PAPERS', COUNT(*), AC.AGENCY_CODE, AC.AGENCY_DESC, NVL(ROOT.AGENCY_CODE, AC.AGENCY_CODE), NVL(ROOT.AGENCY_DESC, AC.AGENCY_DESC) FROM COURT_PAPERS TAB LEFT OUTER JOIN AGENCY_CODES AC ON AC.AGENCY_CODE = TAB.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD ON POD.AGENCY_CODE = AC.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD2 ON POD2.STRUCTURE_ID = POD.STRUCTURE_ID AND POD2.IS_ROOT='Y' LEFT OUTER JOIN AGENCY_CODES ROOT ON ROOT.AGENCY_CODE = POD2.AGENCY_CODE WHERE TAB.CREATOR_DATE >= SYSDATE-30 GROUP BY AC.AGENCY_CODE, AC.AGENCY_DESC, ROOT.AGENCY_CODE, ROOT.AGENCY_DESC UNION SELECT 'IMPOUND', COUNT(*), AC.AGENCY_CODE, AC.AGENCY_DESC, NVL(ROOT.AGENCY_CODE, AC.AGENCY_CODE), NVL(ROOT.AGENCY_DESC, AC.AGENCY_DESC) FROM IMPOUND TAB LEFT OUTER JOIN IJIS_USER_PROFILES IUP ON IUP.LOGIN_ID = TAB.CREATOR_ID LEFT OUTER JOIN AGENCY_CODES AC ON AC.AGENCY_CODE = IUP.AGNCY_CD_AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD ON POD.AGENCY_CODE = AC.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD2 ON POD2.STRUCTURE_ID = POD.STRUCTURE_ID AND POD2.IS_ROOT='Y' LEFT OUTER JOIN AGENCY_CODES ROOT ON ROOT.AGENCY_CODE = POD2.AGENCY_CODE WHERE TAB.CREATOR_DATE >= SYSDATE-30 GROUP BY AC.AGENCY_CODE, AC.AGENCY_DESC, ROOT.AGENCY_CODE, ROOT.AGENCY_DESC UNION SELECT 'PHOTO_LINEUP', COUNT(*), AC.AGENCY_CODE, AC.AGENCY_DESC, NVL(ROOT.AGENCY_CODE, AC.AGENCY_CODE), NVL(ROOT.AGENCY_DESC, AC.AGENCY_DESC) FROM PHOTO_LINEUP TAB LEFT OUTER JOIN AGENCY_CODES AC ON AC.AGENCY_CODE = TAB.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD ON POD.AGENCY_CODE = AC.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD2 ON POD2.STRUCTURE_ID = POD.STRUCTURE_ID AND POD2.IS_ROOT='Y' LEFT OUTER JOIN AGENCY_CODES ROOT ON ROOT.AGENCY_CODE = POD2.AGENCY_CODE WHERE TAB.CREATOR_DATE >= SYSDATE-30 GROUP BY AC.AGENCY_CODE, AC.AGENCY_DESC, ROOT.AGENCY_CODE, ROOT.AGENCY_DESC UNION SELECT 'ITEM_ENTRIES', COUNT(*), AC.AGENCY_CODE, AC.AGENCY_DESC, NVL(ROOT.AGENCY_CODE, AC.AGENCY_CODE), NVL(ROOT.AGENCY_DESC, AC.AGENCY_DESC) FROM ITEM_ENTRIES TAB LEFT OUTER JOIN AGENCY_CODES AC ON AC.AGENCY_CODE = TAB.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD ON POD.AGENCY_CODE = AC.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD2 ON POD2.STRUCTURE_ID = POD.STRUCTURE_ID AND POD2.IS_ROOT='Y' LEFT OUTER JOIN AGENCY_CODES ROOT ON ROOT.AGENCY_CODE = POD2.AGENCY_CODE WHERE TAB.CREATOR_DATE >= SYSDATE-30 GROUP BY AC.AGENCY_CODE, AC.AGENCY_DESC, ROOT.AGENCY_CODE, ROOT.AGENCY_DESC UNION SELECT 'DV_ASSIGNMENTS', COUNT(*), AC.AGENCY_CODE, AC.AGENCY_DESC, NVL(ROOT.AGENCY_CODE, AC.AGENCY_CODE), NVL(ROOT.AGENCY_DESC, AC.AGENCY_DESC) FROM DV_ASSIGNMENTS TAB INNER JOIN DEPARTMENT_VEHICLES DV ON DV.VEHICLE_ID = TAB.VEHICLE_ID LEFT OUTER JOIN AGENCY_CODES AC ON AC.AGENCY_CODE = DV.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD ON POD.AGENCY_CODE = AC.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD2 ON POD2.STRUCTURE_ID = POD.STRUCTURE_ID AND POD2.IS_ROOT='Y' LEFT OUTER JOIN AGENCY_CODES ROOT ON ROOT.AGENCY_CODE = POD2.AGENCY_CODE WHERE TAB.CREATOR_DATE >= SYSDATE-30 GROUP BY AC.AGENCY_CODE, AC.AGENCY_DESC, ROOT.AGENCY_CODE, ROOT.AGENCY_DESC UNION SELECT 'PROPERTY_HOLDS', COUNT(*), AC.AGENCY_CODE, AC.AGENCY_DESC, NVL(ROOT.AGENCY_CODE, AC.AGENCY_CODE), NVL(ROOT.AGENCY_DESC, AC.AGENCY_DESC) FROM PROPERTY_HOLDS TAB LEFT OUTER JOIN AGENCY_CODES AC ON AC.AGENCY_CODE = TAB.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD ON POD.AGENCY_CODE = AC.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD2 ON POD2.STRUCTURE_ID = POD.STRUCTURE_ID AND POD2.IS_ROOT='Y' LEFT OUTER JOIN AGENCY_CODES ROOT ON ROOT.AGENCY_CODE = POD2.AGENCY_CODE WHERE TAB.CREATOR_DATE >= SYSDATE-30 GROUP BY AC.AGENCY_CODE, AC.AGENCY_DESC, ROOT.AGENCY_CODE, ROOT.AGENCY_DESC UNION SELECT 'EVIDENCE', COUNT(*), AC.AGENCY_CODE, AC.AGENCY_DESC, NVL(ROOT.AGENCY_CODE, AC.AGENCY_CODE), NVL(ROOT.AGENCY_DESC, AC.AGENCY_DESC) FROM EVIDENCE TAB LEFT OUTER JOIN AGENCY_CODES AC ON AC.AGENCY_CODE = TAB.AGNCY_CD_AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD ON POD.AGENCY_CODE = AC.AGENCY_CODE LEFT OUTER JOIN PSEUDO_ORG_DESCRIPTORS POD2 ON POD2.STRUCTURE_ID = POD.STRUCTURE_ID AND POD2.IS_ROOT='Y' LEFT OUTER JOIN AGENCY_CODES ROOT ON ROOT.AGENCY_CODE = POD2.AGENCY_CODE WHERE TAB.CREATOR_DATE >= SYSDATE-30 GROUP BY AC.AGENCY_CODE, AC.AGENCY_DESC, ROOT.AGENCY_CODE, ROOT.AGENCY_DESC
 
Possibly Referenced Tables/Views:
ADDRESSES AGENCY_CODES ARRESTS ASSIGNMENTS BUSINESSES CITATIONS COURT_PAPERS DEPARTMENT_VEHICLES DISPATCH_EVENTS DV_ASSIGNMENTS E_WARRANTS EVIDENCE FIELD_INTERVIEWS GANGS IJIS_USER_PROFILES IMPOUND INCIDENT_CASES INCIDENT_SUPPLEMENTS INCIDENTS ITEM_ENTRIES PEOPLE PERMITS PHOTO_LINEUP PROPERTIES PROPERTY_HOLDS PSEUDO_ORG_DESCRIPTORS VEHICLES 


Close relationships: