Name: Piping Pipe Run Thickness
Description:
Type: SQL
Is Recursive: No
Conditional Formatting: No
Design Time Prog ID: SP3DLabelFormatDesigner.RTFLabel
Run Time Prog ID: SP3DLabelsFormat.FormatLabel
Returned Properties: WallThickness
SQL Query:
SELECT pp.WallThicknessOrGrooveSetback AS WallThickness
FROM XMadeFrom rmf
LEFT JOIN XPartContainsNozzles rpcn on rpcn.oidorigin = rmf.oiddestination
LEFT JOIN JCatalogPipePort pp on pp.oid = rpcn.oiddestination
WHERE pp.TerminationClass = 10 and pp.PortIndex=2 and rmf.oidorigin=?