DELIVERY DETAIL FRIGHT ON BOARD

select  oola.ordered_item , wdd.REQUESTED_QUANTITY ,
oola.UNIT_SELLING_PRICE ,
sum(wdd.REQUESTED_QUANTITY*oola.UNIT_SELLING_PRICE) extended_price
     from       wsh_delivery_assignments wda ,
                wsh_delivery_details wdd,
                oe_order_lines_all oola
                where wda.delivery_detail_id = wdd.delivery_detail_id
                and wda.delivery_id = '1236'
                and wdd.source_header_id =  oola.header_id
                and wdd.source_line_id = oola.line_id
              --  and oola.ordered_item = '15400RAFT01'
              --  and wdd.inventory_item_id = oola.inventory_item_id
                group by oola.ordered_item , wdd.requested_quantity , oola.unit_selling_price