Onhand and trx queries.
Posted: Sat May 28, 2016 7:13 am
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;
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;