DGPSPConstants.COL_WEIGHT + ",\"1\""+",\"1\""+",\"1\""+
DGPSPConstants.COL_WEIGHT + ",\"1\""+",\"1\""+",\"1\""+",\"1\""+",\"1\""+
  protected String formManifestTypeSql (FilterClauses filterClauses, int recentRun) {    String derivedTable =       PrepareDerivedTables.getDerivedTableName(PrepareDerivedTables.CARGO_TYPE,recentRun);    String manifestTable = DGPSPConstants.MANIFEST_TABLE + "_" + recentRun;    String conveyanceInstanceTable = DGPSPConstants.CONV_INSTANCE_TABLE + "_" + recentRun;    String conveyancePrototypeTable = DGPSPConstants.CONV_PROTOTYPE_TABLE + "_" + recentRun;    String ciConvID      = conveyanceInstanceTable + "." + DGPSPConstants.COL_CONVEYANCEID;    String cpPrototypeID = conveyancePrototypeTable + "." + DGPSPConstants.COL_PROTOTYPEID;        String typeID = DGPSPConstants.COL_ALP_TYPEID;    String nomen  = DGPSPConstants.COL_ALP_NOMENCLATURE;    String instanceOwner = DGPSPConstants.COL_OWNER;    String instanceID    = DGPSPConstants.COL_MANIFEST_ITEM_ID;    String proto = "m." + DGPSPConstants.COL_ALP_TYPEID;    String manifestAssetID = "m." + DGPSPConstants.COL_ASSETID;    String derivedAssetID   = "d." + DGPSPConstants.COL_ASSETID;    String sqlQuery =       "select distinct m." + typeID + ", m." + nomen + ", m." + typeID +       ",\"1\", d."+ instanceOwner + ", m." + instanceID + ", \nm." +       DGPSPConstants.COL_WEIGHT + ",\"1\""+",\"1\""+",\"1\""+      "\nfrom " + manifestTable + " m, " + derivedTable + " d \n" +      filterClauses.getWhereSql (instanceOwner, cpPrototypeID, ciConvID, proto, instanceID) +      "\nand " + manifestAssetID + " = " + derivedAssetID +      "\norder by d." + instanceOwner + ", m." + nomen;        if (debug)       TPFDDLoggerFactory.createLogger().logMessage(Logger.NORMAL, Logger.GENERIC, "FilterQuery.formManifestTypeSql - \n" + sqlQuery);        return sqlQuery;  }