摘要：
select mtl_lot.inventory_item_id,mtl_lot.organization_id,mtl_lot.locator_id ,ltrim( max(sys_connect_by_path(mtl_lot.LOT_NUMBER, ',') ),',') lot_number from (SELECT moq.inventory_item_id ,moq.organization_id ,moq.locator_id ,moq.LOT_NUMBER , row_number() over(PARTITION BY moq.inventor 阅读全文
posted @ 2011-10-25 15:40 奥客 阅读(279) 评论(0) 推荐(0) 编辑