Oracle EBS-SQL (INV-9):检查搬运单分配异常.sql
select
h.request_number,
l.line_number,
msib.segment1
item_code,
t.transaction_temp_id,
t.transaction_quantity,
l.quantity
from mtl_material_transactions_temp
t,
mtl_txn_request_headers
h,
mtl_txn_request_lines
l,
mtl_system_items_b
msib
where t.move_order_header_id = h.header_id
and
t.inventory_item_id = msib.inventory_item_id
and
t.organization_id = msib.organization_id
and
t.move_order_line_id =l.line_id
and t.organization_id =
l.organization_id
and t.move_order_line_id is not
null
and t.transaction_type_id=35
and
t.transaction_quantity<0
order by request_number,
line_number;
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
