ITPub博客

首页 > 数字化转型 > ERP > OM 中通过发票找Order headers和lines 等相关信息

OM 中通过发票找Order headers和lines 等相关信息

原创 ERP 作者:moonsoft 时间:2019-02-26 08:51:05 0 删除 编辑
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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/226700/viewspace-842388/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 让人失望的法国
请登录后发表评论 登录
全部评论

注册时间:2005-01-20

  • 博文量
    412
  • 访问量
    331592