This content has been marked as final. Show 3 replies
Hope this query helps
(select segment1 from mtl_system_items_b where inventory_item_id = w.INVENTORY_ITEM_ID and organization_id = :id) Item,
(select organization_code from mtl_parameters where organization_id = w.ORGANIZATION_ID) org_code,
from wsh_deliverables_v w where w.RELEASED_STATUS_NAME = 'Shipped'
AND W.CREATION_DATE BETWEEN :PFROM AND :PTO
You can get the sales for specific org. and period using Material Transaction form in inventory.
Navigation path is :
Responsibility = Inventory > Transactions > Material Transactions > Select specific inventory organization > Input Transaction date = 01/01/2012 & 19/12/2009 > Input Transaction Type = Sales order issue > Select FIND button > you will get the required information.
After getting this information, you can directly export it in excel sheet.
Edited by: Sanjay Desai on Dec 26, 2012 8:44 AM