--通过 I/O number 找到邮寄号码
select wda.delivery_id,ol.shipment_number , ol.unit_cost,ol.*-- delivery_id 邮寄号码 :80514
from
oe_order_headers_all oh,
oe_order_lines_all ol,
wsh_delivery_assignments wda,
wsh_delivery_details wdd
where
oh.header_id=ol.header_id
and
ol.line_id=wdd.source_line_id
and wdd.delivery_detail_id=wda.delivery_detail_id
and oh.order_number=1206400049[@more@]
select wda.delivery_id,ol.shipment_number , ol.unit_cost,ol.*-- delivery_id 邮寄号码 :80514
from
oe_order_headers_all oh,
oe_order_lines_all ol,
wsh_delivery_assignments wda,
wsh_delivery_details wdd
where
oh.header_id=ol.header_id
and
ol.line_id=wdd.source_line_id
and wdd.delivery_detail_id=wda.delivery_detail_id
and oh.order_number=1206400049[@more@]
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/226700/viewspace-850887/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
如何查找某个报表在哪个权限下运行
下一篇：
Oracle数据库连接常见问题诊断
请登录后发表评论
登录
全部评论
