Name: Piping Stress Analysis Fluid Density
Description: Fluid density per part, for export to stress analysis
Type: SQL
Is Recursive: No
Conditional Formatting: No
Design Time Prog ID: SP3DLabelFormatDesigner.RTFLabel
Run Time Prog ID: SP3DLabelsFormat.FormatLabel
Returned Properties: FluidDensity
SQL Query:
SELECT Density as FluidDensity
FROM JRtePathGenPart jpgp
JOIN XOwnsParts rop on rop.oiddestination = jpgp.oid
JOIN JProcessDataInfo jpdi on jpdi.oid = rop.oidorigin
JOIN YPipelinetoPipingParts eppp on eppp.oidorigin = jpgp.oid
JOIN JPipelineSystem jps on jps.oid = eppp.oiddestination
JOIN JFluidDensityRule jfdr on jfdr.FluidCode = jps.FluidCode
WHERE jpdi.OperatingMaxTemp Between TemperatureFrom AND TemperatureTo