Use the Intransit Value Report to report the value and quantity of items
in intransit inventory. These are items that are being transferred
between organizations using the intransit transfer method.
Query:
-- AND
Query:
SELECT ms.from_organization_id,
ms.from_subinventory,
ms.to_organization_id,
ms.to_subinventory,
ms.quantity,
ms.quantity* mmt.new_cost mtl_cost, ms.quantity*mmt.actual_cost act_cost, ms.from_subinventory,
ms.to_organization_id,
ms.to_subinventory,
ms.quantity,
mmt.transaction_id,
msi.segment1||'.'||msi.
msi.primary_uom_code, msi.description,
mmt.new_cost, mmt.actual_cost, mmt.transaction_cost
FROM mtl_supply ms, mtl_material_transactions mmt, rcv_shipment_lines rsl, mtl_system_items msi
WHERE --MS.to_organization_id = :p_organization_id msi.segment1||'.'||msi.
msi.primary_uom_code, msi.description,
mmt.new_cost, mmt.actual_cost, mmt.transaction_cost
FROM mtl_supply ms, mtl_material_transactions mmt, rcv_shipment_lines rsl, mtl_system_items msi
-- AND
ms.supply_type_code IN ('SHIPMENT', 'RECEIVING')
AND ms.destination_type_code = 'INVENTORY'
AND rsl.shipment_line_id = ms.shipment_line_id
AND mmt.transaction_id(+) = rsl.mmt_transaction_id
AND ms.from_organization_id = :p_org_id
AND msi.inventory_item_id = ms.item_id
AND msi.organization_id = ms.from_organization_id
AND ( mmt.transaction_action_id = 12
OR mmt.transaction_action_id = 21)
AND ms.destination_type_code = 'INVENTORY'
AND rsl.shipment_line_id = ms.shipment_line_id
AND mmt.transaction_id(+) = rsl.mmt_transaction_id
AND ms.from_organization_id = :p_org_id
AND msi.inventory_item_id = ms.item_id
AND msi.organization_id = ms.from_organization_id
AND ( mmt.transaction_action_id = 12
OR mmt.transaction_action_id = 21)
