PHP код:
SELECT /*+ FIRST_ROWS */ a.itemid, a.postedqty, a.postedvalue, a.deducted,
a.received, a.reservphysical, a.reservordered, a.onorder, a.ordered,
a.quotationissue, a.quotationreceipt, a.del_configid, a.inventdimid,
a.closed, a.registered, a.picked, a.availordered, a.availphysical,
a.physicalvalue, a.arrived, a.physicalinvent, a.closedqty,
a.lastupddatephysical, a.lastupddateexpected, a.postedvalueseccur_ru,
a.physicalvalueseccur_ru, a.chi_inventlocationid, a.recid
FROM inventsum a
WHERE substr(nls_lower(dataareaid), 1, 3) = nls_lower(:in1)
ORDER BY substr(nls_lower(a.dataareaid), 1, 3), a.closed, substr(
nls_lower(a.itemid), 1, 10)
его cost 1 800 000