INV_TABLES

--Important Tables(Views)
--org_organization_definitions
--hr_operating_units
--Sample

SELECT *
  FROM hr_operating_units
 WHERE NAME = 'Vision Operations';

SELECT *
  FROM org_organization_definitions
 WHERE organization_name = 'Vision Operations';

SELECT *
  FROM org_organization_definitions
 WHERE organization_name = 'Seattle Manufacturing';

--SUb inv
SELECT *
  FROM mtl_secondary_inventories
 WHERE organization_id = 207 AND secondary_inventory_name = 'FGI';

--locator
SELECT *
  FROM mtl_item_locations;

SELECT *
  FROM mtl_units_of_measure_tl;

SELECT *
  FROM mtl_uom_classes_tl;

SELECT *
  FROM mtl_uom_conversions;

SELECT *
  FROM mtl_uom_class_conversions;

SELECT *
  FROM mtl_system_items_b
 WHERE segment1 = 'CM11062';

SELECT *
  FROM mtl_onhand_items_v
 WHERE inventory_item_id = 858 AND organization_id = 207;

SELECT *
  FROM mtl_onhand_quantities_detail
 WHERE inventory_item_id = 858
   AND organization_id = 207
   AND subinventory_code = 'FGI';

SELECT *
  FROM mtl_material_transactions
 WHERE inventory_item_id = 858 AND TRUNC (creation_date) = TRUNC (SYSDATE);