Ok in 8i SQL Plus - but ORA-00933 when creating a view !!!

From: Steve <saustin_at_hsius.com>
Date: 1 Jul 2005 06:31:05 -0700
Message-ID: <1120224665.345478.108660@g43g2000cwa.googlegroups.com>

Hi,

    Bizzare situation, can run the code below perfectly in SQL Plus 8i but when we try to create a view it generates the 0RA-00933 error message. Is there anything missing here, and why would SQL Plus be happy (and fast) but the view complain ?

Many thanks for any suggestions, Steve.

Select

p.ID,
p.STOCK_UM,
p.QTY_ON_HAND,
b.TRANSACTION_ID,
b.QTY,

(b.MATERIAL_AMOUNT + b.LABOR_AMOUNT + b.BURDEN_AMOUNT +
b.SERVICE_AMOUNT) as TOTALCOST,
b.POSTING_DATE
from INVENTORY_BALANCE b, PART p
WHERE p.QTY_ON_HAND > 0 and b.PART_ID = p.ID and b.POSTING_DATE in
(SELECT Max(POSTING_DATE) FROM INVENTORY_BALANCE)
order by p.ID Received on Fri Jul 01 2005 - 08:31:05 CDT