Oracle Database Discussions

I am facing ora-00904 error while running the below mentioned query on my production database.
When I execute the same query on my test database it runs fine without any errors.
If I comment out line 29 "OR" 30 then it runs fine on the production database.
Version of production/test database is 9.2.0.8
Any idea how to resolve this issue?

SQL> SELECT
2 RB.CURRENTPO,RB.LOTNO,COLORS.NAME COLOR,
3 FABRIC.NAME FABRIC,RB.SIZEWIDTH,RB.OLDRBARCODE,RB.RBARCODE,
4 SUM(DECODE(FABRICTYPE,'M',NVL(RB.FINISHWT,RB.CURRGREIGEWT))) MAINBODYWT,
5 SUM(DECODE(FABRICTYPE,'M',0,NVL(RB.FINISHWT,RB.CURRGREIGEWT))) TRIMWT,
6 SUM(NVL(RB.FINISHWT,RB.CURRGREIGEWT)) TOTALWT,
7 SUBSTR(DOCTYPE.DESCRIPTION,1,100) STATUS,
8 ----
9 MAX((SELECT MAX(MADEDATE) FROM LOTMAKEM WHERE LOTNO=NVL(RB.LOTNO,'XX'))) MADEDATE,
10 ---
11 MAX((SELECT MAX(INSPDATE) FROM FFINSPECTIONM WHERE LOTNO=NVL(RB.LOTNO,'XX'))) QCINSPDATE,
12 ---
13 MAX((SELECT MAX (DOCUMENTDATE) FROM FFABRICLEDGER WHERE LOTNO=NVL(RB.LOTNO,'XX')
14 AND DOCUMENTTYPE='FRIN')) FFRCVDATE
15 FROM
16 ROLLBARCODE RB,FABRIC,COLORS,DOCTYPE,POM
17 WHERE
18 RB.CURRENTPO='FTL-NBBSH-ABC'--:P_PO
19 AND RB.FABRICCODE=FABRIC.FABRICCODE
20 AND RB.COLORCODE=COLORS.COLORCODE(+)
21 AND RB.CURRSTATUS=DOCTYPE.DOCTYPE
22 AND DOCTYPE.TABLE_NAME='ROLLBARCODE'
23 AND DOCTYPE.COLUMN_NAME='CURRSTATUS'
24 AND RB.CURRENTPO=POM.FPO
25 AND RB.CURRSTATUS NOT IN ('GI','GR','FR','FI','TP','RI','RR','LW','SR','ER','EI','TF')
26 AND NOT EXISTS (SELECT 'S' FROM INTRANSITNOTESM TM,INTRANSITNOTESD TD
27 WHERE TM.DOCUMENTNO=TD.DOCUMENTNO
28 AND TM.DOCUMENTTYPE=TD.DOCUMENTTYPE
29 AND TD.RBARCODE =RB.RBARCODE
30 AND TM.PURPOSECODE=172 AND TM.DOCUMENTTYPE='ITSOI')
31 GROUP BY
32 RB.CURRENTPO,RB.LOTNO,COLORS.NAME,FABRIC.NAME,
33 DOCTYPE.DESCRIPTION,RB.SIZEWIDTH,RB.OLDRBARCODE,RB.RBARCODE
34 HAVING
35 SUM(NVL(RB.FINISHWT,RB.CURRGREIGEWT)) > 0;
SUM(DECODE(FABRICTYPE,'M',NVL(RB.FINISHWT,RB.CURRGREIGEWT))) MAINBODYWT,
*
ERROR at line 4:
ORA-00904: "RB"."RBARCODE": invalid identifier