SQL & PL/SQL :: Generate List Of Programs On All Channels For Specific Day?

I need to generate a list of the programs on all channels for a specific day showing the channel number, supplier, package, program name, rating code, and show time. This will be similar to a program guide, only not package specific. This is a date-driven report, therefore it should only display programs for a single date specified. This is what I have but I cannot get it to run.

CREATE VIEW PROG_LINEUP AS
SELECT DISTINCT S.PROGTIME AS "SHOWTIME", S.PROGNAME AS "PROGRAM TITLE",
C.CHNUM AS "CHANNEL #", SU.SUPNAME AS "SUPPLIER", R.RATING AS "RATING"
FROM SCHEDULE S, CHANNELS C, SUPPLIERS SU INNER JOIN
PROGRAM P ON P.PROGNAME = S.PROGNAME INNER JOIN
CHANNEL_PACKAGE CP ON CP.CHID = S.CHID
INNER JOIN RATING R ON R.RATINGID = P.RATINGID
WHERE S.PROGTIME = '18-DEC-10'
ORDER BY S.CHID;