SQL: global temporary table with left outer join

[fkany@xxxxxxxxxxxxxxxxxx]

The SQL statement below runs perfect without the 'LEFT OUTER JOIN' and
CT1AB & CT1REG fields.  When I try to run the SQL below, I get this error
message "FR47ONTIME in *LIBL type *N not found. "   FR47ONTIME does exist
because the SQL statement works without the 'LEFT OUTER JOIN'.  Can anyone
see what's wrong?

Thanks,

Frank

DECLARE GLOBAL TEMPORARY TABLE FR47P457X AS (SELECT FR47LATE(FHOT,
FHPRO, FHPUDT, FHDADT, FHDDAT, FHSCD, FHDT, FHCCD, FHCCT, FHCST,
FHCZIP) AS LATE,
                                                    FR47LATE1(FHOT,
FHPRO, FHPUDT, FHDADT, FHDDAT, FHSCD, FHDT, FHCCD, FHCCT, FHCST,
FHCZIP) AS LATE1,
                                                    FR47LATE2(FHOT,
FHPRO, FHPUDT, FHDADT, FHDDAT, FHSCD, FHDT, FHCCD, FHCCT, FHCST,
FHCZIP) AS LATE2,

                                                    FR47TRANS(FHOT,
FHPRO, FHPUDT, FHDADT, FHDDAT, FHSCD, FHDT, FHCCD, FHCCT, FHCST,
FHCZIP) AS TRANS,

                                                   FR47ONTIME(FHOT,
FHPRO, FHPUDT, FHDADT, FHDDAT, FHSCD, FHDT, FHCCD, FHCCT, FHCST,
FHCZIP) AS ONTIME,

FHOT, FHPRO, FHDT, FHDDAT, FHDTIM, FHDADT, FHPUDT,
FHSCD, FHCCD, FHCCT, FHCZIP, CT1REG FROM FRL00144
LEFT OUTER JOIN AAP030 ON FHOT = CT1AB

WHERE
FHDDAT >= 20040501 AND FHDDAT <= 20040505
AND CT1REG = '1 ') WITH DATA