Electrical Cable Power - Intergraph Smart 3D - Help

Intergraph Smart 3D Catalog

PPMProductFamily
3D Design and Visualization
PPMProduct
Intergraph Smart 3D
PPMCategory
Help
Version_S3D
11.x(2016)

Name: Electrical Cable Power
Description: Cable Power Rating
Type: SQL
Is Recursive: No
Conditional Formatting: No
Design Time Prog ID: SP3DLabelFormatDesigner.RTFLabel
Run Time Prog ID: SP3DLabelsFormat.FormatLabel
Returned Properties: PowerCapacity

SQL Query:
SELECT cabcap.PowerCapacity AS PowerCapacity
FROM JRteCableRun cabrun
LEFT JOIN XSpecifiedCable cabs ON cabs.oidOrigin = cabrun.oid
LEFT JOIN JCablePart cabprt ON cabprt.oid = cabs.oiddestination
LEFT JOIN JCableCapacity cabcap ON cabcap.oid = cabprt.oid
WHERE cabrun.oid = ?