src/org/openbravo/erpCommon/ad_callouts/SL_WRPhase_Sequence_data.xsql
changeset 14971 647881af7155
parent 12996 bc639e86fe20
child 14977 08f2c75e1aa9
equal deleted inserted replaced
14970:f27ae92d213a 14971:647881af7155
    25 <SqlClass name="SLWRPhaseSequenceData" package="org.openbravo.erpCommon.ad_callouts">
    25 <SqlClass name="SLWRPhaseSequenceData" package="org.openbravo.erpCommon.ad_callouts">
    26   <SqlMethod name="select" type="preparedStatement" return="multiple">
    26   <SqlMethod name="select" type="preparedStatement" return="multiple">
    27     <SqlMethodComment></SqlMethodComment>
    27     <SqlMethodComment></SqlMethodComment>
    28     <Sql>
    28     <Sql>
    29       <![CDATA[
    29       <![CDATA[
    30       SELECT MA_Process_Id as process, costcenteruse as ccuse, preptime, '' as quantity, COALESCE(Outsourced, 'N') as outsourced
    30       SELECT MA_Process_Id as process, costcenteruse as ccuse, preptime, '' as quantity, COALESCE(Outsourced, 'N') as outsourced, COALESCE(estimatedtime, 0) as estimatedtime
    31       FROM MA_Sequence
    31       FROM MA_Sequence
    32       WHERE MA_Sequence_Id = ?
    32       WHERE MA_Sequence_Id = ?
    33       ]]>
    33       ]]>
    34     </Sql>
    34     </Sql>
    35     <Parameter name="maSequenceId"/>
    35     <Parameter name="maSequenceId"/>