--------------------------------------------------------
--  File created - Wednesday-July-21-2021   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table PIMS_RPC_DETAILS
--------------------------------------------------------

  CREATE TABLE "PIMS_NEW"."PIMS_RPC_DETAILS" 
   (	"RPC_STOCK_NUMBER" VARCHAR2(30 BYTE), 
	"CONNECTION1" VARCHAR2(30 BYTE), 
	"CONNECTION2" VARCHAR2(30 BYTE), 
	"CONNECTION3" VARCHAR2(30 BYTE), 
	"CONNECTION4" VARCHAR2(30 BYTE), 
	"CONNECTION5" VARCHAR2(30 BYTE), 
	"CONNECTION6" VARCHAR2(30 BYTE), 
	"CONNECTION7" VARCHAR2(30 BYTE), 
	"CONNECTION8" VARCHAR2(30 BYTE), 
	"UNIT_PART_NUMBER" VARCHAR2(30 BYTE), 
	"FULL_STRING" VARCHAR2(250 BYTE)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "PIMS_NEW_D" ;
REM INSERTING into PIMS_NEW.PIMS_RPC_DETAILS
SET DEFINE OFF;
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067077',null,'0071171.1','0073715.1',null,'0071167.1','0071956.1',null,'0071682.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071683','0072669.1','0072670.1',null,null,'0072673.1','0072733.1',null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071684','0072698.1',null,null,null,'0059507.1','0059540.1','0072677.1',null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071685',null,null,null,'0059117.1',null,null,null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071686','0071926.1','0071927.1','0071928.1','0071929.1','0071930.1','0071931.1','0071932.1','0071933.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071687','0072285.1','0072284.1','0074104.2','0072688.1','0072689.1','0071950.1','0072690.1',null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071688','0073833.1','0071827.1','0071828.1','0070948.1','0070949.1','0072270.1','0072269.1',null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071689','0071986.1','0071987.1','0071988.1','0071989.1','0071990.1','0071991.1','0071992.1','0071993.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071690','0073712.1','0069587.1',null,'0070571.1','0059140.1',null,null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071691',null,'0071013.1','0071021.1','0071012.1','0071403.1','0074090.1','0064989.1',null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071692','0071297.1','0071298.1','0071296.1','0071299.1','0058760.1',null,null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0068482','0062074.1','0062073.1','0058575.1',null,null,null,null,'0072244.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0068484','0070770.1','0058692.1','0074225.1','0073591.1','0058695.1','0058561.1','0073741.1','0071535.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0070089','0073710.1','0071971.1','0071358.1','0071970.1','00712206.1','0071157.1','0071221.1',null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071094','0070825.1','0070829.1','0070833.1','0070817.1','0070816.1','0070814.1','0070810.1','0070831.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071097',null,null,null,null,null,null,null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071091',null,'0056094.1','0058503.1','0059629.1','0058505.1','0055946.1',null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071098','preload.1','preload.2','preload.3','preload.4','preload.5','preload.6','0071962.1',null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071092','0072271.1','0072272.1','0072273.1','0072274.1','0072275.1','0067694.1','0072286.1',null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071096','0070828.1','0070824.1','0070815.1','0070820.1','0070823.1','0070818.1','0070822.1','0070830.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071090','0073714.1',null,'0055837.1','0055764.1','0073709.1',null,'0059137.1',null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071095','0070832.1','0070813.1','0070812.1','0070827.1','0070821.1','0071703.1','0070826.1','0070819.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071099',null,null,null,null,null,null,null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071093','71509.2',null,'71510.2',null,'71511.2',null,'71512.2',null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071239',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071240',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071241',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071242',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071243',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071244',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071245',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071246',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071247',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071248',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0072586',null,null,null,null,null,null,null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0072587','0061411.1','0071407.1','0059135.1','0058762.1','0072220.1','0071231.1','0071230.1','0059504.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0072588',null,null,null,null,null,null,null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0072589','0073696.1',null,null,null,null,null,null,'B0003241.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0072590','0071168.1','0071172.1',null,null,null,null,'0070951.1','0070950.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0072591',null,null,null,null,null,null,null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067097','0059501.1','0059502.1','0071282.1',null,'0071288.1','0071279.1','0071291.1','0071280.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067075',null,null,null,null,null,null,null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067098',null,'0057285.1','0063508.1','0069399.1',null,null,'0059558.1',null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067083','0058588.1','0058576.1','0059511.1','0058589.1','0071347.1','0073942.1',null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067093','0060850.1','0068742.1',null,null,'0071721.1','0069114.1',null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067071','0070526.1','0071959.1',null,'0063509.1',null,null,'0070714.1','0070715.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067104','0059086.1','0059088.1','0071285.1','0071278.1','0071287.1','0071286.1','0071292.1',null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067099','0067650.2','0067655.1','0067651.1','0067656.1','0067652.1','0067657.1','0067654.1','0067653.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067100','0068642.1','0067697.1','0068643.1','0068362.1','0068364.1',null,null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067090','0071968.1',null,null,'B0003240.1','0071237.1','0071399.1','0062938.1','0072245.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067105',null,'0059120.1','0071351.1','0071344.1','0071295.1','0071293.1','0072253.1','0072254.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067080','0058579.1','0069402.1','0069403.1','0069373.1','0058594.1','0061761.1','0072541.1','0072542.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067066','0071401.1','0069435.1','0071353.1','0071349.1','0071396.1','0071397.1','0071341.1','0071342.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067051','0065299.1','0066528.1','0071283.1','0055955.1','0059136.1','0064526.1','0059509.1','0059510.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067094','0056958.1','0068891.1','0068868.1','0068872.1','0068870.1','0068871.1','0068869.1',null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067050','0059506.1','0072676.1','0074087.1','0061413.1','0058581.1','0061416.1','0062939.1','0061419.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067131','0068894.1','0061603.1',null,'0070215.1','0071957.1','0071958.1','0071702.1',null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067122','0068747.1','0071147.1','0069655.1','0071141.1',null,'0071145.1','0071143.1','0071148.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067076','0068677.1',null,'0074082.1','0071350.1','0071678.1','0071515.1','0072252.1','0072251.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067068',null,'0065632.1','0061492.1','0065631.1',null,'0065632.2',null,'0065631.2','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067130','0070760.1','0068542.1','0069465.1','0069124.1','0068744.1','0069480.1','0069113.1','0068746.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067086','0071979.1','0059505.1','0072671.1','0061409.1',null,null,'0062937.1','0071346.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067067',null,'0065291.1','0065431.1','0065207.1','0073716.1','0068071.1','0065282.1','0065539.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067138',null,'0073702.1',null,'0059089.1','0071672.1','0071289.1',null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067134','0070124.1','0070566.1','0070450.1',null,'0070087.1','0070125.1','0071537.1','0070346.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067139',null,null,null,null,null,null,null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067140',null,null,null,null,null,null,null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067135','0065476.1','0074096.1','0065472.1','0065473.1','0065474.1','0065475.1','0065477.1','0074061.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067133','0057972.1','0059936.1','0071354.1','0073697.1','0071294.1','0073699.1','0073698.1',null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067141',null,null,null,null,null,null,null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067132',null,'0058563.1','0058725.1','0055896.1','0058719.1','0073944.1','0070640.1',null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067137','0059996.1',null,null,null,null,null,'0061211.1','0061213.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067136',null,null,null,null,null,null,null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067110','0070773.1',null,'0073941.1','0073945.1','0073939.1',null,'0073940.1','0058564.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067113',null,'0071531.1','0065633.1','0066012.1','0067149.1','0065398.1',null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067111','0074103.1','0072699.1',null,'0068070.1',null,'0068072.1','0065167.1','0065167.2','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067117','0071352.1','0071340.1','0060214.1','0071233.1','0071232.1','0061762.1',null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067118','0069016.1','0068419.1','0068407.1','0069102.1','0073593.1','0069101.1','0069064.1','0065470.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067114','0071952.1','0065205.1','0065428.1','0065634.1','0065517.1','0065206.1','0065292.1','0065533.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067112','0071170.1','0069588.1','0065396.1','0065537.1','0065538.1','0065541.1','0065540.1','0065284.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067119','0060881.1','0074086.1','0074091.1','0074098.1','0058580.1','0060882.1','0071356.1',null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067116','0071144.1','0071146.1',null,null,'0072540.1',null,'0059961.1','0058694.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0058483',null,null,'0062940.1','0063610.1',null,'0059508.1','0072734.1',null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0053194','0039884.1','0029127.1','0039884.2','0029127.2','0039884.3','0029127.3','0039884.4','0029127.4','REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0060134','0068636.1','0068637.1','0059662.1','0066530.1','0068417.1','0068724.1','0058504.1','0064990.1','REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0053435',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0058484',null,'0060210.1','0065122.1','0069123.1','0065125.1','0068750.1','0068749.1','0065211.1','REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0055294',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0059992',null,null,'0064393.1','0064394.1','0067031.1','0067032.1',null,'0061664.1','REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0055295',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0055286',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0055221','0042165.1','0042165.2','0042222.1','0042222.2','0042165.3','0042165.4','0042222.3','0042222.4','REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0053415',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0059993','0058590.1','0058577.1',null,'0058591.1','0058573.1','0058592.1','0058574.1','0061665.1','REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0059990','0055971.1',null,'0070762.1',null,'0071718.1',null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0060001','0031527.1','0031528.1','0031527.2','0031528.2','0031527.3','0031528.3','0031527.4','0031528.4','REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0055222',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0055296',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0060133','0060887.1','0066523.1',null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0055893',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0055394',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0055395',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0058432',null,'0071963.1','0065547.1',null,null,'0073943.1','0058697.1',null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0058430','0059119.1','0059121.1','0058583.1','0058584.1','0058587.1','0071680.1','0071508.1','0071951.1','REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0053666','0068727.1',null,null,null,null,null,'0060049.1','0065301.1','REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0060029','0065909.1','0060000.1','0060872.1','0062244.1','0063830.1',null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0053665',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0058612','0072547.1',null,'0072548.1','0072548.2','0072547.2','0070075.1','0058506.1','0058722.1','REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0050859',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0060108','0064285.1','0068975.1','0068976.1',null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0058512','0072223.1','0061941.1','0071169.1','0072221.1',null,null,null,'0060290.1','REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0060035',null,null,null,'0059083.1','0059560.1','0064024.1','0060027.1','0060030.1','REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0058485',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0058420',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0058867',null,'0059118.1','0073946.1','0072249.1','0069121.1','0068639.1','0069122.1','0059123.1','REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0053667','0043258.1','0043257.1','0043258.2','0043257.2','0043258.3','0043257.3','0043258.4','0043257.4','REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0050862',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0050860',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0058421','0062942.1','0068719.1','0065296.1','0065294.1','0065906.1','0062041.1','0063557.1',null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0060055',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0058488','0058565.1','0058562.1',null,null,'0058723.1','0058724.1',null,'0058565.2','REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0055445',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0050861',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0058699','0065462.1','0065463.1','0065464.1','0065465.1','0065466.1','0065467.1','0065468.1','0065469.1','REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0053668',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0051935',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0051936',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0051937',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0051938',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0058453',null,'0064413.1',null,'0069396.1','0072672.1','0058593.1',null,'0072675.1','REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0060100','0068862.1','0068859.1','0068895.1','0068896.1','0063831.1',null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0043281','0043256.1','0050429.1','0043256.3','0050429.3','0043256.2','0050429.2','0043256.4','0050429.4','REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0060033',null,null,null,null,'0071398.1',null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0058482','0074093.1','0074099.1','0071406.1','0061415.1','0058764.1','0071343.1','0061410.1','0072674.1','REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0053425',null,null,'0062040.1','0062061.1',null,'0068720.1','0058936.1','0071704.1','REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0060028','0060287.1',null,null,'0058487.1','0058486.1','0055894.1','0055491.1','0061405.1','REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0053677',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0053678','0052483.1','0052483.3','0052482.1','0052482.3','0052483.2','0052483.4','0052482.2','0052482.4','REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0053412',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0053381',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0053416',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0068483','0070449.1','0059628.1',null,'0071173.1','0070612.1',null,'0070707.1','0070726.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0068485',null,'0070295.1','0069325.1',null,null,null,null,'0069559.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0068486','0069329.1','0069330.1','0069328.1','0071536.1','0071964.1','0072381.1','0055956.1',null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0068488','0072687.1',null,null,null,null,null,null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0068489','0074089.1',null,null,null,null,null,null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067147',null,null,null,null,null,null,null,null,'CW-16V2-L30M',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0068487','0073829.1','0073832.1',null,null,null,null,null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067125','0063272.1',null,null,'B0002821.1',null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067120',null,null,null,null,'0061630.1',null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067101',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067124',null,null,null,null,'0061629.1',null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067121','0059925.1','0059926.1',null,'0059930.1','0059929.1',null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067144','0055282.1','0059924.2','0055486.2','0061403.2','0055613.1',null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067106','0058841.1','0058842.1','0058844.1','0058843.1','0059916.1',null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067107','0061404.1','0061404.2','0055613.2','0067650.1','0061560.1',null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067108',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067047','0059766.2','0055282.2','0059768.2','0061561.2','0055388.2',null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067096',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067087',null,'0058866.1','0065639.1','0065637.1','0061642.1',null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067091',null,null,'0063269.1',null,'0062690.1',null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067081',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067092',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067123',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067127',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067084',null,'0063325.1','0063270.1',null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067079',null,'0063309.1','0063318.1',null,'0064002.1',null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067063',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067078',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067048','0070115.1','0070008.2',null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067102',null,null,null,null,'0068363.1',null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067128',null,null,'0065504.1','0065638.1',null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067074','0069109.1','0065347.1',null,'0070007.1',null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067103','0070074.1',null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067126','0073797.1','0073798.1','0073796.1','0073795.1',null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067070',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067064',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067082','0061400.2','0061400.1','0061401.1','0061401.2','0061560.2',null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067088',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067065',null,'C17SW_02','C17SW_03','C17SW_04','C17SW_05',null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067145','B0002014.1','B0002014.2',null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067073',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067069','B0003142.1','0058853.1',null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067143',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067052','0072545.1','0072545.2',null,null,'0072543.1',null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067142','0058858.1','0058858.2','0061636.1','0061636.2',null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067089',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067109',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067049',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067085',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067072',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067146',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067129',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067054',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067055','0058855.1',null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067057','0058845.1',null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067053','0061637.1','0061638.1','0072539.1','0072539.2',null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067062',null,null,'0059912.1',null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067061','0063265.1','0063265.2',null,'0061632.1',null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067056',null,'0063273.1',null,null,'0061629.1',null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067059','0059914.1','0059914.2',null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067058','0074180.1',null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067060','B0003710.2',null,null,'0063266.1',null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067095','0069107.1','0073729.1','0058581.1','0067026.1','0072531.1','0071679.1','0058763.1',null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0060047',null,null,null,null,null,null,null,null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0053366','0052479.1','0052479.3','0052480.1','0052480.3','0052479.2','0052479.4','0052480.2','0052480.4','REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071011',null,null,null,null,null,null,null,null,'NP-05B',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0067115','0059122.1','0065546.1','0068418.1','0071978.1','0059023.1','0071972.1','0071020.1','0074062.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0058431','0069110.1','0069334.1','0058578.1','0058582.1','0058585.1','0058586.1','0071507.1',null,'REMPC',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071695','0058571.1','0058570.1','0074084.1','0074085.1','0058568.1','0058569.1','0059665.1',null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071696','0056950.1','0057020.1',null,null,'0056957.1',null,null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071697','0056675.1','0058417.1','0043814.1','0043586.1','0056130.1','0060245.1','0060244.1','0056109.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071698','0070774.1','0055625.1','0070766.1','0055624.1','0055626.1','0056676.1','0061455.1','0061454.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0071699','0045235.1','0041277.1','0065471.1',null,'0072229.1',null,null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0072576','0072700.1','0072701.1','0072735.1','0072736.1','0073713.1','0073711.1','0071953.1',null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0072577',null,null,null,null,null,null,null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0073559',null,null,null,null,null,null,null,null,'RNR',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0073560',null,null,null,null,null,null,null,null,'RNR',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0073561',null,null,null,null,null,null,null,null,'RNR',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0073562',null,null,null,null,null,null,null,null,'RNR',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0073563',null,null,null,null,null,null,null,null,'RNR',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0073564',null,null,null,null,null,null,null,null,'RNR',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0073565',null,null,null,null,null,null,null,null,'RNR',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0073566',null,null,null,null,null,null,null,null,'RNR',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0073567',null,null,null,null,null,null,null,null,'RNR',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0073568',null,null,null,null,null,null,null,null,'RNR',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0073569',null,null,null,null,null,null,null,null,'RNR',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0073997',null,null,null,null,null,null,null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0073998','0074075.1','0074073.1','0074076.1','0074077.1','0074078.1','0074074.1',null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0073999',null,null,null,null,null,null,null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0074000',null,null,null,null,null,null,null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0074001',null,null,null,null,null,null,null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0074002',null,null,null,null,null,null,null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0074003',null,'0074072.1',null,null,null,null,'0074067.1','0074068.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0070090','0070565.1','00614202.1','0071681.1','0061412.1','0061417.1','0061418.1','0061414.1','0062941.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0070088','0068442.1','0058711.1','0058710.1','0072227.1','0065128.1','0062943.1','0071101.1','0070613.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0070091',null,null,null,null,null,null,null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0070092',null,null,null,null,null,null,null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0070093','0059766.1','0059768.1','0059923.1','0055486.1','0059767.1','0061403.1',null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0070094','0071961.1','0070452.1','0071598.1','0071705.1','0072122.1','0071851.1',null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0070095','0071393.1',null,null,null,null,null,null,null,'DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0070096','0064479.1','0064478.1','0064477.1','0064395.1','0064386.1','0064388.1','0069336.1','0064385.1','DST-8-RB',null);
Insert into PIMS_NEW.PIMS_RPC_DETAILS (RPC_STOCK_NUMBER,CONNECTION1,CONNECTION2,CONNECTION3,CONNECTION4,CONNECTION5,CONNECTION6,CONNECTION7,CONNECTION8,UNIT_PART_NUMBER,FULL_STRING) values ('0070097','0073590.1','0071513.1','0071599.1','0058572.1','0071361.1','0071362.1','0071600.1','0073592.1','DST-8-RB',null);
--------------------------------------------------------
--  DDL for Index PIMS_RPC_DETAILS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "PIMS_NEW"."PIMS_RPC_DETAILS_PK" ON "PIMS_NEW"."PIMS_RPC_DETAILS" ("RPC_STOCK_NUMBER") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "PIMS_NEW_D" ;
--------------------------------------------------------
--  DDL for Trigger TRG_RPC_MAGIC
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "PIMS_NEW"."TRG_RPC_MAGIC" 
AFTER UPDATE
OF CONNECTION1
  ,CONNECTION2
  ,CONNECTION3
  ,CONNECTION4
  ,CONNECTION5
  ,CONNECTION6
  ,CONNECTION7
  ,CONNECTION8
ON PIMS_RPC_DETAILS
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
declare
   ls_port  varchar(20);
   ls_term varchar(20);
   ls_ip   varchar(20);
   ls_power1 varchar(250);
   ls_power2 varchar(250);
   ls_str1  varchar(250);
   ls_str2  varchar(250);
   
   
Begin
If :new.unit_part_number = 'REMPC' Then

select term_server, port_number, ip_addr_f into ls_term, ls_port, ls_ip
from   pims_component
where stock_number = :new.rpc_stock_number;

Begin -- Connection 1
-- select power into ls_power from pims_component where stock_number = substr(:new.connection1,1,7); -- get power string for the first connection stock number

If :new.connection1 is not null and :old.connection1 is not null and :old.connection1 <> :new.connection1  then 

    select power into  ls_power1 from pims_component where stock_number = substr(:old.connection1,1,7); -- get power string for the old connection stock number
    select power into  ls_power2 from pims_component where stock_number = substr(:new.connection1,1,7); -- get power string for the new connection stock number
    
    If instr(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0  Then
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection1, ls_str1,sysdate);
    If Is_Pims(substr(:old.connection1,1,7)) then
    
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection1,1,7);
       
    End If; 
       
    End If;
    
    If instr(ls_power2, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0  or ls_power2 is null Then
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection1, ls_str2,sysdate);
     
    If Is_Pims(substr(:new.connection1,1,7)) then
      update pims_component
       set  power = ls_str2
       where stock_number = substr(:new.connection1,1,7);
    End If;
     else
     
     If Is_Pims(substr(:new.connection1,1,7)) then
     
      update pims_component
       set  power = ls_power2
       where stock_number = substr(:new.connection1,1,7);
     End If;
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection1, ls_power2,sysdate);
       
   
     end If;
End if; -- new and old connections are not null

If :new.connection1 is not null and :old.connection1 is null  then -- New connection
Begin
If is_pims( substr(:new.connection1,1,7)) Then
    select power into ls_power2 from pims_component where stock_number = substr(:new.connection1,1,7);
End If;  
    If instr(ls_power2, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0 Then
    
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection1, ls_str2,sysdate);
     If Is_Pims(substr(:new.connection1,1,7)) then
       update pims_component
        set  power = ls_str2
        where stock_number = substr(:new.connection1,1,7);
     End If;
    Else
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection1, ls_power2,sysdate);
    
     If Is_Pims(substr(:new.connection1,1,7)) then
      update pims_component
        set  power = ls_power2
        where stock_number = substr(:new.connection1,1,7);
     End If;
    end If;
    
Exception

WHen others then null;

End;  

End If; -- new connection added


If :new.connection1 is null and :old.connection1 is not null  then 
    
    select power into  ls_power1 from pims_component where stock_number = substr(:old.connection1,1,7);
    
    If instr(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0 Then
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection1, ls_str1,sysdate);
      
     If Is_Pims(substr(:old.connection1,1,7)) then
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection1,1,7);
     End If;
     Else 
      insert into rpc_full_string(stock, fullstring,updated) values (:old.connection1, ls_power1,sysdate);
      
      If Is_Pims(substr(:old.connection1,1,7)) then
       update pims_component
       set  power = ls_power1
       where stock_number = substr(:old.connection1,1,7);
     End If;
      -- commit;
       
    End If;

End If; --  connection removed
End; -- Connection 1
Begin -- Connection 2
-- select power into ls_power from pims_component where stock_number = substr(:new.connection2,1,7); -- get power string for the first connection stock number

If :new.connection2 is not null and :old.connection2 is not null and :old.connection2 <> :new.connection2  then 

    select power into  ls_power1 from pims_component where stock_number = substr(:old.connection2,1,7); -- get power string for the old connection stock number
    select power into  ls_power2 from pims_component where stock_number = substr(:new.connection2,1,7); -- get power string for the new connection stock number
    
    If instr(ls_power1, :new.rpc_stock_number||','||'2,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0  Then
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'2,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection2, ls_str1,sysdate);
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection2,1,7);
      
       
    End If;
    
    If instr(ls_power2, :new.rpc_stock_number||','||'2,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0  or ls_power2 is null Then
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'2,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection2, ls_str2,sysdate);
       update pims_component
       set  power = ls_str2
       where stock_number = substr(:new.connection2,1,7);
     else
      update pims_component
       set  power = ls_power2
       where stock_number = substr(:new.connection2,1,7);
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection2, ls_power2,sysdate);
       
   
     end If;
End if; -- new and old connections are not null

If :new.connection2 is not null and :old.connection2 is null  then --New Connection
    
    select power into ls_power2 from pims_component where stock_number = substr(:new.connection2,1,7);
    
    If instr(ls_power2, :new.rpc_stock_number||','||'2,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0 Then
    
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'2,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection2, ls_str2,sysdate);
       update pims_component
        set  power = ls_str2
        where stock_number = substr(:new.connection2,1,7);
    Else
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection2, ls_power2,sysdate);
      update pims_component
        set  power = ls_power2
        where stock_number = substr(:new.connection2,1,7);
    end If;
   

End If; -- new connection added


If :new.connection2 is null and :old.connection2 is not null  then 
    
    select power into  ls_power1 from pims_component where stock_number = substr(:old.connection2,1,7);
    
    If instr(ls_power1, :new.rpc_stock_number||','||'2,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0 Then
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'2,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection2, ls_str1,sysdate);
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection2,1,7);
     Else 
      insert into rpc_full_string(stock, fullstring,updated) values (:old.connection2, ls_power1,sysdate);
       update pims_component
       set  power = ls_power1
       where stock_number = substr(:old.connection2,1,7);
      -- commit;
       
    End If;

End If; --  connection removed

End; -- connection 2


Begin -- Connection 3
-- select power into ls_power from pims_component where stock_number = substr(:new.connection2,1,7); -- get power string for the first connection stock number

If :new.connection3 is not null and :old.connection3 is not null and :old.connection3 <> :new.connection3  then 

    select power into  ls_power1 from pims_component where stock_number = substr(:old.connection3,1,7); -- get power string for the old connection stock number
    select power into  ls_power2 from pims_component where stock_number = substr(:new.connection3,1,7); -- get power string for the new connection stock number
    
    If instr(ls_power1, :new.rpc_stock_number||','||'3,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0  Then
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'3,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection3, ls_str1,sysdate);
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection3,1,7);
      
       
    End If;
    
    If instr(ls_power2, :new.rpc_stock_number||','||'3,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0  or ls_power2 is null Then
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'3,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection3, ls_str2,sysdate);
       update pims_component
       set  power = ls_str2
       where stock_number = substr(:new.connection3,1,7);
     else
      update pims_component
       set  power = ls_power2
       where stock_number = substr(:new.connection3,1,7);
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection3, ls_power2,sysdate);
       
   
     end If;
End if; -- new and old connections are not null

If :new.connection3 is not null and :old.connection3 is null  then 
    
    select power into ls_power2 from pims_component where stock_number = substr(:new.connection3,1,7);
    
    If instr(ls_power2, :new.rpc_stock_number||','||'3,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0 Then
    
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'3,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection3, ls_str2,sysdate);
       update pims_component
        set  power = ls_str2
        where stock_number = substr(:new.connection3,1,7);
    Else
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection3, ls_power2,sysdate);
      update pims_component
        set  power = ls_power2
        where stock_number = substr(:new.connection3,1,7);
    end If;
   

End If; -- new connection added


If :new.connection3 is null and :old.connection3 is not null  then 
    
    select power into  ls_power1 from pims_component where stock_number = substr(:old.connection3,1,7);
    
    If instr(ls_power1, :new.rpc_stock_number||','||'3,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0 Then
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'3,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection3, ls_str1,sysdate);
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection3,1,7);
     Else 
      insert into rpc_full_string(stock, fullstring,updated) values (:old.connection3, ls_power1,sysdate);
       update pims_component
       set  power = ls_power1
       where stock_number = substr(:old.connection3,1,7);
      -- commit;
       
    End If;

End If; --  connection removed

End; -- connection 3


Begin -- Connection 4

If :new.connection4 is not null and :old.connection4 is not null and :old.connection4 <> :new.connection4  then 

    select power into  ls_power1 from pims_component where stock_number = substr(:old.connection4,1,7); -- get power string for the old connection stock number
    select power into  ls_power2 from pims_component where stock_number = substr(:new.connection4,1,7); -- get power string for the new connection stock number
    
    If instr(ls_power1, :new.rpc_stock_number||','||'4,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0  Then
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'4,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection4, ls_str1,sysdate);
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection4,1,7);
      
       
    End If;
    
    If instr(ls_power2, :new.rpc_stock_number||','||'4,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0  or ls_power2 is null Then
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'4,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection4, ls_str2,sysdate);
       update pims_component
       set  power = ls_str2
       where stock_number = substr(:new.connection4,1,7);
     else
      update pims_component
       set  power = ls_power2
       where stock_number = substr(:new.connection4,1,7);
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection4, ls_power2,sysdate);
       
   
     end If;
End if; -- new and old connections are not null

If :new.connection4 is not null and :old.connection4 is null  then 
    
    select power into ls_power2 from pims_component where stock_number = substr(:new.connection4,1,7);
    
    If instr(ls_power2, :new.rpc_stock_number||','||'4,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0 Then
    
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'4,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection4, ls_str2,sysdate);
       update pims_component
        set  power = ls_str2
        where stock_number = substr(:new.connection4,1,7);
    Else
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection4, ls_power2,sysdate);
      update pims_component
        set  power = ls_power2
        where stock_number = substr(:new.connection4,1,7);
    end If;
   

End If; -- new connection added


If :new.connection4 is null and :old.connection4 is not null  then 
    
    select power into  ls_power1 from pims_component where stock_number = substr(:old.connection4,1,7);
    
    If instr(ls_power1, :new.rpc_stock_number||','||'4,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0 Then
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'4,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection4, ls_str1,sysdate);
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection4,1,7);
     Else 
      insert into rpc_full_string(stock, fullstring,updated) values (:old.connection4, ls_power1,sysdate);
       update pims_component
       set  power = ls_power1
       where stock_number = substr(:old.connection4,1,7);
      -- commit;
       
    End If;

End If; --  connection removed
Exception
when others then dbms_output.put_line('There is aproblem here');
End; -- connection 4


Begin -- Connection 5

If :new.connection5 is not null and :old.connection5 is not null and :old.connection5 <> :new.connection5  then 

    select power into  ls_power1 from pims_component where stock_number = substr(:old.connection5,1,7); -- get power string for the old connection stock number
    select power into  ls_power2 from pims_component where stock_number = substr(:new.connection5,1,7); -- get power string for the new connection stock number
    
    If instr(ls_power1, :new.rpc_stock_number||','||'5,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0  Then
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'5,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection5, ls_str1,sysdate);
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection5,1,7);
      
       
    End If;
    
    If instr(ls_power2, :new.rpc_stock_number||','||'5,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0  or ls_power2 is null Then
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'5,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection5, ls_str2,sysdate);
       update pims_component
       set  power = ls_str2
       where stock_number = substr(:new.connection5,1,7);
     else
      update pims_component
       set  power = ls_power2
       where stock_number = substr(:new.connection5,1,7);
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection5, ls_power2,sysdate);
       
   
     end If;
End if; -- new and old connections are not null

If :new.connection5 is not null and :old.connection5 is null  then 
    
    select power into ls_power2 from pims_component where stock_number = substr(:new.connection5,1,7);
    
    If instr(ls_power2, :new.rpc_stock_number||','||'5,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0 Then
    
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'5,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection5, ls_str2,sysdate);
       update pims_component
        set  power = ls_str2
        where stock_number = substr(:new.connection5,1,7);
    Else
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection5, ls_power2,sysdate);
      update pims_component
        set  power = ls_power2
        where stock_number = substr(:new.connection5,1,7);
    end If;
   

End If; -- new connection added


If :new.connection5 is null and :old.connection5 is not null  then 
    
    select power into  ls_power1 from pims_component where stock_number = substr(:old.connection5,1,7);
    
    If instr(ls_power1, :new.rpc_stock_number||','||'5,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0 Then
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'5,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection5, ls_str1,sysdate);
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection5,1,7);
     Else 
      insert into rpc_full_string(stock, fullstring,updated) values (:old.connection5, ls_power1,sysdate);
       update pims_component
       set  power = ls_power1
       where stock_number = substr(:old.connection5,1,7);
      -- commit;
       
    End If;

End If; --  connection removed

End; -- connection 5



Begin -- Connection 6

If :new.connection6 is not null and :old.connection6 is not null and :old.connection6 <> :new.connection6  then 

    select power into  ls_power1 from pims_component where stock_number = substr(:old.connection6,1,7); -- get power string for the old connection stock number
    select power into  ls_power2 from pims_component where stock_number = substr(:new.connection6,1,7); -- get power string for the new connection stock number
    
    If instr(ls_power1, :new.rpc_stock_number||','||'6,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0  Then
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'6,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection6, ls_str1,sysdate);
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection6,1,7);
      
       
    End If;
    
    If instr(ls_power2, :new.rpc_stock_number||','||'6,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0  or ls_power2 is null Then
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'6,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection6, ls_str2,sysdate);
       update pims_component
       set  power = ls_str2
       where stock_number = substr(:new.connection6,1,7);
     else
      update pims_component
       set  power = ls_power2
       where stock_number = substr(:new.connection6,1,7);
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection6, ls_power2,sysdate);
       
   
     end If;
End if; -- new and old connections are not null

If :new.connection6 is not null and :old.connection6 is null  then 
    
    select power into ls_power2 from pims_component where stock_number = substr(:new.connection6,1,7);
    
    If instr(ls_power2, :new.rpc_stock_number||','||'6,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0 Then
    
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'6,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection6, ls_str2,sysdate);
       update pims_component
        set  power = ls_str2
        where stock_number = substr(:new.connection6,1,7);
    Else
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection6, ls_power2,sysdate);
      update pims_component
        set  power = ls_power2
        where stock_number = substr(:new.connection6,1,7);
    end If;
   

End If; -- new connection added


If :new.connection6 is null and :old.connection6 is not null  then 
    
    select power into  ls_power1 from pims_component where stock_number = substr(:old.connection6,1,7);
    
    If instr(ls_power1, :new.rpc_stock_number||','||'6,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0 Then
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'6,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection6, ls_str1,sysdate);
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection6,1,7);
     Else 
      insert into rpc_full_string(stock, fullstring,updated) values (:old.connection6, ls_power1,sysdate);
       update pims_component
       set  power = ls_power1
       where stock_number = substr(:old.connection6,1,7);
      -- commit;
       
    End If;

End If; --  connection removed

End; -- connection 6


Begin -- Connection 7

If :new.connection7 is not null and :old.connection7 is not null and :old.connection7 <> :new.connection7  then 

    select power into  ls_power1 from pims_component where stock_number = substr(:old.connection7,1,7); -- get power string for the old connection stock number
    select power into  ls_power2 from pims_component where stock_number = substr(:new.connection7,1,7); -- get power string for the new connection stock number
    
    If instr(ls_power1, :new.rpc_stock_number||','||'7,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0  Then
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'7,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection7, ls_str1,sysdate);
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection7,1,7);
      
       
    End If;
    
    If instr(ls_power2, :new.rpc_stock_number||','||'7,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0  or ls_power2 is null Then
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'7,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection7, ls_str2,sysdate);
       update pims_component
       set  power = ls_str2
       where stock_number = substr(:new.connection7,1,7);
     else
      update pims_component
       set  power = ls_power2
       where stock_number = substr(:new.connection7,1,7);
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection7, ls_power2,sysdate);
       
   
     end If;
End if; -- new and old connections are not null

If :new.connection7 is not null and :old.connection7 is null  then 
    
    select power into ls_power2 from pims_component where stock_number = substr(:new.connection7,1,7);
    
    If instr(ls_power2, :new.rpc_stock_number||','||'7,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0 Then
    
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'7,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection7, ls_str2,sysdate);
       update pims_component
        set  power = ls_str2
        where stock_number = substr(:new.connection7,1,7);
    Else
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection7, ls_power2,sysdate);
      update pims_component
        set  power = ls_power2
        where stock_number = substr(:new.connection7,1,7);
    end If;
   

End If; -- new connection added


If :new.connection7 is null and :old.connection7 is not null  then 
    
    select power into  ls_power1 from pims_component where stock_number = substr(:old.connection7,1,7);
    
    If instr(ls_power1, :new.rpc_stock_number||','||'7,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0 Then
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'7,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection7, ls_str1,sysdate);
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection7,1,7);
     Else 
      insert into rpc_full_string(stock, fullstring,updated) values (:old.connection7, ls_power1,sysdate);
       update pims_component
       set  power = ls_power1
       where stock_number = substr(:old.connection7,1,7);
      -- commit;
       
    End If;

End If; --  connection removed

End; -- connection 7


Begin -- Connection 8
If :new.connection8 is not null and :old.connection8 is not null and :old.connection8 <> :new.connection8  then 

    select power into  ls_power1 from pims_component where stock_number = substr(:old.connection8,1,7); -- get power string for the old connection stock number
    select power into  ls_power2 from pims_component where stock_number = substr(:new.connection8,1,7); -- get power string for the new connection stock number
    
    If instr(ls_power1, :new.rpc_stock_number||','||'8,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0  Then
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'8,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection8, ls_str1,sysdate);
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection8,1,7);
      
       
    End If;
    
    If instr(ls_power2, :new.rpc_stock_number||','||'8,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0  or ls_power2 is null Then
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'8,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection8, ls_str2,sysdate);
       update pims_component
       set  power = ls_str2
       where stock_number = substr(:new.connection8,1,7);
     else
      update pims_component
       set  power = ls_power2
       where stock_number = substr(:new.connection8,1,7);
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection8, ls_power2,sysdate);
       
   
     end If;
End if; -- new and old connections are not null

If :new.connection8 is not null and :old.connection8 is null  then 
    
    select power into ls_power2 from pims_component where stock_number = substr(:new.connection8,1,7);
    
    If instr(ls_power2, :new.rpc_stock_number||','||'8,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0 Then
    
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'8,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection8, ls_str2,sysdate);
       update pims_component
        set  power = ls_str2
        where stock_number = substr(:new.connection8,1,7);
    Else
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection8, ls_power2,sysdate);
      update pims_component
        set  power = ls_power2
        where stock_number = substr(:new.connection8,1,7);
    end If;
   

End If; -- new connection added


If :new.connection8 is null and :old.connection8 is not null  then 
    
    select power into  ls_power1 from pims_component where stock_number = substr(:old.connection8,1,7);
    
    If instr(ls_power1, :new.rpc_stock_number||','||'8,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0 Then
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'8,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection8, ls_str1,sysdate);
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection8,1,7);
     Else 
      insert into rpc_full_string(stock, fullstring,updated) values (:old.connection8, ls_power1,sysdate);
       update pims_component
       set  power = ls_power1
       where stock_number = substr(:old.connection8,1,7);
      -- commit;
       
    End If;

End If; --  connection removed

End; -- connection 8



Else -- If not REMPC


select ip_addr_f, port_number  into ls_term, ls_port
from   pims_component
where stock_number = :new.rpc_stock_number;

Begin -- Connection 1
-- select power into ls_power from pims_component where stock_number = substr(:new.connection1,1,7); -- get power string for the first connection stock number

If :new.connection1 is not null and :old.connection1 is not null and :old.connection1 <> :new.connection1  then 

If is_pims(substr(:old.connection1,1,7)) and is_pims(substr(:new.connection1,1,7)) Then
    select power into  ls_power1 from pims_component where stock_number = substr(:old.connection1,1,7); -- get power string for the old connection stock number
    select power into  ls_power2 from pims_component where stock_number = substr(:new.connection1,1,7); -- get power string for the new connection stock number
Elsif is_flams(substr(:new.connection1,0,length(:new.connection1)-2)) and is_flams(substr(:old.connection1,0,length(:old.connection1)-2)) Then
    select power into  ls_power1 from flams.lab_equipment where stock_number = substr(:old.connection1,0,length(:old.connection1)-2); -- get power string for the old connection stock number
    select power into  ls_power2 from flams.lab_equipment where stock_number = substr(:new.connection1,0,length(:new.connection1)-2); -- get power string for the new connection stock number
End If;   

    If instr(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0  Then
    
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection1, ls_str1,sysdate);
      If is_pims(substr(:old.connection1,1,7)) Then
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection1,1,7);
      Elsif is_flams(substr(:old.connection1,0,length(:old.connection1)-2)) then
           update flams.lab_equipment
           set power = ls_str1
           where stock_number = substr(:old.connection1,0,length(:old.connection1)-2);
      End If;       
    End If;
    
    If instr(ls_power2, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0  or ls_power2 is null Then
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection1, ls_str2,sysdate);
       If is_pims(substr(:new.connection1,1,7)) Then
         update pims_component
         set  power = ls_str2
         where stock_number = substr(:new.connection1,1,7);
        Elsif is_flams(substr(:new.connection1,0,length(:new.connection1)-2)) then
           update flams.lab_equipment
           set power = ls_str2
           where stock_number = substr(:new.connection1,0,length(:new.connection1)-2);
      End If;  
           
     else
     If is_pims(substr(:new.connection1,1,7)) Then
      update pims_component
       set  power = ls_power2
       where stock_number = substr(:new.connection1,1,7);
      Elsif  is_flams(substr(:new.connection1,0,length(:new.connection1)-2)) then
           update flams.lab_equipment
           set power = ls_power2
           where stock_number = substr(:new.connection1,0,length(:new.connection1)-2);
      End If;  
       
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection1, ls_power2,sysdate);
       
   
     end If;
End if; -- new and old connections are not null

If :new.connection1 is not null and :old.connection1 is null  then  -- new connection
    
If is_pims(substr(:new.connection1,1,7)) Then
    select power into ls_power2 from pims_component where stock_number = substr(:new.connection1,1,7);
elsif is_flams(substr(:new.connection1,0,length(:new.connection1)-2)) then
     select power into ls_power2 from flams.lab_equipment where stock_number = substr(:new.connection1,0,length(:new.connection1)-2);
End If;


    
    If instr(ls_power2, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0 Then
    
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection1, ls_str2,sysdate);
       
     If is_pims(substr(:new.connection1,1,7)) Then
       update pims_component
        set  power = ls_str2
        where stock_number = substr(:new.connection1,1,7);
      End If;
      if is_flams(substr(:new.connection1,0,length(:new.connection1)-2)) then
        update flams.lab_equipment
        set power = ls_str2
        where stock_number = substr(:new.connection1,0,length(:new.connection1)-2);
      end if;
    Else
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection1, ls_power2,sysdate);
      
      
     If is_pims(substr(:new.connection1,1,7)) Then
      update pims_component
        set  power = ls_power2
        where stock_number = substr(:new.connection1,1,7);
     End If;
      
       If is_flams(substr(:new.connection1,0,length(:new.connection1)-2)) then
        update flams.lab_equipment
        set power = ls_str2
        where stock_number = substr(:new.connection1,0,length(:new.connection1)-2);
      end if;
      
   End If; 
   

End If; -- new connection added


If :new.connection1 is null and :old.connection1 is not null  then 
    If is_pims(substr(:old.connection1,1,7)) then
        select power into  ls_power1 from pims_component where stock_number = substr(:old.connection1,1,7);
    elsif is_flams(substr(:old.connection1,0,length(:old.connection1)-2)) then
        select power into  ls_power1 from flams.lab_equipment where stock_number = substr(:old.connection1,0,length(:old.connection1)-2);
    end if;
    
    If instr(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0 Then
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection1, ls_str1,sysdate);
     If is_pims(substr(:old.connection1,1,7)) then
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection1,1,7);
      Elsif is_flams(substr(:old.connection1,0,length(:old.connection1)-2)) then
        update flams.lab_equipment
       set  power = ls_str1
       where stock_number = substr(:old.connection1,0,length(:old.connection1)-2);
      End If;
     Else 
      insert into rpc_full_string(stock, fullstring,updated) values (:old.connection1, ls_power1,sysdate);
     
     If is_pims(substr(:old.connection1,1,7)) then
       update pims_component
       set  power = ls_power1
       where stock_number = substr(:old.connection1,1,7);
    Elsif is_flams(substr(:old.connection1,0,length(:old.connection1)-2)) then
    
     update flams.lab_equipment
       set  power = ls_power1
       where stock_number = substr(:old.connection1,0,length(:old.connection1)-2);
    End If;
      -- commit;
       
    End If;

End If; --  connection removed


End; -- Connection 1


Begin -- Connection 2
If :new.connection2 is not null and :old.connection2 is not null and :old.connection2 <> :new.connection2  then 

If is_pims(substr(:old.connection2,1,7)) and is_pims(substr(:new.connection2,1,7)) Then
    select power into  ls_power1 from pims_component where stock_number = substr(:old.connection2,1,7); -- get power string for the old connection stock number
    select power into  ls_power2 from pims_component where stock_number = substr(:new.connection2,1,7); -- get power string for the new connection stock number
Elsif is_flams(substr(:new.connection2,0,length(:new.connection2)-2)) and is_flams(substr(:old.connection2,0,length(:old.connection2)-2)) Then
    select power into  ls_power1 from flams.lab_equipment where stock_number = substr(:old.connection2,0,length(:old.connection2)-2); -- get power string for the old connection stock number
    select power into  ls_power2 from flams.lab_equipment where stock_number = substr(:new.connection2,0,length(:new.connection2)-2); -- get power string for the new connection stock number
End If;   

    If instr(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0  Then
    
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection2, ls_str1,sysdate);
      If is_pims(substr(:old.connection2,1,7)) Then
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection2,1,7);
      Elsif is_flams(substr(:old.connection2,0,length(:old.connection2)-2)) then
           update flams.lab_equipment
           set power = ls_str1
           where stock_number = substr(:old.connection2,0,length(:old.connection2)-2);
      End If;       
    End If;
    
    If instr(ls_power2, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0  or ls_power2 is null Then
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection2, ls_str2,sysdate);
       If is_pims(substr(:new.connection2,1,7)) Then
         update pims_component
         set  power = ls_str2
         where stock_number = substr(:new.connection2,1,7);
        Elsif is_flams(substr(:new.connection2,0,length(:new.connection2)-2)) then
           update flams.lab_equipment
           set power = ls_str2
           where stock_number = substr(:new.connection2,0,length(:new.connection2)-2);
      End If;  
           
     else
     If is_pims(substr(:new.connection2,1,7)) Then
      update pims_component
       set  power = ls_power2
       where stock_number = substr(:new.connection2,1,7);
      Elsif  is_flams(substr(:new.connection2,0,length(:new.connection2)-2)) then
           update flams.lab_equipment
           set power = ls_power2
           where stock_number = substr(:new.connection2,0,length(:new.connection2)-2);
      End If;  
       
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection2, ls_power2,sysdate);
       
   
     end If;
End if; -- new and old connections are not null

If :new.connection2 is not null and :old.connection2 is null  then  -- new connection
    
If is_pims(substr(:new.connection2,1,7)) Then
    select power into ls_power2 from pims_component where stock_number = substr(:new.connection2,1,7);
elsif is_flams(substr(:new.connection2,0,length(:new.connection2)-2)) then
     select power into ls_power2 from flams.lab_equipment where stock_number = substr(:new.connection2,0,length(:new.connection2)-2);
End If;


    
    If instr(ls_power2, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0 Then
    
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection2, ls_str2,sysdate);
       
     If is_pims(substr(:new.connection2,1,7)) Then
       update pims_component
        set  power = ls_str2
        where stock_number = substr(:new.connection2,1,7);
      End If;
      if is_flams(substr(:new.connection2,0,length(:new.connection2)-2)) then
        update flams.lab_equipment
        set power = ls_str2
        where stock_number = substr(:new.connection2,0,length(:new.connection2)-2);
      end if;
    Else
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection2, ls_power2,sysdate);
      
      
     If is_pims(substr(:new.connection2,1,7)) Then
      update pims_component
        set  power = ls_power2
        where stock_number = substr(:new.connection2,1,7);
     End If;
      
       If is_flams(substr(:new.connection2,0,length(:new.connection2)-2)) then
        update flams.lab_equipment
        set power = ls_str2
        where stock_number = substr(:new.connection2,0,length(:new.connection2)-2);
      end if;
      
   End If; 
   

End If; -- new connection added


If :new.connection2 is null and :old.connection2 is not null  then 
    If is_pims(substr(:old.connection2,1,7)) then
        select power into  ls_power1 from pims_component where stock_number = substr(:old.connection2,1,7);
    elsif is_flams(substr(:old.connection2,0,length(:old.connection2)-2)) then
        select power into  ls_power1 from flams.lab_equipment where stock_number = substr(:old.connection2,0,length(:old.connection2)-2);
    end if;
    
    If instr(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0 Then
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection2, ls_str1,sysdate);
     If is_pims(substr(:old.connection2,1,7)) then
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection2,1,7);
      Elsif is_flams(substr(:old.connection2,0,length(:old.connection2)-2)) then
        update flams.lab_equipment
       set  power = ls_str1
       where stock_number = substr(:old.connection2,0,length(:old.connection2)-2);
      End If;
     Else 
      insert into rpc_full_string(stock, fullstring,updated) values (:old.connection2, ls_power1,sysdate);
     
     If is_pims(substr(:old.connection2,1,7)) then
       update pims_component
       set  power = ls_power1
       where stock_number = substr(:old.connection2,1,7);
    Elsif is_flams(substr(:old.connection2,0,length(:old.connection2)-2)) then
    
     update flams.lab_equipment
       set  power = ls_power1
       where stock_number = substr(:old.connection2,0,length(:old.connection2)-2);
    End If;
      -- commit;
       
    End If;

End If; --  connection removed

End; -- connection 2


Begin -- Connection 3
-- select power into ls_power from pims_component where stock_number = substr(:new.connection2,1,7); -- get power string for the first connection stock number

If :new.connection3 is not null and :old.connection3 is not null and :old.connection3 <> :new.connection3  then 

If is_pims(substr(:old.connection3,1,7)) and is_pims(substr(:new.connection3,1,7)) Then
    select power into  ls_power1 from pims_component where stock_number = substr(:old.connection3,1,7); -- get power string for the old connection stock number
    select power into  ls_power2 from pims_component where stock_number = substr(:new.connection3,1,7); -- get power string for the new connection stock number
Elsif is_flams(substr(:new.connection3,0,length(:new.connection3)-2)) and is_flams(substr(:old.connection3,0,length(:old.connection3)-2)) Then
    select power into  ls_power1 from flams.lab_equipment where stock_number = substr(:old.connection3,0,length(:old.connection3)-2); -- get power string for the old connection stock number
    select power into  ls_power2 from flams.lab_equipment where stock_number = substr(:new.connection3,0,length(:new.connection3)-2); -- get power string for the new connection stock number
End If;   

    If instr(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0  Then
    
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection3, ls_str1,sysdate);
      If is_pims(substr(:old.connection3,1,7)) Then
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection3,1,7);
      Elsif is_flams(substr(:old.connection3,0,length(:old.connection3)-2)) then
           update flams.lab_equipment
           set power = ls_str1
           where stock_number = substr(:old.connection3,0,length(:old.connection3)-2);
      End If;       
    End If;
    
    If instr(ls_power2, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0  or ls_power2 is null Then
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection3, ls_str2,sysdate);
       If is_pims(substr(:new.connection3,1,7)) Then
         update pims_component
         set  power = ls_str2
         where stock_number = substr(:new.connection3,1,7);
        Elsif is_flams(substr(:new.connection3,0,length(:new.connection3)-2)) then
           update flams.lab_equipment
           set power = ls_str2
           where stock_number = substr(:new.connection3,0,length(:new.connection3)-2);
      End If;  
           
     else
     If is_pims(substr(:new.connection3,1,7)) Then
      update pims_component
       set  power = ls_power2
       where stock_number = substr(:new.connection3,1,7);
      Elsif  is_flams(substr(:new.connection3,0,length(:new.connection3)-2)) then
           update flams.lab_equipment
           set power = ls_power2
           where stock_number = substr(:new.connection3,0,length(:new.connection3)-2);
      End If;  
       
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection3, ls_power2,sysdate);
       
   
     end If;
End if; -- new and old connections are not null

If :new.connection3 is not null and :old.connection3 is null  then  -- new connection
    
If is_pims(substr(:new.connection3,1,7)) Then
    select power into ls_power2 from pims_component where stock_number = substr(:new.connection3,1,7);
elsif is_flams(substr(:new.connection3,0,length(:new.connection3)-2)) then
     select power into ls_power2 from flams.lab_equipment where stock_number = substr(:new.connection3,0,length(:new.connection3)-2);
End If;


    
    If instr(ls_power2, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0 Then
    
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection3, ls_str2,sysdate);
       
     If is_pims(substr(:new.connection3,1,7)) Then
       update pims_component
        set  power = ls_str2
        where stock_number = substr(:new.connection3,1,7);
      End If;
      if is_flams(substr(:new.connection3,0,length(:new.connection3)-2)) then
        update flams.lab_equipment
        set power = ls_str2
        where stock_number = substr(:new.connection3,0,length(:new.connection3)-2);
      end if;
    Else
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection3, ls_power2,sysdate);
      
      
     If is_pims(substr(:new.connection3,1,7)) Then
      update pims_component
        set  power = ls_power2
        where stock_number = substr(:new.connection3,1,7);
     End If;
      
       If is_flams(substr(:new.connection3,0,length(:new.connection3)-2)) then
        update flams.lab_equipment
        set power = ls_str2
        where stock_number = substr(:new.connection3,0,length(:new.connection3)-2);
      end if;
      
   End If; 
   

End If; -- new connection added


If :new.connection3 is null and :old.connection3 is not null  then 
    If is_pims(substr(:old.connection3,1,7)) then
        select power into  ls_power1 from pims_component where stock_number = substr(:old.connection3,1,7);
    elsif is_flams(substr(:old.connection3,0,length(:old.connection3)-2)) then
        select power into  ls_power1 from flams.lab_equipment where stock_number = substr(:old.connection3,0,length(:old.connection3)-2);
    end if;
    
    If instr(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0 Then
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection3, ls_str1,sysdate);
     If is_pims(substr(:old.connection3,1,7)) then
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection3,1,7);
      Elsif is_flams(substr(:old.connection3,0,length(:old.connection3)-2)) then
        update flams.lab_equipment
       set  power = ls_str1
       where stock_number = substr(:old.connection3,0,length(:old.connection3)-2);
      End If;
     Else 
      insert into rpc_full_string(stock, fullstring,updated) values (:old.connection3, ls_power1,sysdate);
     
     If is_pims(substr(:old.connection3,1,7)) then
       update pims_component
       set  power = ls_power1
       where stock_number = substr(:old.connection3,1,7);
    Elsif is_flams(substr(:old.connection3,0,length(:old.connection3)-2)) then
    
     update flams.lab_equipment
       set  power = ls_power1
       where stock_number = substr(:old.connection3,0,length(:old.connection3)-2);
    End If;
      -- commit;
       
    End If;

End If; --  connection removed

End; -- connection 3


Begin -- Connection 4

If :new.connection4 is not null and :old.connection4 is not null and :old.connection4 <> :new.connection4  then 

If is_pims(substr(:old.connection4,1,7)) and is_pims(substr(:new.connection4,1,7)) Then
    select power into  ls_power1 from pims_component where stock_number = substr(:old.connection4,1,7); -- get power string for the old connection stock number
    select power into  ls_power2 from pims_component where stock_number = substr(:new.connection4,1,7); -- get power string for the new connection stock number
Elsif is_flams(substr(:new.connection4,0,length(:new.connection4)-2)) and is_flams(substr(:old.connection4,0,length(:old.connection4)-2)) Then
    select power into  ls_power1 from flams.lab_equipment where stock_number = substr(:old.connection4,0,length(:old.connection4)-2); -- get power string for the old connection stock number
    select power into  ls_power2 from flams.lab_equipment where stock_number = substr(:new.connection4,0,length(:new.connection4)-2); -- get power string for the new connection stock number
End If;   

    If instr(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0  Then
    
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection4, ls_str1,sysdate);
      If is_pims(substr(:old.connection4,1,7)) Then
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection4,1,7);
      Elsif is_flams(substr(:old.connection4,0,length(:old.connection4)-2)) then
           update flams.lab_equipment
           set power = ls_str1
           where stock_number = substr(:old.connection4,0,length(:old.connection4)-2);
      End If;       
    End If;
    
    If instr(ls_power2, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0  or ls_power2 is null Then
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection4, ls_str2,sysdate);
       If is_pims(substr(:new.connection4,1,7)) Then
         update pims_component
         set  power = ls_str2
         where stock_number = substr(:new.connection4,1,7);
        Elsif is_flams(substr(:new.connection4,0,length(:new.connection4)-2)) then
           update flams.lab_equipment
           set power = ls_str2
           where stock_number = substr(:new.connection4,0,length(:new.connection4)-2);
      End If;  
           
     else
     If is_pims(substr(:new.connection4,1,7)) Then
      update pims_component
       set  power = ls_power2
       where stock_number = substr(:new.connection4,1,7);
      Elsif  is_flams(substr(:new.connection4,0,length(:new.connection4)-2)) then
           update flams.lab_equipment
           set power = ls_power2
           where stock_number = substr(:new.connection4,0,length(:new.connection4)-2);
      End If;  
       
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection4, ls_power2,sysdate);
       
   
     end If;
End if; -- new and old connections are not null

If :new.connection4 is not null and :old.connection4 is null  then  -- new connection
    
If is_pims(substr(:new.connection4,1,7)) Then
    select power into ls_power2 from pims_component where stock_number = substr(:new.connection4,1,7);
elsif is_flams(substr(:new.connection4,0,length(:new.connection4)-2)) then
     select power into ls_power2 from flams.lab_equipment where stock_number = substr(:new.connection4,0,length(:new.connection4)-2);
End If;


    
    If instr(ls_power2, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0 Then
    
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection4, ls_str2,sysdate);
       
     If is_pims(substr(:new.connection4,1,7)) Then
       update pims_component
        set  power = ls_str2
        where stock_number = substr(:new.connection4,1,7);
      End If;
      if is_flams(substr(:new.connection4,0,length(:new.connection4)-2)) then
        update flams.lab_equipment
        set power = ls_str2
        where stock_number = substr(:new.connection4,0,length(:new.connection4)-2);
      end if;
    Else
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection4, ls_power2,sysdate);
      
      
     If is_pims(substr(:new.connection4,1,7)) Then
      update pims_component
        set  power = ls_power2
        where stock_number = substr(:new.connection4,1,7);
     End If;
      
       If is_flams(substr(:new.connection4,0,length(:new.connection4)-2)) then
        update flams.lab_equipment
        set power = ls_str2
        where stock_number = substr(:new.connection4,0,length(:new.connection4)-2);
      end if;
      
   End If; 
   

End If; -- new connection added


If :new.connection4 is null and :old.connection4 is not null  then 
    If is_pims(substr(:old.connection4,1,7)) then
        select power into  ls_power1 from pims_component where stock_number = substr(:old.connection4,1,7);
    elsif is_flams(substr(:old.connection4,0,length(:old.connection4)-2)) then
        select power into  ls_power1 from flams.lab_equipment where stock_number = substr(:old.connection4,0,length(:old.connection4)-2);
    end if;
    
    If instr(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0 Then
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection4, ls_str1,sysdate);
     If is_pims(substr(:old.connection4,1,7)) then
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection4,1,7);
      Elsif is_flams(substr(:old.connection4,0,length(:old.connection4)-2)) then
        update flams.lab_equipment
       set  power = ls_str1
       where stock_number = substr(:old.connection4,0,length(:old.connection4)-2);
      End If;
     Else 
      insert into rpc_full_string(stock, fullstring,updated) values (:old.connection4, ls_power1,sysdate);
     
     If is_pims(substr(:old.connection4,1,7)) then
       update pims_component
       set  power = ls_power1
       where stock_number = substr(:old.connection4,1,7);
    Elsif is_flams(substr(:old.connection4,0,length(:old.connection4)-2)) then
    
     update flams.lab_equipment
       set  power = ls_power1
       where stock_number = substr(:old.connection4,0,length(:old.connection4)-2);
    End If;
      -- commit;
       
    End If;

End If; --  connection removed

End; -- connection 4


Begin -- Connection 5

If :new.connection5 is not null and :old.connection5 is not null and :old.connection5 <> :new.connection5  then 

If is_pims(substr(:old.connection5,1,7)) and is_pims(substr(:new.connection5,1,7)) Then
    select power into  ls_power1 from pims_component where stock_number = substr(:old.connection5,1,7); -- get power string for the old connection stock number
    select power into  ls_power2 from pims_component where stock_number = substr(:new.connection5,1,7); -- get power string for the new connection stock number
Elsif is_flams(substr(:new.connection5,0,length(:new.connection5)-2)) and is_flams(substr(:old.connection5,0,length(:old.connection5)-2)) Then
    select power into  ls_power1 from flams.lab_equipment where stock_number = substr(:old.connection5,0,length(:old.connection5)-2); -- get power string for the old connection stock number
    select power into  ls_power2 from flams.lab_equipment where stock_number = substr(:new.connection5,0,length(:new.connection5)-2); -- get power string for the new connection stock number
End If;   

    If instr(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0  Then
    
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection5, ls_str1,sysdate);
      If is_pims(substr(:old.connection5,1,7)) Then
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection5,1,7);
      Elsif is_flams(substr(:old.connection5,0,length(:old.connection5)-2)) then
           update flams.lab_equipment
           set power = ls_str1
           where stock_number = substr(:old.connection5,0,length(:old.connection5)-2);
      End If;       
    End If;
    
    If instr(ls_power2, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0  or ls_power2 is null Then
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection5, ls_str2,sysdate);
       If is_pims(substr(:new.connection5,1,7)) Then
         update pims_component
         set  power = ls_str2
         where stock_number = substr(:new.connection5,1,7);
        Elsif is_flams(substr(:new.connection5,0,length(:new.connection5)-2)) then
           update flams.lab_equipment
           set power = ls_str2
           where stock_number = substr(:new.connection5,0,length(:new.connection5)-2);
      End If;  
           
     else
     If is_pims(substr(:new.connection5,1,7)) Then
      update pims_component
       set  power = ls_power2
       where stock_number = substr(:new.connection5,1,7);
      Elsif  is_flams(substr(:new.connection5,0,length(:new.connection5)-2)) then
           update flams.lab_equipment
           set power = ls_power2
           where stock_number = substr(:new.connection5,0,length(:new.connection5)-2);
      End If;  
       
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection5, ls_power2,sysdate);
       
   
     end If;
End if; -- new and old connections are not null

If :new.connection5 is not null and :old.connection5 is null  then  -- new connection
    
If is_pims(substr(:new.connection5,1,7)) Then
    select power into ls_power2 from pims_component where stock_number = substr(:new.connection5,1,7);
elsif is_flams(substr(:new.connection5,0,length(:new.connection5)-2)) then
     select power into ls_power2 from flams.lab_equipment where stock_number = substr(:new.connection5,0,length(:new.connection5)-2);
End If;


    
    If instr(ls_power2, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0 Then
    
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection5, ls_str2,sysdate);
       
     If is_pims(substr(:new.connection5,1,7)) Then
       update pims_component
        set  power = ls_str2
        where stock_number = substr(:new.connection5,1,7);
      End If;
      if is_flams(substr(:new.connection5,0,length(:new.connection5)-2)) then
        update flams.lab_equipment
        set power = ls_str2
        where stock_number = substr(:new.connection5,0,length(:new.connection5)-2);
      end if;
    Else
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection5, ls_power2,sysdate);
      
      
     If is_pims(substr(:new.connection5,1,7)) Then
      update pims_component
        set  power = ls_power2
        where stock_number = substr(:new.connection5,1,7);
     End If;
      
       If is_flams(substr(:new.connection5,0,length(:new.connection5)-2)) then
        update flams.lab_equipment
        set power = ls_str2
        where stock_number = substr(:new.connection5,0,length(:new.connection5)-2);
      end if;
      
   End If; 
   

End If; -- new connection added


If :new.connection5 is null and :old.connection5 is not null  then 
    If is_pims(substr(:old.connection5,1,7)) then
        select power into  ls_power1 from pims_component where stock_number = substr(:old.connection5,1,7);
    elsif is_flams(substr(:old.connection5,0,length(:old.connection5)-2)) then
        select power into  ls_power1 from flams.lab_equipment where stock_number = substr(:old.connection5,0,length(:old.connection5)-2);
    end if;
    
    If instr(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0 Then
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection5, ls_str1,sysdate);
     If is_pims(substr(:old.connection5,1,7)) then
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection5,1,7);
      Elsif is_flams(substr(:old.connection5,0,length(:old.connection5)-2)) then
        update flams.lab_equipment
       set  power = ls_str1
       where stock_number = substr(:old.connection5,0,length(:old.connection5)-2);
      End If;
     Else 
      insert into rpc_full_string(stock, fullstring,updated) values (:old.connection5, ls_power1,sysdate);
     
     If is_pims(substr(:old.connection5,1,7)) then
       update pims_component
       set  power = ls_power1
       where stock_number = substr(:old.connection5,1,7);
    Elsif is_flams(substr(:old.connection5,0,length(:old.connection5)-2)) then
    
     update flams.lab_equipment
       set  power = ls_power1
       where stock_number = substr(:old.connection5,0,length(:old.connection5)-2);
    End If;
      -- commit;
       
    End If;

End If; --  connection removed

End; -- connection 5



Begin -- Connection 6

If :new.connection6 is not null and :old.connection6 is not null and :old.connection6 <> :new.connection6  then 

If is_pims(substr(:old.connection6,1,7)) and is_pims(substr(:new.connection6,1,7)) Then
    select power into  ls_power1 from pims_component where stock_number = substr(:old.connection6,1,7); -- get power string for the old connection stock number
    select power into  ls_power2 from pims_component where stock_number = substr(:new.connection6,1,7); -- get power string for the new connection stock number
Elsif is_flams(substr(:new.connection6,0,length(:new.connection6)-2)) and is_flams(substr(:old.connection6,0,length(:old.connection6)-2)) Then
    select power into  ls_power1 from flams.lab_equipment where stock_number = substr(:old.connection6,0,length(:old.connection6)-2); -- get power string for the old connection stock number
    select power into  ls_power2 from flams.lab_equipment where stock_number = substr(:new.connection6,0,length(:new.connection6)-2); -- get power string for the new connection stock number
End If;   

    If instr(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0  Then
    
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection6, ls_str1,sysdate);
      If is_pims(substr(:old.connection6,1,7)) Then
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection6,1,7);
      Elsif is_flams(substr(:old.connection6,0,length(:old.connection6)-2)) then
           update flams.lab_equipment
           set power = ls_str1
           where stock_number = substr(:old.connection6,0,length(:old.connection6)-2);
      End If;       
    End If;
    
    If instr(ls_power2, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0  or ls_power2 is null Then
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection6, ls_str2,sysdate);
       If is_pims(substr(:new.connection6,1,7)) Then
         update pims_component
         set  power = ls_str2
         where stock_number = substr(:new.connection6,1,7);
        Elsif is_flams(substr(:new.connection6,0,length(:new.connection6)-2)) then
           update flams.lab_equipment
           set power = ls_str2
           where stock_number = substr(:new.connection6,0,length(:new.connection6)-2);
      End If;  
           
     else
     If is_pims(substr(:new.connection6,1,7)) Then
      update pims_component
       set  power = ls_power2
       where stock_number = substr(:new.connection6,1,7);
      Elsif  is_flams(substr(:new.connection6,0,length(:new.connection6)-2)) then
           update flams.lab_equipment
           set power = ls_power2
           where stock_number = substr(:new.connection6,0,length(:new.connection6)-2);
      End If;  
       
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection6, ls_power2,sysdate);
       
   
     end If;
End if; -- new and old connections are not null

If :new.connection6 is not null and :old.connection6 is null  then  -- new connection
    
If is_pims(substr(:new.connection6,1,7)) Then
    select power into ls_power2 from pims_component where stock_number = substr(:new.connection6,1,7);
elsif is_flams(substr(:new.connection6,0,length(:new.connection6)-2)) then
     select power into ls_power2 from flams.lab_equipment where stock_number = substr(:new.connection6,0,length(:new.connection6)-2);
End If;


    
    If instr(ls_power2, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0 Then
    
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection6, ls_str2,sysdate);
       
     If is_pims(substr(:new.connection6,1,7)) Then
       update pims_component
        set  power = ls_str2
        where stock_number = substr(:new.connection6,1,7);
      End If;
      if is_flams(substr(:new.connection6,0,length(:new.connection6)-2)) then
        update flams.lab_equipment
        set power = ls_str2
        where stock_number = substr(:new.connection6,0,length(:new.connection6)-2);
      end if;
    Else
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection6, ls_power2,sysdate);
      
      
     If is_pims(substr(:new.connection6,1,7)) Then
      update pims_component
        set  power = ls_power2
        where stock_number = substr(:new.connection6,1,7);
     End If;
      
       If is_flams(substr(:new.connection6,0,length(:new.connection6)-2)) then
        update flams.lab_equipment
        set power = ls_str2
        where stock_number = substr(:new.connection6,0,length(:new.connection6)-2);
      end if;
      
   End If; 
   

End If; -- new connection added


If :new.connection6 is null and :old.connection6 is not null  then 
    If is_pims(substr(:old.connection6,1,7)) then
        select power into  ls_power1 from pims_component where stock_number = substr(:old.connection6,1,7);
    elsif is_flams(substr(:old.connection6,0,length(:old.connection6)-2)) then
        select power into  ls_power1 from flams.lab_equipment where stock_number = substr(:old.connection6,0,length(:old.connection6)-2);
    end if;
    
    If instr(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0 Then
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection6, ls_str1,sysdate);
     If is_pims(substr(:old.connection6,1,7)) then
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection6,1,7);
      Elsif is_flams(substr(:old.connection6,0,length(:old.connection6)-2)) then
        update flams.lab_equipment
       set  power = ls_str1
       where stock_number = substr(:old.connection6,0,length(:old.connection6)-2);
      End If;
     Else 
      insert into rpc_full_string(stock, fullstring,updated) values (:old.connection6, ls_power1,sysdate);
     
     If is_pims(substr(:old.connection6,1,7)) then
       update pims_component
       set  power = ls_power1
       where stock_number = substr(:old.connection6,1,7);
    Elsif is_flams(substr(:old.connection6,0,length(:old.connection6)-2)) then
    
     update flams.lab_equipment
       set  power = ls_power1
       where stock_number = substr(:old.connection6,0,length(:old.connection6)-2);
    End If;
      -- commit;
       
    End If;

End If; --  connection removed

End; -- connection 6


Begin -- Connection 7

If :new.connection7 is not null and :old.connection7 is not null and :old.connection7 <> :new.connection7  then 

If is_pims(substr(:old.connection7,1,7)) and is_pims(substr(:new.connection7,1,7)) Then
    select power into  ls_power1 from pims_component where stock_number = substr(:old.connection7,1,7); -- get power string for the old connection stock number
    select power into  ls_power2 from pims_component where stock_number = substr(:new.connection7,1,7); -- get power string for the new connection stock number
Elsif is_flams(substr(:new.connection7,0,length(:new.connection7)-2)) and is_flams(substr(:old.connection7,0,length(:old.connection7)-2)) Then
    select power into  ls_power1 from flams.lab_equipment where stock_number = substr(:old.connection7,0,length(:old.connection7)-2); -- get power string for the old connection stock number
    select power into  ls_power2 from flams.lab_equipment where stock_number = substr(:new.connection7,0,length(:new.connection7)-2); -- get power string for the new connection stock number
End If;   

    If instr(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0  Then
    
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection7, ls_str1,sysdate);
      If is_pims(substr(:old.connection7,1,7)) Then
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection7,1,7);
      Elsif is_flams(substr(:old.connection7,0,length(:old.connection7)-2)) then
           update flams.lab_equipment
           set power = ls_str1
           where stock_number = substr(:old.connection7,0,length(:old.connection7)-2);
      End If;       
    End If;
    
    If instr(ls_power2, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0  or ls_power2 is null Then
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection7, ls_str2,sysdate);
       If is_pims(substr(:new.connection7,1,7)) Then
         update pims_component
         set  power = ls_str2
         where stock_number = substr(:new.connection7,1,7);
        Elsif is_flams(substr(:new.connection7,0,length(:new.connection7)-2)) then
           update flams.lab_equipment
           set power = ls_str2
           where stock_number = substr(:new.connection7,0,length(:new.connection7)-2);
      End If;  
           
     else
     If is_pims(substr(:new.connection7,1,7)) Then
      update pims_component
       set  power = ls_power2
       where stock_number = substr(:new.connection7,1,7);
      Elsif  is_flams(substr(:new.connection7,0,length(:new.connection7)-2)) then
           update flams.lab_equipment
           set power = ls_power2
           where stock_number = substr(:new.connection7,0,length(:new.connection7)-2);
      End If;  
       
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection7, ls_power2,sysdate);
       
   
     end If;
End if; -- new and old connections are not null

If :new.connection7 is not null and :old.connection7 is null  then  -- new connection
    
If is_pims(substr(:new.connection7,1,7)) Then
    select power into ls_power2 from pims_component where stock_number = substr(:new.connection7,1,7);
elsif is_flams(substr(:new.connection7,0,length(:new.connection7)-2)) then
     select power into ls_power2 from flams.lab_equipment where stock_number = substr(:new.connection7,0,length(:new.connection7)-2);
End If;


    
    If instr(ls_power2, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0 Then
    
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection7, ls_str2,sysdate);
       
     If is_pims(substr(:new.connection7,1,7)) Then
       update pims_component
        set  power = ls_str2
        where stock_number = substr(:new.connection7,1,7);
      End If;
      if is_flams(substr(:new.connection7,0,length(:new.connection7)-2)) then
        update flams.lab_equipment
        set power = ls_str2
        where stock_number = substr(:new.connection7,0,length(:new.connection7)-2);
      end if;
    Else
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection7, ls_power2,sysdate);
      
      
     If is_pims(substr(:new.connection7,1,7)) Then
      update pims_component
        set  power = ls_power2
        where stock_number = substr(:new.connection7,1,7);
     End If;
      
       If is_flams(substr(:new.connection7,0,length(:new.connection7)-2)) then
        update flams.lab_equipment
        set power = ls_str2
        where stock_number = substr(:new.connection7,0,length(:new.connection7)-2);
      end if;
      
   End If; 
   

End If; -- new connection added


If :new.connection7 is null and :old.connection7 is not null  then 
    If is_pims(substr(:old.connection7,1,7)) then
        select power into  ls_power1 from pims_component where stock_number = substr(:old.connection7,1,7);
    elsif is_flams(substr(:old.connection7,0,length(:old.connection7)-2)) then
        select power into  ls_power1 from flams.lab_equipment where stock_number = substr(:old.connection7,0,length(:old.connection7)-2);
    end if;
    
    If instr(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0 Then
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection7, ls_str1,sysdate);
     If is_pims(substr(:old.connection7,1,7)) then
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection7,1,7);
      Elsif is_flams(substr(:old.connection7,0,length(:old.connection7)-2)) then
        update flams.lab_equipment
       set  power = ls_str1
       where stock_number = substr(:old.connection7,0,length(:old.connection7)-2);
      End If;
     Else 
      insert into rpc_full_string(stock, fullstring,updated) values (:old.connection7, ls_power1,sysdate);
     
     If is_pims(substr(:old.connection7,1,7)) then
       update pims_component
       set  power = ls_power1
       where stock_number = substr(:old.connection7,1,7);
    Elsif is_flams(substr(:old.connection7,0,length(:old.connection7)-2)) then
    
     update flams.lab_equipment
       set  power = ls_power1
       where stock_number = substr(:old.connection7,0,length(:old.connection7)-2);
    End If;
      -- commit;
       
    End If;

End If; --  connection removed
End; -- connection 7


Begin -- Connection 8
If :new.connection8 is not null and :old.connection8 is not null and :old.connection8 <> :new.connection8  then 

If is_pims(substr(:old.connection8,1,7)) and is_pims(substr(:new.connection8,1,7)) Then
    select power into  ls_power1 from pims_component where stock_number = substr(:old.connection8,1,7); -- get power string for the old connection stock number
    select power into  ls_power2 from pims_component where stock_number = substr(:new.connection8,1,7); -- get power string for the new connection stock number
Elsif is_flams(substr(:new.connection8,0,length(:new.connection8)-2)) and is_flams(substr(:old.connection8,0,length(:old.connection8)-2)) Then
    select power into  ls_power1 from flams.lab_equipment where stock_number = substr(:old.connection8,0,length(:old.connection8)-2); -- get power string for the old connection stock number
    select power into  ls_power2 from flams.lab_equipment where stock_number = substr(:new.connection8,0,length(:new.connection8)-2); -- get power string for the new connection stock number
End If;   

    If instr(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0  Then
    
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection8, ls_str1,sysdate);
      If is_pims(substr(:old.connection8,1,7)) Then
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection8,1,7);
      Elsif is_flams(substr(:old.connection8,0,length(:old.connection8)-2)) then
           update flams.lab_equipment
           set power = ls_str1
           where stock_number = substr(:old.connection8,0,length(:old.connection8)-2);
      End If;       
    End If;
    
    If instr(ls_power2, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0  or ls_power2 is null Then
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection8, ls_str2,sysdate);
       If is_pims(substr(:new.connection8,1,7)) Then
         update pims_component
         set  power = ls_str2
         where stock_number = substr(:new.connection8,1,7);
        Elsif is_flams(substr(:new.connection8,0,length(:new.connection8)-2)) then
           update flams.lab_equipment
           set power = ls_str2
           where stock_number = substr(:new.connection8,0,length(:new.connection8)-2);
      End If;  
           
     else
     If is_pims(substr(:new.connection8,1,7)) Then
      update pims_component
       set  power = ls_power2
       where stock_number = substr(:new.connection8,1,7);
      Elsif  is_flams(substr(:new.connection8,0,length(:new.connection8)-2)) then
           update flams.lab_equipment
           set power = ls_power2
           where stock_number = substr(:new.connection8,0,length(:new.connection8)-2);
      End If;  
       
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection8, ls_power2,sysdate);
       
   
     end If;
End if; -- new and old connections are not null

If :new.connection8 is not null and :old.connection8 is null  then  -- new connection
    
If is_pims(substr(:new.connection8,1,7)) Then
    select power into ls_power2 from pims_component where stock_number = substr(:new.connection8,1,7);
elsif is_flams(substr(:new.connection8,0,length(:new.connection8)-2)) then
     select power into ls_power2 from flams.lab_equipment where stock_number = substr(:new.connection8,0,length(:new.connection8)-2);
End If;


    
    If instr(ls_power2, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) = 0 Then
    
       ls_str2 := ls_power2||'|'||:new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port;
       insert into rpc_full_string(stock, fullstring,updated) values (:new.connection8, ls_str2,sysdate);
       
     If is_pims(substr(:new.connection8,1,7)) Then
       update pims_component
        set  power = ls_str2
        where stock_number = substr(:new.connection8,1,7);
      End If;
      if is_flams(substr(:new.connection8,0,length(:new.connection8)-2)) then
        update flams.lab_equipment
        set power = ls_str2
        where stock_number = substr(:new.connection8,0,length(:new.connection8)-2);
      end if;
    Else
      insert into rpc_full_string(stock, fullstring,updated) values (:new.connection8, ls_power2,sysdate);
      
      
     If is_pims(substr(:new.connection8,1,7)) Then
      update pims_component
        set  power = ls_power2
        where stock_number = substr(:new.connection8,1,7);
     End If;
      
       If is_flams(substr(:new.connection8,0,length(:new.connection8)-2)) then
        update flams.lab_equipment
        set power = ls_str2
        where stock_number = substr(:new.connection8,0,length(:new.connection8)-2);
      end if;
      
   End If; 
   

End If; -- new connection added


If :new.connection8 is null and :old.connection8 is not null  then 
    If is_pims(substr(:old.connection8,1,7)) then
        select power into  ls_power1 from pims_component where stock_number = substr(:old.connection8,1,7);
    elsif is_flams(substr(:old.connection8,0,length(:old.connection8)-2)) then
        select power into  ls_power1 from flams.lab_equipment where stock_number = substr(:old.connection8,0,length(:old.connection8)-2);
    end if;
    
    If instr(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port) > 0 Then
       ls_str1 := replace(replace(ls_power1, :new.rpc_stock_number||','||'1,'||:new.unit_part_number||','||ls_term||'_'||ls_port,''),'||','|');
       insert into rpc_full_string(stock, fullstring,updated) values (:old.connection8, ls_str1,sysdate);
     If is_pims(substr(:old.connection8,1,7)) then
       update pims_component
       set  power = ls_str1
       where stock_number = substr(:old.connection8,1,7);
      Elsif is_flams(substr(:old.connection8,0,length(:old.connection8)-2)) then
        update flams.lab_equipment
       set  power = ls_str1
       where stock_number = substr(:old.connection8,0,length(:old.connection8)-2);
      End If;
     Else 
      insert into rpc_full_string(stock, fullstring,updated) values (:old.connection8, ls_power1,sysdate);
     
     If is_pims(substr(:old.connection8,1,7)) then
       update pims_component
       set  power = ls_power1
       where stock_number = substr(:old.connection8,1,7);
    Elsif is_flams(substr(:old.connection8,0,length(:old.connection8)-2)) then
    
     update flams.lab_equipment
       set  power = ls_power1
       where stock_number = substr(:old.connection8,0,length(:old.connection8)-2);
    End If;
      -- commit;
       
    End If;

End If; --  connection removed

End; -- connection 8





End If; -- REMPC or NOT

Update pims_component
set power = :new.connection1||','||:new.connection2||','||:new.connection3||','||:new.connection4||','||:new.connection5||','||:new.connection6||','||:new.connection7||','||:new.connection8
where stock_number = :new.rpc_stock_number;


End;
/
ALTER TRIGGER "PIMS_NEW"."TRG_RPC_MAGIC" ENABLE;
--------------------------------------------------------
--  Constraints for Table PIMS_RPC_DETAILS
--------------------------------------------------------

  ALTER TABLE "PIMS_NEW"."PIMS_RPC_DETAILS" ADD CONSTRAINT "PIMS_RPC_DETAILS_PK" PRIMARY KEY ("RPC_STOCK_NUMBER")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "PIMS_NEW_D"  ENABLE;
  ALTER TABLE "PIMS_NEW"."PIMS_RPC_DETAILS" MODIFY ("RPC_STOCK_NUMBER" NOT NULL ENABLE);
