===========================================================
===========================================================
查看订单预留信息
作者: moonsoft(http://moonsoft.itpub.net)发表于: 2007.03.29 17:09
分类: 分销
出处: http://moonsoft.itpub.net/post/15182/275634
---------------------------------------------------------------
前几天忙得忘记了,已经找过,今天又多于找3个小时(研究ORACLE 订单FORM),真浪费时间
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
