Select moq.organization_id as org_id,
sysdate as date_val,
moq.inventory_item_id as item_id,
moq.subinventory_code as subinventory_code,
moq.locator_id as locator_id,
moq.lot_number as lot_number,
msi.segment1 as item,
msi.primary_uom_code as uom_code,
sum(moq.primary_transaction_quantity) as actual_qty
from mtl_onhand_quantities_detail moq,
mtl_system_items_b msi
where 1=1
-- msi
and msi.inventory_item_id = moq.inventory_item_id
and msi.organization_id = moq.organization_id
--and moq.inventory_item_id = :1
--and moq.organization_id = :2
--and moq.subinventory_code = :3
--and moq.lot_number = :4
group by moq.organization_id ,
sysdate,
moq.inventory_item_id,
msi.segment1,
msi.primary_uom_code,
moq.subinventory_code,
moq.locator_id,
moq.lot_number
order by moq.organization_id, moq.inventory_item_id
Так же есть API для просмотра текущего количества OEBS API INV – Текущее количество для позиции (ONHAND)
Последние комментарии