 /*Removed for PHI bug*/
 INSERT INTO CATISSUE_TABLE_RELATION (RELATIONSHIP_ID, PARENT_TABLE_ID, CHILD_TABLE_ID) values (130,21,1);
 INSERT INTO CATISSUE_SEARCH_DISPLAY_DATA (RELATIONSHIP_ID, COL_ID, DISPLAY_NAME) VALUES (130, 260 , 'Default Temperature In Centigrade');
+
+/**************** 9 aug 2007 ********* inserting search display data for distribution array ******************/
+INSERT INTO CATISSUE_SEARCH_DISPLAY_DATA (RELATIONSHIP_ID, COL_ID, DISPLAY_NAME, DEFAULT_VIEW_ATTRIBUTE) VALUES (131, 72 , 'Distributed Quantity', 0);
 
 /*******************Simple Search Edit scripts starts here***********/
 /*Patch ID: SimpleSearchEdit_12*/


INSERT INTO CATISSUE_TABLE_RELATION (RELATIONSHIP_ID, PARENT_TABLE_ID, CHILD_TABLE_ID, TABLES_IN_PATH) values (54,35,31,'27');

/* ************************************** QUERIES FOR SITE ***********************************************************/
INSERT INTO CATISSUE_SEARCH_DISPLAY_DATA (RELATIONSHIP_ID, COL_ID, DISPLAY_NAME, DEFAULT_VIEW_ATTRIBUTE) VALUES (6, 185, 'Name',1);
INSERT INTO CATISSUE_SEARCH_DISPLAY_DATA (RELATIONSHIP_ID, COL_ID, DISPLAY_NAME, DEFAULT_VIEW_ATTRIBUTE) VALUES (6, 184, 'Identifier',1);

/* ***************** RELATIONSHIP QUERIES FOR SPECIMEN ARRAY  ********************************************/
insert into CATISSUE_RELATED_TABLES_MAP values ( 72 , 71 , 'SPECIMEN_ARRAY_TYPE_ID', 'IDENTIFIER');
insert into CATISSUE_RELATED_TABLES_MAP values ( 72 , 70 , 'IDENTIFIER','IDENTIFIER');

/* ******9 aug 2007************ RELATIONSHIP QUERIES FOR DISTRIBUTION ARRAY ***************************************/
insert into CATISSUE_RELATED_TABLES_MAP values ( 75 , 37 , 'IDENTIFIER', 'DISTRIBUTION_ID');
insert into CATISSUE_RELATED_TABLES_MAP values ( 72 , 37 , 'IDENTIFIER','SPECIMEN_ARRAY_ID');


/* ***************** RELATIONSHIP QUERIES FOR CELL SPECIMEN REVIEW EVENT PARAMETERS ********************************************/
INSERT INTO CATISSUE_TABLE_RELATION (RELATIONSHIP_ID, PARENT_TABLE_ID, CHILD_TABLE_ID) VALUES (57, 43, 43);
