APPS.WMS_CONTAINER_PUB dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 3739: FROM mtl_onhand_quantities_detail

3735: END IF;
3736:
3737: SELECT COUNT(1)
3738: INTO l_valid
3739: FROM mtl_onhand_quantities_detail
3740: WHERE organization_id = l_organization_id
3741: AND lpn_id = p_lpn_id;
3742:
3743: IF l_valid > 0 THEN

Line 3747: l_table_name := 'MTL_ONHAND_QUANTITIES_DETAIL';

3743: IF l_valid > 0 THEN
3744: IF l_debug = 1 THEN
3745: mdebug('LPN : '||p_lpn_id||' is currently present in MOQD, cannot reuse');
3746: END IF;
3747: l_table_name := 'MTL_ONHAND_QUANTITIES_DETAIL';
3748: RAISE l_transactions_pending;
3749: END IF;
3750:
3751: SELECT COUNT(1)