隨手筆記

SELECT wnd.NAME,
       wdd.item_description,
       requested_quantity,
	   wdd.shipped_quantity,
       ooha.order_number "SO",
       oola.line_number "SO Line",
       oola.actual_shipment_date,
       wnd.ultimate_dropoff_date,
       wnd.initial_pickup_date
  FROM oe_order_headers_all     ooha,
       oe_order_lines_all       oola,
       wsh_delivery_details     wdd,
       wsh_delivery_assignments wda,
       wsh_new_deliveries       wnd
 WHERE wdd.source_code = 'OE'
   AND ooha.order_number = '訂單號碼'
   AND ooha.header_id = oola.header_id
   AND wdd.source_line_id = oola.line_id
   AND wdd.source_header_id = ooha.header_id
   AND wdd.delivery_detail_id = wda.delivery_detail_id
   AND wda.delivery_id = wnd.delivery_id