View lawprod.MSCM.ITEM_ON_TRAY_LIST_HELP 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_ID number 22
ITEM.ITEM_ID Implied Constraint R
TL_ID number 22
TRAY_LIST.TL_ID Implied Constraint R
TL_NO varchar2 6
SOURCE_LOCATION_NO number 22  √  null
QTY number 22

Analyzed at Wed May 18 12:10 CDT 2011

View Definition:
SELECT TL_ITEM.ITEM_ID, TL_GROUP.TL_ID, TRAY_LIST_CURRENT_VIEW.TL_NO, TRAY_LIST_CURRENT_VIEW.SOURCE_LOCATION_NO, TL_ITEM.QTY FROM TL_ITEM, TL_GROUP, TRAY_LIST_CURRENT_VIEW WHERE TL_GROUP.TL_ID = TRAY_LIST_CURRENT_VIEW.TL_ID AND TL_ITEM.TL_GRP_ID = TL_GROUP.TL_GRP_ID
 
Possibly Referenced Tables/Views:
TL_GROUP TL_ITEM TRAY_LIST_CURRENT_VIEW 


Close relationships: