-
In Smart Materials, define the GROUP and PART attributes on the A.50.01 Attributes screen.
-
In the Derived From 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 Derived From 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 A.50.02 Tables screen, define a new table BEND with table type GEOM_S4013.
-
On the A.50.03 Tables/Attributes screen, 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 S.40.13 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 Desc and Description boxes.
-
Select a standard from the LOV in the Standard box.
-
Save the new geometric.
-
Double-click in the Geometric box to open Window 2, where geometric details are specified.
-
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 S.50.06 Maintain Specification 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.