SET DEFINE OFF

set serveroutput on format wrapped;

-- first we create new version id for trb3lookup_vers table:

declare
  myvers  number := -1;
  mycontext number := 239; -- default context as put into hanal2 treepar
  myrun number := -1;
  myauthor varchar2 (80 char) := 'Joern Adamczewski-Musch';
  mydescription varchar2 (4000 char) := 'Test of trb3 mapping from the RICH700 photon beam time July 2017';
  mycommentid number :=-1;
  
begin
    SELECT rich_ana2.rich_par_query.next_version INTO myvers FROM DUAL;
              INSERT INTO rich_ana2.rich700_trb3lookup_vers 
      	            (vers_id, orig_context_id, run_id, author, description)
                 VALUES (myvers, mycontext, myrun, myauthor, mydescription);
          DBMS_OUTPUT.put_line('version:' || myvers);


-- then we insert the automatically imported maping table with some modifications:


 --DBMS_OUTPUT.put_line('address(0x1239):' || to_number('1239', 'XXXX'));
 
 --end;
 
 
 
INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 17.0, 1.0, 7.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 18.0, 1.0, 8.0); 

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 19.0, 1.0, 15.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 21.0, 1.0, 16.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 20.0, 1.0, 23.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 22.0, 1.0, 24.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 23.0, 1.0, 31.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 25.0, 1.0, 32.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 24.0, 1.0, 39.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 26.0, 1.0, 40.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 27.0, 1.0, 47.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 28.0, 1.0, 48.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 30.0, 1.0, 55.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 29.0, 1.0, 56.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 31.0, 1.0, 63.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 32.0, 1.0, 64.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 1.0, 1.0, 5.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 2.0, 1.0, 6.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 3.0, 1.0, 13.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 4.0, 1.0, 14.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 5.0, 1.0, 21.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 6.0, 1.0, 22.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 7.0, 1.0, 29.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 8.0, 1.0, 30.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 9.0, 1.0, 37.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 10.0, 1.0, 38.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 11.0, 1.0, 45.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 12.0, 1.0, 46.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 13.0, 1.0, 53.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 14.0, 1.0, 54.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 15.0, 1.0, 61.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1239', 'XXXX'), 16.0, 1.0, 62.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 17.0, 1.0, 3.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 18.0, 1.0, 4.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 19.0, 1.0, 11.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 21.0, 1.0, 12.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 20.0, 1.0, 19.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 22.0, 1.0, 20.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 23.0, 1.0, 27.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 25.0, 1.0, 28.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 24.0, 1.0, 35.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 26.0, 1.0, 36.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 27.0, 1.0, 43.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 28.0, 1.0, 44.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 30.0, 1.0, 51.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 29.0, 1.0, 52.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 31.0, 1.0, 59.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 32.0, 1.0, 60.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 1.0, 1.0, 1.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 2.0, 1.0, 2.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 3.0, 1.0, 9.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 4.0, 1.0, 10.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 5.0, 1.0, 17.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 6.0, 1.0, 18.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 7.0, 1.0, 25.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 8.0, 1.0, 26.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 9.0, 1.0, 33.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 10.0, 1.0, 34.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 11.0, 1.0, 41.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 12.0, 1.0, 42.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 13.0, 1.0, 49.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 14.0, 1.0, 50.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 15.0, 1.0, 57.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1216','XXXX'), 16.0, 1.0, 58.0);

--INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
--VALUES (#, NULL, NULL, NULL);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 17.0, 4.0, 7.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 18.0, 4.0, 8.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 19.0, 4.0, 15.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 21.0, 4.0, 16.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 20.0, 4.0, 23.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 22.0, 4.0, 24.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 23.0, 4.0, 31.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 25.0, 4.0, 32.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 24.0, 4.0, 39.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 26.0, 4.0, 40.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 27.0, 4.0, 47.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 28.0, 4.0, 48.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 30.0, 4.0, 55.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 29.0, 4.0, 56.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 31.0, 4.0, 63.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 32.0, 4.0, 64.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 1.0, 4.0, 5.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 2.0, 4.0, 6.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 3.0, 4.0, 13.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 4.0, 4.0, 14.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 5.0, 4.0, 21.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 6.0, 4.0, 22.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 7.0, 4.0, 29.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 8.0, 4.0, 30.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 9.0, 4.0, 37.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 10.0, 4.0, 38.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 11.0, 4.0, 45.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 12.0, 4.0, 46.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 13.0, 4.0, 53.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 14.0, 4.0, 54.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 15.0, 4.0, 61.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1241','XXXX'), 16.0, 4.0, 62.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 17.0, 4.0, 3.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 18.0, 4.0, 4.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 19.0, 4.0, 11.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 21.0, 4.0, 12.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 20.0, 4.0, 19.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 22.0, 4.0, 20.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 23.0, 4.0, 27.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 25.0, 4.0, 28.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 24.0, 4.0, 35.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 26.0, 4.0, 36.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 27.0, 4.0, 43.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 28.0, 4.0, 44.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 30.0, 4.0, 51.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 29.0, 4.0, 52.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 31.0, 4.0, 59.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 32.0, 4.0, 60.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 1.0, 4.0, 1.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 2.0, 4.0, 2.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 3.0, 4.0, 9.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 4.0, 4.0, 10.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 5.0, 4.0, 17.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 6.0, 4.0, 18.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 7.0, 4.0, 25.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 8.0, 4.0, 26.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 9.0, 4.0, 33.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 10.0, 4.0, 34.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 11.0, 4.0, 41.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 12.0, 4.0, 42.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 13.0, 4.0, 49.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 14.0, 4.0, 50.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 15.0, 4.0, 57.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1240','XXXX'), 16.0, 4.0, 58.0);

--INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
--VALUES (#TDC-nr, TDC-Ch, PMT-nr, PMT-pix);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 31.0, 2.0, 64.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 29.0, 2.0, 63.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 30.0, 2.0, 56.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 28.0, 2.0, 55.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 27.0, 2.0, 48.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 26.0, 2.0, 47.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 24.0, 2.0, 40.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 25.0, 2.0, 39.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 23.0, 2.0, 32.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 22.0, 2.0, 31.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 20.0, 2.0, 24.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 21.0, 2.0, 23.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 19.0, 2.0, 16.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 18.0, 2.0, 15.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 17.0, 2.0, 8.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 32.0, 2.0, 7.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 16.0, 2.0, 62.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 15.0, 2.0, 61.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 14.0, 2.0, 54.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 13.0, 2.0, 53.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 12.0, 2.0, 46.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 11.0, 2.0, 45.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 10.0, 2.0, 38.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 9.0, 2.0, 37.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 8.0, 2.0, 30.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 7.0, 2.0, 29.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 6.0, 2.0, 22.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 5.0, 2.0, 21.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 4.0, 2.0, 14.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 3.0, 2.0, 13.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 2.0, 2.0, 6.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1223','XXXX'), 1.0, 2.0, 5.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 31.0, 2.0, 60.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 29.0, 2.0, 59.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 30.0, 2.0, 52.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 28.0, 2.0, 51.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 27.0, 2.0, 44.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 26.0, 2.0, 43.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 24.0, 2.0, 36.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 25.0, 2.0, 35.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 23.0, 2.0, 28.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 22.0, 2.0, 27.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 20.0, 2.0, 20.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 21.0, 2.0, 19.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 19.0, 2.0, 12.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 18.0, 2.0, 11.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 17.0, 2.0, 4.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 32.0, 2.0, 3.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 16.0, 2.0, 58.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 15.0, 2.0, 57.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 14.0, 2.0, 50.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 13.0, 2.0, 49.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 12.0, 2.0, 42.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 11.0, 2.0, 41.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 10.0, 2.0, 34.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 9.0, 2.0, 33.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 8.0, 2.0, 26.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 7.0, 2.0, 25.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 6.0, 2.0, 18.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 5.0, 2.0, 17.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 4.0, 2.0, 10.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 3.0, 2.0, 9.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 2.0, 2.0, 2.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1212','XXXX'), 1.0, 2.0, 1.0);

--INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
--VALUES (#, NULL, NULL, NULL);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 31.0, 3.0, 64.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 29.0, 3.0, 63.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 30.0, 3.0, 56.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 28.0, 3.0, 55.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 27.0, 3.0, 48.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 26.0, 3.0, 47.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 24.0, 3.0, 40.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 25.0, 3.0, 39.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 23.0, 3.0, 32.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 22.0, 3.0, 31.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 20.0, 3.0, 24.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 21.0, 3.0, 23.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 19.0, 3.0, 16.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 18.0, 3.0, 15.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 17.0, 3.0, 8.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 32.0, 3.0, 7.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 16.0, 3.0, 62.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 15.0, 3.0, 61.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 14.0, 3.0, 54.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 13.0, 3.0, 53.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 12.0, 3.0, 46.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 11.0, 3.0, 45.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 10.0, 3.0, 38.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 9.0, 3.0, 37.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 8.0, 3.0, 30.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 7.0, 3.0, 29.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 6.0, 3.0, 22.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 5.0, 3.0, 21.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 4.0, 3.0, 14.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 3.0, 3.0, 13.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 2.0, 3.0, 6.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1227','XXXX'), 1.0, 3.0, 5.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 31.0, 3.0, 60.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 29.0, 3.0, 59.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 30.0, 3.0, 52.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 28.0, 3.0, 51.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 27.0, 3.0, 44.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 26.0, 3.0, 43.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 24.0, 3.0, 36.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 25.0, 3.0, 35.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 23.0, 3.0, 28.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 22.0, 3.0, 27.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 20.0, 3.0, 20.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 21.0, 3.0, 19.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 19.0, 3.0, 12.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 18.0, 3.0, 11.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 17.0, 3.0, 4.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 32.0, 3.0, 3.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 16.0, 3.0, 58.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 15.0, 3.0, 57.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 14.0, 3.0, 50.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 13.0, 3.0, 49.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 12.0, 3.0, 42.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 11.0, 3.0, 41.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 10.0, 3.0, 34.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 9.0, 3.0, 33.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 8.0, 3.0, 26.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 7.0, 3.0, 25.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 6.0, 3.0, 18.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 5.0, 3.0, 17.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 4.0, 3.0, 10.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 3.0, 3.0, 9.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 2.0, 3.0, 2.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1238','XXXX'), 1.0, 3.0, 1.0);

--INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
--VALUES (#, NULL, NULL, NULL);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 31.0, 5.0, 64.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 29.0, 5.0, 63.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 30.0, 5.0, 56.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 28.0, 5.0, 55.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 27.0, 5.0, 48.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 26.0, 5.0, 47.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 24.0, 5.0, 40.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 25.0, 5.0, 39.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 23.0, 5.0, 32.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 22.0, 5.0, 31.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 20.0, 5.0, 24.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 21.0, 5.0, 23.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 19.0, 5.0, 16.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 18.0, 5.0, 15.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 17.0, 5.0, 8.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 32.0, 5.0, 7.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 16.0, 5.0, 62.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 15.0, 5.0, 61.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 14.0, 5.0, 54.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 13.0, 5.0, 53.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 12.0, 5.0, 46.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 11.0, 5.0, 45.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 10.0, 5.0, 38.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 9.0, 5.0, 37.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 8.0, 5.0, 30.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 7.0, 5.0, 29.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 6.0, 5.0, 22.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 5.0, 5.0, 21.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 4.0, 5.0, 14.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 3.0, 5.0, 13.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 2.0, 5.0, 6.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1218','XXXX'), 1.0, 5.0, 5.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 31.0, 5.0, 60.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 29.0, 5.0, 59.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 30.0, 5.0, 52.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 28.0, 5.0, 51.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 27.0, 5.0, 44.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 26.0, 5.0, 43.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 24.0, 5.0, 36.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 25.0, 5.0, 35.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 23.0, 5.0, 28.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 22.0, 5.0, 27.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 20.0, 5.0, 20.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 21.0, 5.0, 19.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 19.0, 5.0, 12.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 18.0, 5.0, 11.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 17.0, 5.0, 4.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 32.0, 5.0, 3.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 16.0, 5.0, 58.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 15.0, 5.0, 57.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 14.0, 5.0, 50.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 13.0, 5.0, 49.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 12.0, 5.0, 42.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 11.0, 5.0, 41.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 10.0, 5.0, 34.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 9.0, 5.0, 33.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 8.0, 5.0, 26.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 7.0, 5.0, 25.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 6.0, 5.0, 18.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 5.0, 5.0, 17.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 4.0, 5.0, 10.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 3.0, 5.0, 9.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 2.0, 5.0, 2.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1214','XXXX'), 1.0, 5.0, 1.0);

--INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
--VALUES (#, NULL, NULL, NULL);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 31.0, 6.0, 64.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 29.0, 6.0, 63.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 30.0, 6.0, 56.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 28.0, 6.0, 55.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 27.0, 6.0, 48.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 26.0, 6.0, 47.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 24.0, 6.0, 40.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 25.0, 6.0, 39.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 23.0, 6.0, 32.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 22.0, 6.0, 31.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 20.0, 6.0, 24.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 21.0, 6.0, 23.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 19.0, 6.0, 16.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 18.0, 6.0, 15.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 17.0, 6.0, 8.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 32.0, 6.0, 7.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 16.0, 6.0, 62.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 15.0, 6.0, 61.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 14.0, 6.0, 54.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 13.0, 6.0, 53.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 12.0, 6.0, 46.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 11.0, 6.0, 45.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 10.0, 6.0, 38.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 9.0, 6.0, 37.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 8.0, 6.0, 30.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 7.0, 6.0, 29.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 6.0, 6.0, 22.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 5.0, 6.0, 21.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 4.0, 6.0, 14.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 3.0, 6.0, 13.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 2.0, 6.0, 6.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1237','XXXX'), 1.0, 6.0, 5.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 31.0, 6.0, 60.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 29.0, 6.0, 59.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 30.0, 6.0, 52.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 28.0, 6.0, 51.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 27.0, 6.0, 44.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 26.0, 6.0, 43.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 24.0, 6.0, 36.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 25.0, 6.0, 35.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 23.0, 6.0, 28.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 22.0, 6.0, 27.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 20.0, 6.0, 20.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 21.0, 6.0, 19.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 19.0, 6.0, 12.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 18.0, 6.0, 11.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 17.0, 6.0, 4.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 32.0, 6.0, 3.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 16.0, 6.0, 58.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 15.0, 6.0, 57.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 14.0, 6.0, 50.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 13.0, 6.0, 49.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 12.0, 6.0, 42.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 11.0, 6.0, 41.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 10.0, 6.0, 34.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 9.0, 6.0, 33.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 8.0, 6.0, 26.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 7.0, 6.0, 25.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 6.0, 6.0, 18.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 5.0, 6.0, 17.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 4.0, 6.0, 10.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 3.0, 6.0, 9.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 2.0, 6.0, 2.0);

INSERT INTO RICH700_TRB3LOOKUP_DATA (VERS_ID, TRBNET_ADDRESS, CHANNEL_ID, PMT_ID, PMT_PIXEL) 
VALUES (myvers, to_number('1235','XXXX'), 1.0, 6.0, 1.0);


-- finally, we have to validate the version:

--insert into rich_comment ( table_modified, author, description )
--           values ('RICH700_TRB3LOOKUP', 'JAM',
--                   'Version '||myvers||' used for testing');
--      select rich_comment_sequ.currval into mycommentid from dual;
--
--insert into rich700_trb3lookup
--              ( vers_id, date_created, date_expired, used_since, used_until, comment_id )
--              values ( myvers, sysdate, hdate.high_date,
--                       '01-JAN-1970', hdate.high_date, mycommentid );

end;


-- Import Data into table RICH700_TRB3LOOKUP_DATA from file geometry_cp.xlsx . Task successful and sent to worksheet.
