OM 中通过发票找Order headers和lines 等相关信息[@more@]SELECT oh.order_number, ol.line_number, SUBSTR (ol.ordered_item, 1, 2),
wnd.waybill, wnd.creation_date, hp.party_name,
oh.transactional_curr_code, ol.ordered_quantity, ol.UNIT_SELLING_PRICE
FROM oe_order_headers_all oh,
oe_order_lines_all ol,
wsh_new_deliveries wnd, --delivery
wsh_delivery_details wdd,
wsh_delivery_assignments wda,
hz_parties hp --customer
WHERE oh.header_id = ol.header_id
AND wdd.source_header_id = oh.header_id
AND wdd.source_line_id = ol.line_id
AND wnd.delivery_id = wda.delivery_id
AND wdd.delivery_detail_id = wda.delivery_detail_id
AND hp.party_id = oh.sold_to_org_id
--AND oh.order_number = 2906000024
AND wnd.waybill = '68713545' --invoice_num