This actually happens with all of the reports that I have tried to create so far, so I'm posting all the SQL's.

1.
SELECT
RESTORE_LOG."DATE_TIME", RESTORE_LOG."CONTACT_ID", RESTORE_LOG."NO_TAPES_REQ", RESTORE_LOG."EMERGENCY_Y_N", RESTORE_LOG."ENTERED_BY",
CONTACT."CONTACT_NAME",
SBU_LOOK."SBU_NAME"
FROM
"PHL_OWNER"."RESTORE_LOG" RESTORE_LOG,
"PHL_OWNER"."CONTACT" CONTACT,
"PHL_OWNER"."SBU_LOOK" SBU_LOOK
WHERE
RESTORE_LOG."CONTACT_ID" = CONTACT."CONTACT_ID" AND
CONTACT."SBU_NO" = SBU_LOOK."SBU_NO" AND
CONTACT."SBU_NO" = SBU_LOOK."SBU_NO"
ORDER BY
SBU_LOOK."SBU_NAME" ASC


2.
SELECT
RESTART_LOG."REST_JOB_NAME", RESTART_LOG."JOB_CLASS_NO", RESTART_LOG."SBU_NO", RESTART_LOG."RESOLVED_BY_NO",
RES_BY_LOOK."RESOLVED_BY_NAME",
JOB_CLASS_LOOK."JOB_CLASS_NAME",
SBU_LOOK."SBU_NAME"
FROM
"PHL_OWNER"."RESTART_LOG" RESTART_LOG,
"PHL_OWNER"."RES_BY_LOOK" RES_BY_LOOK,
"PHL_OWNER"."JOB_CLASS_LOOK" JOB_CLASS_LOOK,
"PHL_OWNER"."SBU_LOOK" SBU_LOOK
WHERE
RESTART_LOG."RESOLVED_BY_NO" = RES_BY_LOOK."RESOLVED_BY_NO" AND
RESTART_LOG."JOB_CLASS_NO" = JOB_CLASS_LOOK."JOB_CLASS_NO" AND
RESTART_LOG."SBU_NO" = SBU_LOOK."SBU_NO"
ORDER BY
RES_BY_LOOK."RESOLVED_BY_NAME" ASC,
JOB_CLASS_LOOK."JOB_CLASS_NAME" ASC,
SBU_LOOK."SBU_NAME" ASC

3.
SELECT
RESTART_LOG."REST_JOB_NAME", RESTART_LOG."JOB_CLASS_NO", RESTART_LOG."SBU_NO", RESTART_LOG."RESOLVED_BY_NO",
SBU_LOOK."SBU_NAME",
RES_BY_LOOK."RESOLVED_BY_NAME",
JOB_CLASS_LOOK."JOB_CLASS_NAME"
FROM
"PHL_OWNER"."RESTART_LOG" RESTART_LOG,
"PHL_OWNER"."SBU_LOOK" SBU_LOOK,
"PHL_OWNER"."RES_BY_LOOK" RES_BY_LOOK,
"PHL_OWNER"."JOB_CLASS_LOOK" JOB_CLASS_LOOK
WHERE
RESTART_LOG."SBU_NO" = SBU_LOOK."SBU_NO" AND
RESTART_LOG."RESOLVED_BY_NO" = RES_BY_LOOK."RESOLVED_BY_NO" AND
RESTART_LOG."JOB_CLASS_NO" = JOB_CLASS_LOOK."JOB_CLASS_NO"
ORDER BY
RES_BY_LOOK."RESOLVED_BY_NAME" ASC,
JOB_CLASS_LOOK."JOB_CLASS_NAME" ASC,
SBU_LOOK."SBU_NAME" ASC