public String getSqlSelectTopDomainDistinctClassCode() {
if (S_sqlSelectTopDomainDistinctClassCode == null) {
S_sqlSelectTopDomainDistinctClassCode =
"SELECT "
+ "DISTINCT bdom.ClassCode "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ ".bdomdef AS bdom "
+ "INNER JOIN "
+ schema.getLowerDbSchemaName()
+ ".tdomdef tdom ON "
+ "tdom.TenantId = bdom.TenantId "
+ "AND tdom.Id = bdom.Id ";
}
return (S_sqlSelectTopDomainDistinctClassCode);
}
public String getSqlSelectAuditActionDistinctClassCode() {
if (S_sqlSelectAuditActionDistinctClassCode == null) {
S_sqlSelectAuditActionDistinctClassCode =
"SELECT "
+ "DISTINCT audt.ClassCode "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ ".AuditAction AS audt ";
}
return (S_sqlSelectAuditActionDistinctClassCode);
}
public String getSqlSelectTopDomainBuff() {
if (S_sqlSelectTopDomainBuff == null) {
S_sqlSelectTopDomainBuff =
"SELECT "
+ "bdom.ClassCode, "
+ "bdom.TenantId, "
+ "bdom.Id, "
+ "bdom.descr, "
+ "tdom.TldId, "
+ "tdom.Name, "
+ "bdom.Revision "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ ".bdomdef AS bdom "
+ "INNER JOIN "
+ schema.getLowerDbSchemaName()
+ ".tdomdef tdom ON "
+ "tdom.TenantId = bdom.TenantId "
+ "AND tdom.Id = bdom.Id ";
}
return (S_sqlSelectTopDomainBuff);
}
public String getSqlSelectAuditActionBuff() {
if (S_sqlSelectAuditActionBuff == null) {
S_sqlSelectAuditActionBuff =
"SELECT "
+ "audt.AuditActionId, "
+ "audt.Description, "
+ "audt.Revision "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ ".AuditAction AS audt ";
}
return (S_sqlSelectAuditActionBuff);
}