SQL Error table name issue

Hi  Folks, I am making great progress, we are almost there... THis SQL Which was posted last week, needs one thing it seems the table name.file name is not the correct way. If I understand,
the file name OEORH41 used in the FROM cannot be used also on the INNER JOIN?
 
QL State: 42703
Vendor Code: -5001
Message: [SQL5001] Column qualifier or table OEORH41 undefined. Cause . . . . . :   Name OEORH41 was used to qualify a column name or was specified as the operand of the RRN, HASHED_VALUE, PARTITION, NODENAME, NODENUMBER, DBPARTITIONNAME, DBPARTITIONNUM, DATAPARTITIONNAME, or DATAPARTITIONNUM scalar function.  The name is not defined to be a table designator in this SQL statement or the table designator cannot be referenced where it is specified in the SQL statement. If a correlation name is specified following the table name in a FROM clause, the correlation name is considered to be the table designator.  If a correlation name is not specified, the table name is considered to be the table designator.  If using SQL naming and the table is qualified with authorization name, then the table designator is authorization-name.table-name.  If the authorization name is not specified, the table designator is the implicit authorization name followed by the
table name. Correlation from a nested table expression to a higher level table is only allowed if the TABLE keyword is used for the definition of the nested
table expression. If the name is *N, a lateral correlation reference from a nested table expression is not allowed.  You can not correlate to a table at a higher level than the nested table expression for one of the following reasons: --
 The nested table expression contains a UNION, EXCEPT, or INTERSECT. -- The nested table expression uses the DISTINCT keyword in the SELECT clause. -- The nested table expression contains an ORDER BY clause. -- The correlated provider is in the same FROM clause as the nested table expression but is part of a RIGHT OUTER JOIN or RIGHT EXCEPTION JOIN. -- The nested table expression is in the FROM clause of another nested table expression
that contains one of these restrictions. In an OLAP function, the ORDER OF table designator must refer to a table designator in the FROM clause of the subselect. Recovery  . . . :   Ensure all column names are qualified with a valid table
designator.  Make sure a table designator is specified as the argument to the function.  Use the TABLE keyword to allow correlated columns within a nested table expression. Try the request again.
---- sql query
 
SELECT
    NOTEH6.UARIDC
 , NOTEH6.UANOTL
 , NOTEP1.UCCMT
 , OEORH41.OHORD#
 , OEORH41.OHOSTC
 , OEORH41.OHORDT
 , OEORH41.OHORDD
 , OEORH41.OHPO#
 , OEORH41.OHSHTC
 , OEORH41.OHSLR#
 , OETRA95.OTTRNC
 , REFER1.RFCAT
 , REFER1.RFDAT
 
FROM       ASTCCDTA.OEORH41
 INNER JOIN REFER1
   ON   OEORH41.OHSHTC = REFER1.RFSLC
 INNER JOIN OETRA95
   ON   OEORH41.OHCOM# = OETRA95.OTCOM#
 
   AND OEORH41.OHORD# = OETRA95.OTORD#
 
INNER JOIN NOTEH6
   ON   OEORH41.OHENT# = NOTEH6.UAENT#
 
   AND OEORH41.OHSFX# = NOTEH6.UASFX#
 
INNER JOIN NOTEP1
   ON   NOTEH6.UANOTT  = NOTEP1.UCNOTT
 
   AND NOTEH6.UANTK   = NOTEP1.UCNTK
    AND NOTEH6.UANOT#  = NOTEP1.UCNOT#
 WHERE NOTEH6.UARIDC  = 'UA'
    and OETRA95.OTTRNC = '001'
        /* !! Note: use special reg  below !! */
    and OEORH41.OHORDD = CURRENT DATE
        /* !! Note: use IN predicate below !! */
    and OEORH41.OHORDT IN ('COC', 'COE', 'COF', 'COR', 'COS')
        /* !! Note: missing operator below !! */
    AND OEORH41.OHOSTC <> 'CN'  /* <-- "AND" was presumed+added */
    and REFER1.RFCAT   = '0023'