Hourly Based Column Need
What you're trying to do is to pivot your data, which - if you're on Oracle 11g or higher - you can do like so:

SELECT team,
       buyer_name,
       style_no,
       item_no,
       receipt_date,
       hour1,
       hour2,
       hour3,
       ...
FROM   (SELECT wc.wc_name AS team,
               buy.name AS buyer_name,
               itm.style_no,
               itm.item_no,
               trunc(gr.receipt_date) receipt_date,
               to_char(dt, 'hh24') receipt_date_hr,
               jrd.qty
        FROM   INNER JOIN job j ON wc.wc_id = j.wc_id
               INNER JOIN Job_Receipt_Details jrd ON j.job_id = jrd.job_id
               INNER JOIN Grn_Receipt gr ON jrd.grn_no = gr.grn_no
               INNER JOIN item itm ON jrd.item_no = itm.item_no
               INNER JOIN "ORDER" ord ON itm.order_no = ord.order_no
               INNER JOIN buyer buy ON ord.buyer_id = buy.buyer_id
        WHERE  receipt_date &gt;= trunc(SYSDATE)
        AND    receipt_date &lt; trunc(SYSDATE) + 1)
PIVOT (SUM(qty) FOR receipt_date_hr IN ('00' AS hour1, 
                                        '01' AS hour2,
                                        '02' AS hour3,
                                        ...));


Note that I have changed your outer query's where clause to where receipt_date &gt;= trunc(sysdate) and receipt_date &lt; trunc(sysdate) + 1 to enable the use of any indexes involving the receipt_date column.

If there are no indexes on that column which might be used, then you could further simply it to where trunc(receipt_date) = trunc(sysdate).