DBA Data[Home] [Help]

APPS.WMS_POSTALLOC_PVT dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 2742: INTO l_qoh FROM mtl_onhand_quantities_detail

2738: IF (v1.allocated_lpn_id IS NOT NULL ) THEN --{
2739: error_code := 'CARTONIZE 120';
2740:
2741: SELECT NVL(SUM(primary_transaction_quantity),0)
2742: INTO l_qoh FROM mtl_onhand_quantities_detail
2743: WHERE organization_id = v1.organization_id
2744: AND subinventory_code = v1.subinventory_code
2745: AND locator_id = v1.locator_id
2746: AND lpn_id = v1.allocated_lpn_id;