Where Conditions - Intergraph Smart Materials - 10.1 - Training - Hexagon

Purpose

This section explains how to define the where conditions needed for the requisition template definition. By means of the where condition, the MTO job selects the material for each requisition.

Exercise

1. Open the A.60.06 Where Conditions screen from the Administration > A.60 Utilities menu branch. The screen opens in input mode; all fields are empty and the mandatory fields are displayed with a green background.

2. Enter ‘PIPES’ in the Name field and ‘Pipes’ in the Short Desc and Description fields. ‘Attribute based’ is automatically set as the default in the Kind of field; do not change it. Click in the Module field and open the LOV using the List of Values button, select R1041 from the list, and click OK to complete the selection.

3. To save the new where condition, click the Save button.

   

4. In the second (Attributes for Where Conditions) block, the condition ‘Ident mapped to Ident’ was automatically inserted. This condition is an internal condition and must not be changed.

5. Click into the Attribute field of the next empty record. Click the List of Values button to open the LOV. Select GROUP_CODE from the list and click OK to complete the selection.

6. Select = as the operator from the dropdown list in the Operator field.

   The operator = means that the value found for this attribute must exactly match the value entered in the Value field.

7. Enter ‘P’ in the Value field.

   In our example, P is the group code of the Pipes commodity group.

8. Click the Save button to save the changes.

9. Click the button to create the associated MV_WHERE view. The View Status field should beset to Valid as displayed in the picture below.

   

10. Create additional where conditions in the same way as described above. Here are the details:

    Name	Short Desc	Description	GROUP_CODE
    FLANGES	Flanges	Flanges	‘F’
    BW FITTINGS	BW Fittings	Buttweld Fittings	‘B’
    FO FITTINGS	Forged Fittings	Forged Fittings	‘O’

11. Click the Save button to save the changes. All where conditions should have the View Status field set to ‘Valid’.

12. Create another where condition called ‘ALL’ without any restriction. Enter ‘ALL’ in the Name field and ‘All material’ in the Short Desc and Description fields. Click in the Module field and open the LOV using the List of Values button, select R1041 from the list, and click OK to complete the selection.

13. To save the new where condition, click the Save button.

14. Close the screen by selecting File > Close All or Close from the main menu.