SELECT I.INSTRUMENT_ID, GOODSRACK.STOCKROOM_OID, GOODSRACK.DESCRIPTION GOODS_RACK, G.DESCRIPTION GOODS_LOCATION, NULL BOX_OID,
I.STATUS, STATUSCHANGEENTRY.INSTRUMENTSTATUS, I.INSTRUMENT_TYPE_OID, SLOG.END_DATE, I.TYPE_CODE, I.METER_CODE, STOCKROOM.ADMINISTRATOR
FROM STOCKROOM, GOODSRACK,GOODSLOCATION G, STOCKLOG SLOG, STATUSCHANGEENTRY, REQUEST R,INSTRUMENT I
WHERE
STOCKROOM.STOCK_ROOM_OID = GOODSRACK.STOCKROOM_OID(+)
AND GOODSRACK.GOODS_RACK_OID = G.GOODSRACK_OID(+)
AND G.GOODS_LOCATION_OID = SLOG.GOODS_LOCATION_OID (+)
AND SLOG.STOCK_LOG_OID = (SELECT MAX(STOCKLOG.STOCK_LOG_OID) FROM STOCKLOG WHERE STOCKLOG.INSTRUMENT_OID = I.INSTRUMENT_OID)
AND STATUSCHANGEENTRY.STATUS = 0
AND STATUSCHANGEENTRY.INSTRUMENT_OID = I.INSTRUMENT_OID
AND R.REQUEST_OID = I.REQUEST_OID
AND i.division_oid = :1
这是sql,
|