-
Log on to Smart Materials, and click Administration.
-
Under GLOBAL SETUP, click Tables and Properties.
-
Click Properties tab.
-
Define the GROUP and PART properties.
-
In the SQL Statement box, enter the following statement for the GROUP attribute:
SELECT CG.CG_GROUP_CODE, CGN.SHORT_DESC, CGN.DESCRIPTION FROM M_COMMODITY_GROUPS CG, M_COMMODITY_GROUP_NLS CGN WHERE CG.GROUP_ID = CGN.GROUP_ID(+) AND CGN.NLS_ID(+) = MPCK_LOGIN.CURRENT_NLS_ID ORDER BY CG.CG_GROUP_CODE
-
For the PART attribute, enter the following statement in the SQL Statement box:
SELECT P.PART_CODE, CG.CG_GROUP_CODE, PN.SHORT_DESC, PN.DESCRIPTION FROM M_PARTS P, M_COMMODITY_GROUPS CG, M_PART_NLS PN WHERE P.GROUP_ID = CG.GROUP_ID AND P.GROUP_ID = PN.GROUP_ID(+) AND P.PART_ID = PN.PART_ID(+) AND PN.NLS_ID(+) = MPCK_LOGIN.CURRENT_NLS_ID ORDER BY P.PART_CODE, CG.CG_GROUP_CODE
-
On the Tables Management screen, define a new table BEND with table type GEOM_S4013.
-
On the Tables/Attributes grid, assign three attributes to the BEND table:
-
NPS (nominal pipe size), assigned to GD.IN1
-
GROUP, assigned to GD.IN2
-
PART, assigned to GD.IN3
-
-
Select the attribute from the LOV in the Attr Name box and the physical attribute (database column) from the LOV in the Physical Attribute box.
-
Select the Required check box for all attributes.
-
Create the geometric table on the Filter Geometrics screen.
-
Enter the geometric name in the Geometric box.
The name must start with the string BEND, for example, BEND-10BD113.
-
Select the table name BEND from the LOV in the TableName box.
-
Enter geometric descriptions in the Short Description and Description boxes.
-
Select a standard from the LOV in the Standard Code box.
-
Save the new geometric.
-
Double-click the table BEND-10BD113 to open in the grid.
-
Enter the nominal diameter in the Nps box, select the group from the LOV in the Group box, and select the part from the LOV in the Part box.
-
Attach this bend geometric to the specification on the Spec Editor screen.
-
On the Spec Header Geometric tab, select a short code from the LOV in the Short Code box.
-
Select User defined from the LOV in the Table Type box.
-
Select the previously created bend geometric name from the LOV in the Table Name box.
-
Type the allowed range in the From1 and To1 boxes.
The Filter indicator must not be selected.
If you have defined the PULLEDBEND default with TRUE in the export job default set,
the bends are inserted with operation = BendPipe. The component type for the bends
is defined using the M_PCK_SPISO_CUSTOM.ComponentTypeForBendPipe CIP function.