Oracle erp OM模块放delivery的Table 先谢过了
展开全部
SELECT wnd.delivery_id,
wdd.lot_number,
wnd.confirm_date,
wdd.source_header_id,
wdd.source_line_id,
wdd.shipped_quantity,
wdd.inventory_item_id
FROM wsh_delivery_details wdd,
wsh_delivery_assignments asg,
wsh_new_deliveries wnd
WHERE wnd.delivery_id = asg.delivery_id
AND asg.delivery_detail_id = wdd.delivery_detail_id
AND wnd.status_code = 'CL'
wdd.lot_number,
wnd.confirm_date,
wdd.source_header_id,
wdd.source_line_id,
wdd.shipped_quantity,
wdd.inventory_item_id
FROM wsh_delivery_details wdd,
wsh_delivery_assignments asg,
wsh_new_deliveries wnd
WHERE wnd.delivery_id = asg.delivery_id
AND asg.delivery_detail_id = wdd.delivery_detail_id
AND wnd.status_code = 'CL'
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
