public String getSqlSelectTagDistinctClassCode() {
if (S_sqlSelectTagDistinctClassCode == null) {
S_sqlSelectTagDistinctClassCode =
"SELECT "
+ "DISTINCT ctag.ClassCode "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ "..tag AS ctag ";
}
return (S_sqlSelectTagDistinctClassCode);
}
public String getSqlSelectISOCountryDistinctClassCode() {
if (S_sqlSelectISOCountryDistinctClassCode == null) {
S_sqlSelectISOCountryDistinctClassCode =
"SELECT "
+ "DISTINCT isoc.ClassCode "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ "..iso_cntry AS isoc ";
}
return (S_sqlSelectISOCountryDistinctClassCode);
}
public String getSqlSelectISOCountryBuff() {
if (S_sqlSelectISOCountryBuff == null) {
S_sqlSelectISOCountryBuff =
"SELECT "
+ "isoc.id, "
+ "isoc.iso_code, "
+ "isoc.country_name, "
+ "isoc.revision "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ "..iso_cntry AS isoc ";
}
return (S_sqlSelectISOCountryBuff);
}
public String getSqlSelectTagBuff() {
if (S_sqlSelectTagBuff == null) {
S_sqlSelectTagBuff =
"SELECT "
+ "ctag.tenantid, "
+ "ctag.id, "
+ "ctag.name, "
+ "ctag.descr, "
+ "ctag.revision "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ "..tag AS ctag ";
}
return (S_sqlSelectTagBuff);
}
public String getSqlSelectContactTagBuff() {
if (S_sqlSelectContactTagBuff == null) {
S_sqlSelectContactTagBuff =
"SELECT "
+ "cttg.tenantid, "
+ "cttg.contactid, "
+ "cttg.tagid, "
+ "cttg.tagvalue, "
+ "cttg.revision "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ "..ctc_tag AS cttg ";
}
return (S_sqlSelectContactTagBuff);
}