Total Pageviews

February 6, 2015

2/06/2015 10:57:00 PM
SELECT   msib.inventory_item_id item_num,
         haout.name inv_org_name,
         msi.secondary_inventory_name sub_inv_name,
         moq.transaction_quantity on_hand_quantity
  FROM   mtl_system_items_b msib,
         mtl_onhand_quantities moq,
         mtl_secondary_inventories msi,
         hr_all_organization_units_tl haout
 WHERE       msib.inventory_item_id = moq.inventory_item_id
         AND msib.organization_id = msi.organization_id
         AND msib.organization_id = haout.organization_id
         AND msi.secondary_inventory_name = moq.subinventory_code
         AND msib.inventory_item_id = '171'
         AND haout.name = 'Seattle Manufacturing'