src/org/openbravo/erpCommon/ad_forms/DocLineLandedCost_data.xsql
changeset 25494 4ae6c365fd3e
parent 24890 5f3d0f2a445a
equal deleted inserted replaced
25493:1f26de8763c0 25494:4ae6c365fd3e
    43         AND IOL.M_INOUT_ID = IO.M_INOUT_ID
    43         AND IOL.M_INOUT_ID = IO.M_INOUT_ID
    44         AND LCR.M_LC_COST_ID = LCC.M_LC_COST_ID
    44         AND LCR.M_LC_COST_ID = LCC.M_LC_COST_ID
    45         AND IOL.M_LOCATOR_ID = L.M_LOCATOR_ID
    45         AND IOL.M_LOCATOR_ID = L.M_LOCATOR_ID
    46         AND LCR.ISMATCHADJUSTMENT = 'N'
    46         AND LCR.ISMATCHADJUSTMENT = 'N'
    47         AND LCC.M_LANDEDCOST_ID = ?
    47         AND LCC.M_LANDEDCOST_ID = ?
    48         ORDER BY IO.DOCUMENTNO, IO.M_INOUT_ID, IOL.LINE
    48         ORDER BY LCC.LINE, IO.DOCUMENTNO, IO.M_INOUT_ID, IOL.LINE
    49      ]]>
    49      ]]>
    50      </Sql>
    50      </Sql>
    51      <Parameter name="LC_Receiptline_Amt"/>
    51      <Parameter name="LC_Receiptline_Amt"/>
    52    </SqlMethod>
    52    </SqlMethod>
    53    <SqlMethod name="selectLCAccount" type="preparedStatement" return="multiple">
    53    <SqlMethod name="selectLCAccount" type="preparedStatement" return="multiple">