Piping Isometric WBS Item Continuation - Intergraph Smart 3D - Help - Hexagon

Intergraph Smart 3D Catalog

Language
English
Product
Intergraph Smart 3D
Subproduct
Catalog
Search by Category
Help
Smart 3D Version
13.1

Name: Piping Isometric WBS Item Continuation
Description: WBS Item Continuation Label for Isometrics
Type: SQL
Is Recursive: No
Conditional Formatting: No
Design Time Prog ID: SP3DLabelFormatDesigner.RTFLabel
Run Time Prog ID: SP3DLabelsFormat.FormatLabel
Returned Properties:
SQL Query:
SELECT n.itemname as "Pipeline Name",
wbs.WBSPurpose as Purpose,
wn.itemname as "WBS Name"
FROM JPartOcc po
LEFT JOIN XOwnsParts xop on xop.oiddestination = po.oid
LEFT join XSystemHierarchy xsh on xsh.oiddestination = xop.oidorigin
LEFT JOIN JNamedItem n on n.oid = xsh.oidorigin
LEFT JOIN XBelongsToWBSItem xbtw on xbtw.oiddestination = po.oid
LEFT JOIN JWBSItem wbs on wbs.oid = xbtw.oidorigin
LEFT JOIN JNamedItem wn on wn.oid =wbs.oid

WHERE po.OID=?