src-util/modulescript/src/org/openbravo/modulescript/UpdatePersistOrgInfo_data.xsql
changeset 33894 faca925fb578
parent 33887 793f3d0ba3f5
equal deleted inserted replaced
33893:a30751ea9d69 33894:faca925fb578
    29   <SqlMethod name="selectOrgs" type="preparedStatement" return="multiple">
    29   <SqlMethod name="selectOrgs" type="preparedStatement" return="multiple">
    30     <SqlMethodComment></SqlMethodComment>
    30     <SqlMethodComment></SqlMethodComment>
    31     <Sql><![CDATA[
    31     <Sql><![CDATA[
    32         SELECT AD_Org_ID
    32         SELECT AD_Org_ID
    33         FROM AD_Org
    33         FROM AD_Org
    34         WHERE isready = 'Y'
    34         WHERE IsReady = 'Y'
       
    35         AND AD_Org_ID <> '0'
       
    36         AND AD_PeriodControlAllowed_Org_ID IS NULL
       
    37         AND AD_CalendarOwner_Org_ID IS NULL 
       
    38         AND AD_InheritedCalendar_ID IS NULL 
       
    39         AND AD_LegalEntity_Org_ID IS NULL
       
    40         AND AD_BusinessUnit_Org_ID IS NULL
    35     ]]></Sql>
    41     ]]></Sql>
    36     <Field name="dummy" value="void"/>
    42     <Field name="dummy" value="void"/>
    37   </SqlMethod>
    43   </SqlMethod>
    38   <SqlMethod name="updatePersistOrgInfo" type="preparedStatement" return="rowcount">
    44   <SqlMethod name="updatePersistOrgInfo" type="preparedStatement" return="rowcount">
    39     <SqlMethodComment></SqlMethodComment>
    45     <SqlMethodComment></SqlMethodComment>