View lawprod.MSCM.TRAY_LIST_ASSEMBLY_TIME_VW 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
TL_NO varchar2 6
AVG_ASSEMBLY_SECONDS number 22  √  null

Analyzed at Wed May 18 12:10 CDT 2011

View Definition:
SELECT TRAY_LIST.TL_NO, AVG(TRAYSET.ASSM_DT - TRAYSET.CREAT_DT) * (60 * 60 * 24) AS AVG_ASSEMBLY_SECONDS FROM TRAY_LIST, TRAYSET WHERE TRAY_LIST.TL_ID = TRAYSET.TL_ID AND TRAYSET.ASSM_DT > TRAYSET.CREAT_DT GROUP BY TRAY_LIST.TL_NO
 
Possibly Referenced Tables/Views:
TRAY_LIST TRAYSET