View slot9.WORLD.TSTA.JS_INCIDENT_PROPERTY_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
INCIDENT_ID number 0
INCIDENTS.INCIDENT_ID Implied Constraint R
INC_REPORT_NUMBER varchar2 20
REPORT_DATE date 7
START_DATE date 7  √  null
END_DATE date 7  √  null
SUMMARY varchar2 1000  √  null
SUPP_AGENCY_CODE varchar2 30  √  null
SUPP_AGENCY_DESC varchar2 40  √  null
INCIDENT_STATUS_CODE varchar2 30
INCIDENT_STATUS_DESC varchar2 4000  √  null
SUPP_SEQ number 0
RESPONSIBLE_USER_ID varchar2 100  √  null
AGENCY_ONLY varchar2 1  √  null
CID varchar2 1  √  null
SECURITY_LEVEL number 38  √  null
APPROVING_AGENCY_CODE varchar2 30  √  null
APPROVING_AGENCY_DESC varchar2 40  √  null
PROPERTY_STATUS_CODE varchar2 30  √  null
PROPERTY_STATUS_DESC varchar2 4000  √  null
INC_PROP_ID number 0
INCIDENT_PROPERTIES.INC_PROP_ID Implied Constraint R
PROPERTY_ID number 0
PROPERTIES.PROPERTY_ID Implied Constraint R
PROPERTY_TYPE_CODE varchar2 30
PROPERTY_TYPE_DESC varchar2 4000  √  null
EVIDENCE varchar2 1
DOCUMENT varchar2 30
TYPE_OF_QUANTITY varchar2 30  √  null
PRIMARY_COLOR varchar2 30  √  null
PRIMARY_COLOR_DESC varchar2 4000  √  null
SECONDARY_COLOR varchar2 30  √  null
SECONDARY_COLOR_DESC varchar2 4000  √  null
DRUG_TYPE varchar2 30  √  null
DRUG_TYPE_DESC varchar2 4000  √  null
QUANTITY number 20,3  √  null
DESCRIPTION varchar2 2500  √  null
MAKE varchar2 20  √  null
MODEL varchar2 25  √  null
SERIAL_NUMBER varchar2 25  √  null
VALUE number 11,2  √  null
MISC varchar2 160  √  null
DOCUMENT_NUMBER varchar2 6  √  null
BANK varchar2 40  √  null
DOCUMENT_DATE date 7  √  null
ACCOUNT_NAME varchar2 40  √  null
ACCOUNT_NUMBER number 16  √  null
PAYABLE_TO varchar2 40  √  null
AMOUNT number 12,2  √  null
ENDORSEE varchar2 40  √  null
BARREL_LENGTH varchar2 20  √  null
CALGAG_CODE varchar2 30  √  null
CALGAG_DESC varchar2 4000  √  null
GUN_ACT_CODE varchar2 30  √  null
GUN_ACT_DESC varchar2 4000  √  null
GUN_TYP_CODE varchar2 30  √  null
GUN_TYP_DESC varchar2 4000  √  null
CURRENCY_CODE varchar2 30  √  null
CURRENCY_DESC varchar2 4000  √  null
INDX_SEC_LEVEL_CODE number 0  √  null
MASTER_INDEX_SECURITY_CODES.INDX_SEC_LEVEL_CODE Implied Constraint R
DENOMINATION_CODE varchar2 30  √  null
DENOMINATION_DESC varchar2 4000  √  null
PRPTY_CASH_QUANTITY number 0  √  null
SUB_TOTAL number 14,2  √  null
PROPERTY_INFO varchar2 4000  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT DISTINCT i.incident_id, i.inc_report_number, i.report_date, i.start_date, i.end_date, i.summary, isupp.supp_agency_code, (select ac1.agency_desc from agency_codes ac1 where ac1.agency_code = isupp.supp_agency_code), isupp.isc_status_code, (SELECT INITCAP (ec.description) FROM ejs_codes ec WHERE ec.code_type = 'INCIDENT_STATUS_CODES' AND ec.code = isupp.isc_status_code), isupp.supp_seq, isupp.responsible_user_id, isupp.agency_only, isupp.cid, isupp.security_level, isupp.approving_agency_code, (select ac.agency_desc from agency_codes ac where ac.agency_code = isupp.approving_agency_code), ip.status_code, (select ps.description from ejs_codes ps where ps.code_type = 'PROPERTY_STATUS_CODES' and ps.code = ip.status_code), ip.inc_prop_id, p.property_id, p.property_type_code, (SELECT pt.description FROM ejs_codes pt where pt.code_type = 'PROPERTY_TYPE_CODES' and pt.code = p.property_type_code), p.evidence, p.document, p.type_of_quantity, p.primary_color, (select pcol.description from ejs_codes pcol where pcol.code_type = 'COLOR_CODES' and pcol.code = p.primary_color), p.secondary_color, (select pcol2.description from ejs_codes pcol2 where pcol2.code_type = 'COLOR_CODES' and pcol2.code = p.secondary_color), p.drug_type, (select dt.description from ejs_codes dt where dt.code_type = p.drug_type_type and dt.code = p.drug_type), p.quantity, p.description, p.make, p.model, p.serial_number, p.VALUE, p.misc, p.document_number, p.bank, p.document_date, p.account_name, p.account_number, p.payable_to, p.amount, p.endorsee, p.barrel_length, p.calgag_code, (select calg.description from ejs_codes calg where calg.code_type = p.calgag_code_type and calg.code = p.calgag_code), p.gun_act_code, (select gun.description from ejs_codes gun where gun.code_type = p.gun_act_code_type and gun.code = p.gun_act_code), p.gun_typ_code, (select gt.description from ejs_codes gt where gt.code_type = p.gun_typ_code_type and gt.code = p.gun_typ_code), p.currency_code, (select cr.description from ejs_codes cr where cr.code_type = p.currency_code_type and cr.code = p.currency_code), p.indx_sec_level_code, pc.denomination_code, (select den.description from ejs_codes den where den.code_type = pc.denomination_code_type and den.code = pc.denomination_code), pc.quantity, pc.sub_total, ejs_get_property_desc(p.property_id) FROM properties p, incident_properties ip, incident_supplements isupp, incidents i, property_cash pc WHERE p.property_id = ip.property_id AND ip.incsup_incident_id = isupp.inc_incident_id AND ip.incsup_supp_seq = isupp.supp_seq AND i.incident_id = isupp.inc_incident_id AND p.property_id = pc.property_id(+)
 
Possibly Referenced Tables/Views:
AGENCY_CODES EJS_CODES INCIDENT_PROPERTIES INCIDENT_SUPPLEMENTS INCIDENTS PROPERTIES PROPERTY_CASH PROPERTY_TYPE_CODES 


Close relationships: