Onhand and trx queries.

[admin]

a. select * from mtl_onhand_quantities_detail where organization_id = rganization_id and inventory_item_id = :inventory_item_id;

b. select * from mtl_material_transactions where organization_id = rganization_id and inventory_item_id = :inventory_item_id;