查看订单预留信息

前几天忙得忘记了,已经找过,今天又多于找3个小时(研究ORACLE 订单FORM),真浪费时间

[@more@]

INV->On hand->RESERVATIONS SALES ORDER , 组合

订单预留 demand_source_type_id = 2
/* Formatted on 2007/03/13 19:11 (Formatter Plus v4.8.7) */
SELECT r.demand_source_type_id, r.demand_source_name,
r.demand_source_header_id, r.demand_source_line_id,
r.demand_source_delivery, r.*
FROM mtl_reservations r,
mtl_system_items_b msi,
oe_order_headers_all h,
oe_order_lines_all l
WHERE r.inventory_item_id = msi.inventory_item_id
AND r.demand_source_type_id = 2
AND r.demand_source_line_id = l.line_id
AND h.header_id = l.header_id
AND h.order_number = 235
AND msi.organization_id = 204

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

转载于:http://blog.itpub.net/226700/viewspace-907470/