Translate

Wednesday, February 27, 2013

On Hand Quantity in R12 TABLE Detail

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 ...



2 comments:

  1. The table name is wrong, right table is :mtl_onhand_quantities_detail

    ReplyDelete