Report on order details shipped (X) days

select a.ORDER_NUMBER,a.ORDERED_DATE,a.ORDER_CATEGORY_CODE,a.ORDER_TYPE_ID,a.TRANSACTIONAL_CURR_CODE,
b.LINE_NUMBER,b.ORDERED_ITEM,b.PRICING_QUANTITY_UOM,b.SHIPPED_QUANTITY,b.SHIPMENT_NUMBER,b.REQUEST_DATE,
b.ACTUAL_SHIPMENT_DATE,c.ORGANIZATION_NAME SHIP_FROM_ORG,round(b.actual_shipment_date-b.request_date) days
from
oe_order_headers_all a,
oe_order_lines_all b,
org_organization_definitions c
where a.header_id=b.header_id and
b.SHIP_FROM_ORG_ID=c.ORGANIZATION_ID and
round(b.actual_shipment_date-b.request_date)>:ENTER_THE_DAYS