Find On Hand Quantity in R12
R12 Tables To Find the On hand Quantity
on hand Quantity --> quantity from mtl_onhand_quantities_details
Allocated Quantity --> mtl_material_transactions_temp
Reserved Quantity --> mtl_reservations
Hope this Information will help you to develop simple SQL Scripts ...
Looks Good
ReplyDeleteThe table name is wrong, right table is :mtl_onhand_quantities_detail
ReplyDelete