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;
Onhand and trx queries.
Who is online
Users browsing this forum: No registered users and 9 guests