Hi, my code is here
CREATE MATERIALIZED VIEW IMAGE.FIRST_PRODUCTION_STAGE_MV (ORDER#,ITEM#,BUNDLE#,PIECES,STAGE#,START_DATE,UNIT#)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MAXSIZE UNLIMITED
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
NOCACHE
NOLOGGING
NOCOMPRESS
NOPARALLEL
BUILD IMMEDIATE
REFRESH COMPLETE ON DEMAND
WITH PRIMARY KEY
AS
SELECT w.order#,
w.item#,
w.bundle#,
w.pieces,
w.stage#,
w.creation_date start_date,
w.unit#
FROM abc w, xyz is2, cde oe
WHERE w.pieces > 0
AND w.item# = is2.item#
AND w.stage# = is2.stage# + 1
AND is2.sname = 'INDUCTION'
AND SUBSTR (w.order#, 1, 7) = oe.order#;
ORA-12018: following error encountered during code generation for "IMAGE"."FIRST_PRODUCTION_STAGE_MV"
ORA-00904: : invalid identifier
please help me to resolve this.