FROM
MES_LOT a,
SHBY1_DC_372_SLIP_SOLIDS b,
MES_TRANSACTION_LOG MES_TRANS_LOG_SHBY_PAR_CR,
MES_LOT MES_LOT_SHIPPING,
MES_TRANSACTION_LOG MES_TRANS_LOG_SHBY_COAT,
SHBY1_TBL_LOTID_MAP c,
SHBY1_TBL_REEL_MAP d
WHERE
c.COATCASTLOTID=a.LOT_ID
AND MES_TRANS_LOG_SHBY_COAT.LOT_ID=c.COATCASTLOTID
AND MES_TRANS_LOG_SHBY_COAT.UNDONE='FALSE'
AND MES_TRANS_LOG_SHBY_COAT.PLANT_LOCATION='SHBY1'
AND b.LOTID=c.SLIPLOTID
AND b.SUPERSEDED='FALSE'
AND d.COATCASTLOTID=c.COATCASTLOTID
AND MES_TRANS_LOG_SHBY_PAR_CR.LOT_ID=MES_LOT_SHIPPING.LOT_ID
AND d.SLITLOTID=MES_TRANS_LOG_SHBY_PAR_CR.LOT_ID
AND MES_TRANS_LOG_SHBY_PAR_CR.UNDONE='FALSE'
AND MES_TRANS_LOG_SHBY_PAR_CR.PLANT_LOCATION='SHBY1'
AND MES_TRANS_LOG_SHBY_PAR_CR.TRANSACTION_NAME='CREATE/RECEIVE'
AND MES_TRANS_LOG_SHBY_PAR_CR.OPERATION_NAME='395_SHIPPING'
AND a.SHBY1_CREATE_DATE IS NOT NULL
AND MES_TRANS_LOG_SHBY_COAT.ACTUAL_DATE > '01-JAN-01'
AND MES_TRANS_LOG_SHBY_COAT.TRANSACTION_NAME = 'COMPLETE'
GROUP BY
a.LOT_ID,
DECODE(a.DIEL_BETA,NULL,' ',SUBSTR(a.DIEL_BETA,1,2)),
DECODE(a.DIEL_BETA,NULL,' ',SUBSTR(a.DIEL_BETA,3,4)),
a.MATERIAL_NAME,
b.PCTSOLIDS)

> Hi All,>> I am trying to create a materialized view that contains a subquery for
the
> FROM clause. I can run the sql in the view fine, but when I try to
create
> the view I get the following error:>> MES_LOT a,> *> ERROR at line 27:> ORA-00998: must name this expression with a column alias>> This is the first table listed in the subquery. As you can see, I have
the
> table aliased. Does anyone have an idea of what could be causing this> error, or what I am doing wrong?>> Thanks;> Terri Williamson> Kemet Electronics> TerriWilliamson_at_Kemet.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Terri Williamson/MIS/HQ/KEMET/US
INET: TerriWilliamson_at_kemet.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).