87: JOIN tab$ t
88: ON (t.obj#=DECODE(x.clstobj#,NULL,x.detailobj#,x.clstobj#))
89: ) xx
90: -- needed for deferred segments and partitioned objects 91: LEFT OUTER JOIN seg$ s 92: ON (xx.file# = s.file#
93: AND xx.block# = s.block#
94: AND xx.ts# = s.ts#)) loop
95: