MTL_ATT_QTY_V
select 1 type ,moq.inventory_item_id ,moq.organization_id ,moq.revision ,moq.subinventory_code ,moq.locator_id ,moq.transaction_quantity ,moq.lot_number from mtl_onhand_quantities moq ,mtl_lot_numbers mln where mln.lot_number(+) = moq.lot_number and mln.inventory_item_id(+) = moq.inventory_item_id and mln.organization_id(+) = moq.organization_id union all select 2 ,mmtt.inventory_item_id ,mmtt.o..
2023. 1. 18.