smartplant materials weldolets - hyundai...

SmartPlant Materials Weldolets

Version 2008 (6.3.1) June 2008 DMAR1-PE-200021F

Copyright Copyright © 2002-2008 Intergraph Corporation. All Rights Reserved.

Including software, file formats, and audiovisual displays; may be used pursuant to applicable software license agreement; contains confidential and proprietary information of Intergraph and/or third parties which is protected by copyright law, trade secret law, and international treaty, and may not be provided or otherwise made available without proper authorization.

Restricted Rights Legend Use, duplication, or disclosure by the government is subject to restrictions as set forth below. For civilian agencies: This was developed at private expense and is “restricted computer software” submitted with restricted rights in accordance with subparagraphs (a) through (d) of the Commercial Computer Software - Restricted Rights clause at 52.227-19 of the Federal Acquisition Regulations (“FAR”) and its successors, and is unpublished and all rights are reserved under the copyright laws of the United States. For units of the Department of Defense (“DoD”): This is “commercial computer software” as defined at DFARS 252.227-7014 and the rights of the Government are as specified at DFARS 227.7202-3. Unpublished – rights reserved under the copyright laws of the United States. Intergraph Corporation Huntsville, Alabama 35894-0001

Warranties and Liabilities All warranties given by Intergraph Corporation about equipment or software are set forth in your purchase contract, and nothing stated in, or implied by, this document or its contents shall be considered or deemed a modification or amendment of such warranties. Intergraph believes the information in this publication is accurate as of its publication date.

The information and the software discussed in this document are subject to change without notice and are subject to applicable technical product descriptions. Intergraph Corporation is not responsible for any error that may appear in this document.

The software discussed in this document is furnished under a license and may be used or copied only in accordance with the terms of this license.

No responsibility is assumed by Intergraph for the use or reliability of software on equipment that is not supplied by Intergraph or its affiliated companies. THE USER OF THE SOFTWARE IS EXPECTED TO MAKE THE FINAL EVALUATION AS TO THE USEFULNESS OF THE SOFTWARE IN HIS OWN ENVIRONMENT.

Trademarks Intergraph, the Intergraph logo, SmartSketch, FrameWorks, SmartPlant, INtools, MARIAN, PDS, and IntelliShip are registered trademarks of Intergraph Corporation. Microsoft and Windows are registered trademarks of Microsoft Corporation. Other brands and product names are trademarks of their respective owners.

Table of Contents

SmartPlant Materials Weldolets 3

Table of Contents Introduction ........................................................................................................................4

Weldolet Issues ............................................................................................................4

Implementing Weldolets in SmartPlant Materials .........................................................5

Define the Geometrics for Weldolets ...........................................................................5 Enter Weldolet Geometrics in S.40.12 in Size Ranges ................................................6 Create Object-Parameter with Size-Ranges .................................................................7 Create Commodity Codes the Normal Way .................................................................8 Create Idents the Normal Way .....................................................................................9 Enter the Commodity Code into the Specification .....................................................10 This is the Filter Geometric on Spec-Items ................................................................11 Check Screen S.50.07 .................................................................................................12 Test the Weldolet in the BOM ....................................................................................13 VIEW MV_SPEC_ITEM_IDENTS ...........................................................................15

Introduction

4 SmartPlant Materials Weldolets

Introduction Weldolet Issues

In a normal workflow, branches up to a specific size are only purchased in one size. For example, from a PDS® drawing weldolets can be imported into a BOM. For a case where the following sizes and quantities needed:

10"x1"- 1 piece, 12"x1"- 1 piece, and 14"x1"- 1 piece

The purchase requisition would be for one size:

14"x1"- 3 pieces

Later when issuing material for this at a site-specific line, when those sizes and quantities are requested (10"x1"- 1 piece, 12"x1"- 1 piece, and 14"x1"- 1 piece) the 14"x1"- 3 pieces will be issued. This situation requires a BOM be made for all possible physical sizes of a part, even though requisitions for the part only exist in a specific size.

Implementing Weldolets in SmartPlant Materials


Implementing Weldolets in SmartPlant Materials Define the Geometrics for Weldolets

Figure 1: A.50.03 Tables/Attributes



Enter Weldolet Geometrics in S.40.12 in Size Ranges

Figure 2: S.40.12 Commodity Geometrics



Create Object-Parameter with Size-Ranges

Figure 3: S.10.05 Object Parameter Detail



Create Commodity Codes the Normal Way

Figure 4: S.30.01 Commodity Codes



Create Idents the Normal Way

Figure 5: S.80.01 Build New Idents

Figure 6: S.80.06 Ident Text



Enter the Commodity Code into the Specification

Figure 7: S.50.06 Specification Idents



This is the Filter Geometric on Spec-Items

Figure 8: S.40.13 Filter Geometrics



Check Screen S.50.07

Figure 9: S.50.07 Specification Item with Idents



Test the Weldolet in the BOM

Figure 10: B.20.01 Edit BOM

Entered the positions:

• WEL 3 4

• WEL 3 6

• WEL 3 8

• WEL 4 6

• WEL 4 8

• WEL 4 10

After the find_ident function was performed, the following items were found:

• WEL 3 4 >>> WEL 3 4-10 Ident=I747398

• WEL 3 6 >>> WEL 3 4-10 Ident=I747398

• WEL 3 8 >>> WEL 3 4-10 Ident=I747398

• WEL 4 6 >>> WEL 4 6-10 Ident=I747400

• WEL 4 8 >>> WEL 4 6-10 Ident=I747400

• WEL 4 10 >>> WEL 4 6-10 Ident=I747400



Figure 11: B.20.01 Edit BOM (2)



VIEW MV_SPEC_ITEM_IDENTS union /* only for oletes input1 =DN input_2 =DN_VON input_3 =DN_BIS input_4=SCH1 input_5 =sch2 */

SELECT distinct SI.SPEC_ITEM_ID ,SI.HEADER_ID ,mI.COMMODITY_ID ,mI.IDENT ,mI.IDENT_CODE ,mI.INPUT_1 input_1 ,gd2.INPUT_1 input_2 ,gd2.INPUT_1 input_3 ,mI.INPUT_4 input_4 ,mI.INPUT_5 ,mI.OUTPUT_1 ,mI.OUTPUT_2 ,mI.OUTPUT_3 ,mI.OUTPUT_4 ,mI.OUTPUT_5 ,mI.OUTPUT_6 ,mI.OUTPUT_7 ,mI.OUTPUT_8 ,mI.OUTPUT_9 ,mI.OUTPUT_10 ,mI.OUTPUT_11 ,mI.OUTPUT_12 ,mI.OUTPUT_13 ,mI.OUTPUT_14 ,mI.OUTPUT_15 ,si.short_code from m_geom_details gd2 ,m_geom_details gd , mvp_idents mi, m_spec_items si where si.spec_item_id >0 and nvl(si.size1_gn_id,0) >0 /* Geometric Filter Table must be on Spec-Item*/

and si.commodity_id =mi.commodity_id and to_number(mi.input_1) between to_number(from_size1) and to_number(to_size1) and decode(to_char(si.from_size2,'0000000.9999'),null,'0',m_sort(mi.input_2))

between nvl(to_char(si.from_size2,'0000000.9999'),'0')

and nvl(to_char(si.to_size2,'0000000.9999'),'0')

and nvl(to_char(si.attr_num3),mi.input_5)=mi.input_5 and -- for Weldolets gd.gn_id = si.size1_gn_id and gd2.gn_id = si.size1_gn_id and gd.input_1 = mi.input_1 and gd.input_2 = decode(mi.input_4,'0',gd.input_2 ,mi.input_4) and m_sort(gd2.input_1) between m_sort(mi.input_2) and m_sort(mi.input_3)

and gd2.input_2 = decode(mi.input_5,'0',gd2.input_2 ,mi.input_5)

smartplant materials weldolets - hyundai...

Documents