Thanks for the quick reply,
This is the view:

CREATE OR REPLACE VIEW V_LINES_MONTHS_EQUIPMENTS AS
SELECT
internal, fmonth, num, Eqp_FMonth, Code, EQP_Qty, Itory, Supplier, Manual, Code_Model,
(SELECT bzqp.Price FROM Bezeq_Prices bzqp WHERE bzqp.code=lmeqp.code AND fmonth=(SELECT max(fmonth) FROM Bezeq_Prices bzqp0 WHERE bzqp0.code=bzqp.Code AND bzqp0.fmonth<=lmeqp.fmonth)) Eqp_Price,
(SELECT max(fmonth) FROM Lines_Detail_Bills db WHERE db.Internal=lmeqp.Internal AND db.fmonth<=lmeqp.fmonth AND db.num=lmeqp.num AND db.pay_type=1) Const_Pay_FMonth
FROM
(
SELECT
lm.internal, lm.fmonth, lm.num,
MAX(lbzq.fmonth) Eqp_FMonth,
lbzq.Code, lbzq.Qty EQP_Qty, lbzq.Itory, lbzq.Supplier, lbzq.Manual, lbzq.Code_Model
FROM Lines_Bezeq lbzq, Lines_Months lm
WHERE lbzq.Internal(+)=lm.internal AND lbzq.num(+)=lm.num
AND nvl(lbzq.fmonth, '0') <= lm.Fmonth
GROUP BY
lm.internal, lm.fmonth, lm.num,
lbzq.Code, lbzq.Qty, lbzq.Itory, lbzq.Supplier,
lbzq.Manual, lbzq.Code_Model
) lmeqp

The 9i and 8i data-base structure is identical.

goldfinger