DBA Data[Home] [Help]

APPS.AHL_OSP_QUERIES_PVT dependencies on MTL_ONHAND_QUANTITIES

Line 1601: Select nvl(sum(transaction_quantity),0) into l_apparent_quantity from mtl_onhand_quantities where

1597: 'and p_lot_number :' || p_lot_number
1598: );
1599: END IF;
1600:
1601: Select nvl(sum(transaction_quantity),0) into l_apparent_quantity from mtl_onhand_quantities where
1602: organization_id = p_org_id and
1603: inventory_item_id = p_inventory_item_id and
1604: subinventory_code = p_subinventory_code and
1605: --Added by mpothuku on 23rd Aug, 06 to fix the Bug 5252627