View lawprod.MSCM.ITEM_INFO_VIEW Generated by
SchemaSpy
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
ITEM_NO varchar2 32
INSTRUMENT_ID varchar2 32  √  null
ITEM_DESCRIPTION varchar2 100  √  null

Analyzed at Wed May 18 12:10 CDT 2011

View Definition:
SELECT ITEM_NO, INSTRUMENT_ID, DECODE(LI.ALT_ITEM_DESCRIPTION, '', I.DESCR, LI.ALT_ITEM_DESCRIPTION) ITEM_DESCRIPTION FROM INSTRUMENT_TRACK IT, LOCATION_ITEM LI, ITEM I WHERE IT.LOCATION_ITEM_ID = LI.LOCATION_ITEM_ID AND I.ITEM_ID = LI.ITEM_ID AND IT.STATUS='A'
 
Possibly Referenced Tables/Views:
INSTRUMENT_TRACK ITEM LOCATION_ITEM