DBA Data[Home] [Help]

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