Total Pageviews

May 22, 2016

5/22/2016 04:05:00 PM
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:
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,
mmt.transaction_id,
msi.segment1||'.'||msi.segment2 item_code,
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
-- 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)

 
Related Posts Plugin for WordPress, Blogger...