Query to get Onhand Quantity with OrganizationId

Query to get Onhand Quantity with OrganizationId, www.askhareesh.com


  SELECT organization_id,
         (SELECT (   msib.segment1
                  || msib.segment2
                  || msib.segment3
                  || msib.segment4)
            FROM mtl_system_items_b msib
           WHERE msib.inventory_item_id = moq.inventory_item_id
                 AND msib.organization_id = moq.organization_id)
            ItemName,
         (SELECT description
            FROM mtl_system_items_b msib
           WHERE msib.inventory_item_id = moq.inventory_item_id
                 AND msib.organization_id = moq.organization_id)
            itemDescription,
         SUM (moq.transaction_quantity) onhandqty
    FROM mtl_onhand_quantities moq
   WHERE moq.organization_id = 204
GROUP BY moq.organization_id, moq.inventory_item_id


*/

No comments:

Post a Comment