|
SELECT SA_OPOrg.sID AS SA_OPOrg, SA_OPOrg.SADDRESS AS sAddress, SA_OPOrg.SBZ2 AS sBZ2, SA_OPOrg.SCODE AS sCode, SA_OPOrg.SDESCRIPTION AS sDescription, SA_OPOrg.SFCODE AS sFCode, SA_OPOrg.sFID AS sFID, SA_OPOrg.sFName AS sFName, SA_OPOrg.SFAX AS sFax, SA_OPOrg.SLEVEL AS sLevel, SA_OPOrg.SLONGNAME AS sLongName, SA_OPOrg.SNAME AS sName, SA_OPOrg.SNODEKIND AS sNodeKind, SA_OPOrg.SORGKINDID AS sOrgKindID, SA_OPOrg.sParent AS sParent, SA_OPOrg.SPERSONID AS sPersonID, SA_OPOrg.SPHONE AS sPhone, SA_OPOrg.SSEQUENCE AS sSequence, SA_OPOrg.SVALIDSTATE AS sValidState, SA_OPOrg.SWXDEPTID AS sWxDeptID, SA_OPOrg.SZIP AS sZip, SA_OPOrg.SBZ1 AS sbz1, SA_OPOrg.VERSION AS version FROM SA_OPOrg SA_OPOrg WHERE (SA_OPOrg.SVALIDSTATE >= ?) AND ( (SA_OPOrg.SORGKINDID <> ?) AND (SA_OPOrg.SVALIDSTATE = ?) AND (SA_OPOrg.SVALIDSTATE = ?) AND (SA_OPOrg.sParent IS NULL) ) ORDER BY SA_OPOrg.SSEQUENCE ASC |
|