APPS.WMS_TASK_LOAD dependencies on MTL_ONHAND_QUANTITIES_DETAIL
Line 9714: FROM mtl_onhand_quantities_detail
9710: -- bug 3983704
9711: -- get the packed qoh since the qty tree always return for both loosepack
9712: SELECT NVL(SUM(primary_transaction_quantity),0), NVL(SUM(secondary_transaction_quantity),0)
9713: INTO l_qoh, l_sqoh 9714: FROM mtl_onhand_quantities_detail 9715: WHERE lpn_id = p_fromlpn_id
9716: AND organization_id = p_org_id;
9717:
9718: IF (p_trx_uom <> l_primary_uom) THEN