SELECT
  C.NAME,
  S.GOODUC,
  SG.SERIES,
  S.BASETOTAL,
  S.TOTAL,
  S.DELTA,
  S.RPRICE
FROM
  SDOC0182 S,
  GOODS C,
  SERIESGUIDE SG
WHERE
  (C.UNIQUECODE = S.GOODUC) AND
  (SG.ID =  S.SGID) AND
  (S.DOCUMENTID = (SELECT MAX(D.DOCUMENTID) FROM DOC0182 D WHERE (D.ISCLOSED = 0) AND (D.STATE = 8) AND (D.DOCUMENTTYPE = 60) PLAN JOIN (D INDEX (DOC0182_ISCLOSED)) ) )  AND
  (S.INVOICEID =  -20962) AND (S.INVOICEITEM = 46)
PLAN JOIN
  (S INDEX (SDOC0182_PRIM), C INDEX (GOODS_UC), SG INDEX (SERIESGUIDE_ID))