I have a view based on two tables joined by the id of a parent table with the same id as a foreign key in the child table. This is the select statement for my view.

Code:
SELECT L.AGENT_NUM, L.SCAC, L.LOI_DATE, L.LOI_REPL_DATE, F.AREA, L.LOI_CANCEL_DATE,
L.BOOKING_AGENT, L.GBLOC
FROM LOI_AUTHORITY L, FP_AREAS F
WHERE L.FP_AREA_ID = F.ID
This is the select on data dictionary to see what rows of views have update, insert and deletes.

Code:
  1  SELECT column_name, updatable, insertable, deletable
  2   FROM user_updatable_columns
  3*  WHERE table_name = 'LOI_FP_AREAS_VIEW'
oracle@CVLPL> /

COLUMN_NAME                    UPD INS DEL
------------------------------ --- --- ---
AGENT_NUM                      YES YES YES
SCAC                               YES YES YES
LOI_DATE                         YES YES YES
LOI_REPL_DATE                 YES YES YES
AREA                               NO  NO  NO
LOI_CANCEL_DATE             YES YES YES
BOOKING_AGENT               YES YES YES
GBLOC                             YES YES YES

8 rows selected.
My question is when I use the view in my Oracle Forms 6i and try to do an update it does not allow me. I'm using Oracle 8i on windows NT. Does anyone has any clue as to what I am missing? Thanks.