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); }